Hello community
Hope you help me on this Challenge.
I work in an active report in cognos BI 10.2.2 with dimensional model (TM1 cubes).
I have 5 data items, all set with the same logic:
Name : « ProductSet1 », Expression:
filter ( descendants ( [SameParentMember] ;3) ; [SameAttributeName] = 'Attribute1' )
I want to aggregate the 5 data items, so I created 5 other data items with this expression:
aggregate (currentMeasure within set [ProductSet1] )
=> The question is how to aggregate multiple aggregations in one data item?
I tried, with errors, using this expression:
aggregate (currentMeasure within set [ProductSet1], [ProductSet2], [ProductSet3], [ProductSet4], [ProductSet5])
The purpose is to use this one aggregation in series of PackedBubble visualization... so that each bubble tie in ProductSet (In total we would have always 5 specific bubbles). At the same time, this visualization would filter on another chart and crosstab according to the selected bubble.