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..
Top Hirerchy level needs to aggregate
- 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
Thanks
Vinnusea
Vinnusea
- 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
Do a search for "N:" and "C:" in the rules guide.
Martin
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
Jodi Ryan Family Lawyer
- 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
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
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
Vinnusea