[TM1 10.2.2] Consolidate with MAX criteria w/ RULE [SOLVED]

[f3ar87]

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):



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'); 

but the result is this one:



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

[Marcus Scherer]

Leonardo, you only specified two dimensions in the rule but your cube contains at least six. You have to specify all of them in the rigth order.

[Wim Gielis]

Leonardo, you only specified two dimensions in the rule but your cube contains at least six. You have to specify all of them in the rigth order.

True, either hardcoded element names, either !dimensionname type of arguments to the function.

[f3ar87]

Hi,
thanks everybody for answering the question!
Anyway, even if I specify the formula like this

Code: Select all

['Std. Cost ] = C:ConsolidatedMax(0,'',!Quality, !Time, !Product, !Part, !Warehouse,'Std. Cost');

the result does not change and I have still the "#N/A" value on the upper level of the dimension.

@Marcus you told about specify dimension "in the right order". What do you mean "in the right order"? I did not find anything about an order in IBM documentation about ConsolidatedMax function.

Thanks again,
Leonardo

[declanr]

Hi,
@Marcus you told about specify dimension "in the right order". What do you mean "in the right order"? I did not find anything about an order in IBM documentation about ConsolidatedMax function.

You need to specify in the same order as shown in architect under the cube (aka the original build order). This isn't specific to ConsolidatedMax but any longhand rules/TI function in TM1.

[f3ar87]

Thanks so much declanr!!!!!

I put the dimension in the right order and now everything is working!! This is just perfect!

Thanks again!

Leonardo