Analytic Views - Attribute Based Aggregation
All,
Is there a way to enable attribute based aggregation within Analytic Views? In addition, i see the ability to do a member based QDR but is it possible to make the QDR more generic rather than just based on a member. Let me try to give couple of examples of what i am trying to accomplish
Attribute Based Aggregation:
I have a hierarchy as shown below
A
----B +
---- C +
---- D -
----E -
So basically, both D and E need to flip signs while aggregating to A. This hierarchy is a 10000 member hierarchy and cannot be created as individual measures. So, i was thinking if i could store the aggregation property as an attribute and then create a calculated measure based on that property, sort of like Measure * case when property = + then 1 else -1 end, it should be straight forward. But the Analytic Views do not seem to support this.