[TM1 10.2.2] Consolidate with MAX criteria w/ RULE [SOLVED]
Posted: Fri Dec 12, 2014 6:48 pm
Hi everybody! I'm on TM1 10.2.2, 64bit architecture and Excel 2007.
I have a problem trying to aggregate an element in my Measure dimension using Max criteria.
Here is my cube and what i wanted to do (the image are an Excel representation of what i see in Cube Viewer):
![Image](http://oi61.tinypic.com/mkdg6.jpg)
The concept is that for every node in the dimension measure on the element "Std. Cost" i want to have on the consolidated element the max of the children below.
At the moment i implemented this formula:
but the result is this one:
![Image](http://oi60.tinypic.com/s2fr5h.jpg)
Any advice? I searched a lot on this forum and around and also tried a lot with Rule but everything was unsuccesseful
Thanks in advance,
Leonardo
I have a problem trying to aggregate an element in my Measure dimension using Max criteria.
Here is my cube and what i wanted to do (the image are an Excel representation of what i see in Cube Viewer):
![Image](http://oi61.tinypic.com/mkdg6.jpg)
The concept is that for every node in the dimension measure on the element "Std. Cost" i want to have on the consolidated element the max of the children below.
At the moment i implemented this formula:
Code: Select all
['Std. Cost' ] = C:ConsolidatedMax(0,'',!Warehouse,'Std. Cost');
![Image](http://oi60.tinypic.com/s2fr5h.jpg)
Any advice? I searched a lot on this forum and around and also tried a lot with Rule but everything was unsuccesseful
![Sad :(](./images/smilies/icon_e_sad.gif)
![Sad :(](./images/smilies/icon_e_sad.gif)
![Sad :(](./images/smilies/icon_e_sad.gif)
![Sad :(](./images/smilies/icon_e_sad.gif)
Thanks in advance,
Leonardo