How to Aggregate based on attribute value?

[vinnusea]

hi
I have a measure and products dimension

For some products the Attr value is 1 and rest all products its 0

There is Top level in Products Dim --Total By Product

I want Total by Product to have aggregated values of products with attr value 1

(Note: For whom attr value is 1 their measure is having Values and All Other Attr measure value is zero)

[rkaif]

Double posting?

[vinnusea]

Think so..
Do you have any Idea how can it be DONE??????

[tomok]

['Filtered Amount']=N:IF(ATTRN('Product',!Product,FilterAttrName)=1,DB(Cube,Product, Dim2, Dim3,'Amount'),0);

[David Usherwood]

Or even

Code: Select all

['Filtered Amount'] = N: ['Amount'] * ATTRN('Product',!Product,FilterAttrName);

Not that what @tomok wrote wouldn't work. I just feel that shorter is generally better.

[lotsaram]

Or you can us a combination of TI and consolidations ...

Eg: have TI run through the dimension and if the attribute value is there then add the element to an alternate rollup. Not as dynamic as rules as it woudl require a user button click at some point but still very quick and much more efficient when it comes to memory use and calculation speed.

[vinnusea]

yes i think need to go with some TI process to make aggregate based on Attr values...

Will give it a try and update this link back

Thank you