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