Level Based Measure Issue

Question

Hi,

I have created a level based measure . When I create a report by including the level based measures and other dimension (Dimension not pinned at the content level),

it creates a query with group by the dimension selected. is it that when ever we create level based measure we have to include the dimension member against which it

is pinned at the content level.

My requirement is that whenever we select the level based measure , it should create a seperate query with group by dimension member with which it is pinned at the content level.

Is there any setting I need to add.

Thanks.

Martin van Donselaar · Answer

Not sure what you want exactly

A level Based Measure always returns data at the grain (level) that you set it to.

Example of how your report will look like where Sales by region is a level based measure:

Sales By region is summed by region (Oracle usually uses analytical functions to calculate this). That is what you want, isn't it?