Business Objects 4.0 – Input Control / Select to Display Block

This gallery contains 17 photos.

Business Objects 4.1 – Setting a block to be displayed by selection within Input Controls (To follow this blog, I’m assuming you already know how to navigate within BO and you are familiar with creating and modifying documents). I’m sure you already know how to “hide when” within BO. (In case you don’t, instructions are […]

Adding custom column delimiter characters to CSV export options to WEBI

Recently I have run into needing to add more column delimiter options to CSV export in WEBI.

By default, it only has comma, semicolon and TAB as you can see in the screenshot below

Default CSV separators

After digging through some documents and searching around I didn’t find any official SAP solution to this and decided to take matters into my own hands and after fairly short search found the place where this setting is stored.

It is located in file called webiviewer.properties

There are a couple of copies of this file sprinkled around BO install, but we should only concern ourselves with ones located under webapps directory. All of the copies are identical and for simplicity and consistency sake we’ll change all of them.

Now to the procedure,

  • Stop SIA and Tomcat
  • Open all of the webiviewer.properties files you can find under webapps directory.
  • Locate following code:
    Code
  • Add your character(s) as per instructions in comments. Apply this change to all webiviewer.properties files in exact same way.
  • Save all of the files
  • Delete tomcat cache (Files located in Tomcat(#)/work/Catalina/localhost directory)
  • Start SIA and Tomcat.
  • Voila! In my case I’ve added a pipe character.
    Pipe added

This applies to both BO XI R4.0 and R3.1

Changing Default Webi A4 Paper Size

Hear is a quick Business Objects SAP 4.0 installation tip.  When SAP BusinessObjects Business Intelligence 4.0 is initially installed, the default page size is European A4, not the American standard Letter.

To change this setting, edit the Web Intelligence defaultconfig.xml file located in

<SAP BO Install Directory>\SAP BusinessObjects\Tomcat6\webapps\BOE\WEB-INF\eclipse\plugins\webpath.AnalyticalReporting\web\WEB-INF\classes

Change <FORMAT NAME=”A4″ ORIENTATION=”portrait”/> to <FORMAT NAME=”LETTER” ORIENTATION=”portrait”/>

This change is applicable only for the new Webi documents.  All of the previously created documents still have Portrait set to A4 and not to the Letter.

Enjoy