Top Hirerchy level needs to aggregate

Post Reply
User avatar
vinnusea
Posts: 116
Joined: Thu Sep 23, 2010 6:12 pm
OLAP Product: TM1
Version: 10.2
Excel Version: 2010
Location: San Diego ,CA

Top Hirerchy level needs to aggregate

Post by vinnusea »

Hi
I have two Measures.
X and Y
Y is having Amounts and X is Empty and new

AIM:
Y must have Values of X whose Product Attribute value is 1.
This Product attribute is assigned for C level Product Group.

So For All Product Groups who is having Attribute 1 Amount must is flown to Y Measure.

[Y Measure] = If Attr('Products', !PRoducts,'Amount Flag') =1 ,[X measure],Stet);

By above rule my Y measure is populated with amounts of product group whose attr is 1 .

ISSUE:

I need The Top leve of Product Group value (Attr =2) is showing zero
i want this TOp level of Y measure to be a aggregate value of values in Y mesure.
How can i do it..

Thanks..
Thanks
Vinnusea
User avatar
Martin Ryan
Site Admin
Posts: 2003
Joined: Sat May 10, 2008 9:08 am
OLAP Product: TM1
Version: 10.1
Excel Version: 2010
Location: Wellington, New Zealand
Contact:

Re: Top Hirerchy level needs to aggregate

Post by Martin Ryan »

Do a search for "N:" and "C:" in the rules guide.

Martin
Please do not send technical questions via private message or email. Post them in the forum where you'll probably get a faster reply, and everyone can benefit from the answers.
Jodi Ryan Family Lawyer
User avatar
vinnusea
Posts: 116
Joined: Thu Sep 23, 2010 6:12 pm
OLAP Product: TM1
Version: 10.2
Excel Version: 2010
Location: San Diego ,CA

Re: Top Hirerchy level needs to aggregate

Post by vinnusea »

Yes
Both C: and with out C: is same but when i use N: i dont get any data because Attribute value is 1 for only C: level Product Groups....

I need to pull X measure values at C: whose attr is 1 into Y measure

TOP level Hirerchy was having 0 attr as all then i changed it to 2 which is unique to TOP most level .
And tryin to use formula as

If attr of Product dim is 2 then apply no rule just aggregate all values in Y measure ------- this am not able to commplish
Thanks
Vinnusea
Post Reply