Filter Region using only branches with >0 Revenue when bursting report

[Londa]

Hello,

I have a dashboard report that bursts on multiple location levels (country, region and branch). In the detail filters there is a tuple for (current day, revenue) > 0. This works for the branch level burst.

However, when bursting at the higher levels, all branches are being included into the total for the region/country. This negatively impacts the "score" of the region.

Any insight is very much appreciated.

~L

[hespora]

Hi there,


personally, I have next to no experience with dimensional style reporting, however the consensus seems to be that "thou shalt not use detail filters" ;)

Advised reads are these:
http://www.cognoise.com/index.php/topic,18290.msg53585.html#msg53585
http://cognospaul.com/2012/01/29/why-detail-filters-should-never-be-used-in-olap/

[New_Guy]

Hi,
You have to use filter function to filter out the descendants of the higher level of branches,  filter(descendants([City],1), tuple([Day], [Revenue] <> 0)). This might not be the exact syntax. Try and let us know.
Thanks
New Guy