Database DataWarehousing (MOSC)

MOSC Banner

Analytic Views - Attribute Based Aggregation

edited Oct 16, 2019 12:15PM in Database DataWarehousing (MOSC) 5 commentsAnswered ✓

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center