Monday, July 28, 2014

Webi - Make up your own data groups

Ever wanted to created some data in a Webi Report?  The rigid boundary between you and the source database makes that quite difficult.  There are some new techniques that help in this regard. One such technique is a feature in BusinessObjects Webi called Grouping that makes it possible to group the values of dimensions into new values.  This can be very useful if you want to combine data into higher level groupings.

For example, say you had some product lines, and you wanted to group them into higher level categories for seasons.  You can now do this all by yourself without touching your source database.

Here is a video that shows how to do it.

Caveat:  Your system must be updated to at least 4.1 SP2.  Bring donughts to your system administrator if the system isn't already up-to-date.  Disclaimer:  I'm the system administrator for my system and I happen to love donughts!  Who doesn't?  :)

Another such more advanced technique is uploading an Excel document into the BI LaunchPad, but that is a topic for another day . . .

No comments:

Post a Comment