WEBI Report Use of Variable in Drill Down

[Former Member]

Hi,

i am new to BI Webi report just doing some practice exercise from E fashion Universe. Need your help in creating a WEBI report which should show Sales Revenue broken down to half-year level.

For example:

We have Year, when we drill Year 2004, it should not show Quarter infect i want to see 1st Half Year as Q1;Q2 and 2nd Half year as Q3;Q4 for that year.

For this i have created a Variable "Half Year"

=If([Quarter]InList("Q1";"Q2");"1st Half Year"; "2nd Half Year")

Is there anyway i can use this variable so when i drill Year it should Sales Revenue Broken as Half Year

Thanks

[Former Member · Accepted solution]

Hi Kamal,

1) Create Half Year object in Universe.

2) You can create custom Hierarchy in Universe like-

Year

Half Year

Quarter

Then you can drill down to Year>>Half Year>>Quarter

~Anuj

[Former Member · Accepted solution]

Thank you Anuj, Appreciated your response for new comer like me.

Is there anyway we can do this without modifying the Hierarchy in Universe?

[Former Member · Accepted solution]

If you don't want to modify existing Hierarchy, You can create alias of Year,and Quarter in universe and can create hierarchy.

Without creating hierarchy you will not be able to use drill down and drill up functionality in  Webi report.

[Former Member · Accepted solution]

Thanks a bunch Anuj, Really appreciated.