Showing results for 
Search instead for 
Did you mean: 

How to calculate values on Hierarchy node level in WEBI

0 Kudos

Hi Experts

I have a BI Query ,which have GL account Hierarchy(FSV) Drill down like

Revenue 213.15

Operating Expense 28.49

Revenue and Operating Expense are two node of the hierarchy ,similarly under these sub node and GL grouping is done in FSV(Hierarchy).

I need to calculate Operating Expenses % and report look like

Revenue 213.15

Operating Expense 28.49

Operating Expenses % 13%

i.e Operating Expences % = Operating Expences / Revenue *100

how It will done in Webi rich Client.



Accepted Solutions (0)

Answers (1)

Answers (1)

Product and Topic Expert
Product and Topic Expert
0 Kudos


You need to work with your Business to understand how these calculations are formulated in their definition, and how they are qualified and quantified. Next, you have to abstract that logic, and recreate it using the reporting interface of webintelligence. context is everything.

This is not something that can easily be explained over a text chat forum!!

I'd encourage you to work with a colleague who can deliver such reports in BObj, or, give it a go yourself using trial and error.