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 […]
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
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:
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)
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.