Level based Measures in Calc view

[Former Member]

Hi,

We have several accounts associated with each Location. And one can create orders attached to each account. Now I am trying to create a measure that gives me the count of all Accounts in a Location that have Revenue greater than $100K. So firstly the Revenue of each Order needs to be summed up by the Account and then I need to take the count of all such accounts that have Revenue > $100K. Logically I know that this is a Level based Measure. So whenever someone selects Location in BO and this measure then this should give this count.

Am not sure how this can be created in Hana. Please help me...

[lbreddemann]

Hi Shree,

this requirement is not too difficult to fulfill. You may want to look into either multi-level aggregation SQL (maybe using HAVING clause) or by employing restricted key figures/measures.

I guess this is bread and butter modelling for any report developer/modeler...

Cheers,

Lars