Grouping in a Webi report

building reports webintelligence
1

Hi All,
I have a Webi Xi R2 report, Where i need to provide costs (Actual to date,Forecast Final,Current budget,Performance cost) per location. When i add the cost fields to the report, It is showing a no of costs for the same Location.I need to group all the costs based on the location.Any ideas?
Hope the attachemnt would help

Thanks In advance
Reddy
Live.doc (44.0 KB)

lssreddy :uk: (BOB member since 2008-05-20)

2

Hi,

Grouping Values does not exist in Webi.

You may try to insert a break on the location
Or
Play with filters (or with the Where keyword)
Or
If you want to simulate the grouping values functionnality try somting like:

If([Location]=6;"group1";If([Location]=185;"group2";If([Location]=298;"group3";"Others")))

Good luck

superoliv :fr: (BOB member since 2008-06-17)

3

I dont think its easy to manage with the if condition, Beacause there are lot many locations!!! :hb:

lssreddy :uk: (BOB member since 2008-05-20)

4

It may not be an option to you, but I would consider building such a thing in the universe with CASE statements.

dessa :madagascar: (BOB member since 2004-01-29)

5

Thanks dessa
Can you explain me in a bit detail, with sample code please.

Thanks
Reddy

lssreddy :uk: (BOB member since 2008-05-20)

6

snippet…


CASE 
WHEN MY.OBJECT = 'AAA' THEN 'XXXX'
WHEN MY.OBJECT = 'BBB' THEN 'XXXY'
ELSE 
MY.OBJECT
END

dessa :madagascar: (BOB member since 2004-01-29)