Author: Kevin Morrell
Description: The following excel application is for anyone who has had to build the equivalent of a case statement in Web Intelligence and got confused when it comes to building cumbersome if then else statements…
By entering in the required information, the worksheet returns a webi formatted if then else statement that can be pasted into a Webi report.
This is by no means a replacement for well designed universe with decode or case statements or even better, a well designed datamart with complete dimensions. It is meant more for environments where access to database and universe development is limited.
Platform: Tested on BOXI, BO XIR2 (should work on BO 6.5)
Feel free to adapt, adjust and improve.
Have fun (hopefully this will save you some time)
[Case Builder version 2
Fixed bug that misses the first case.]
CaseBuilder.xls (38.0 KB)
keeweem (BOB member since 2003-06-02)