TM1 Forum

Hi Duncan!

Thanks so much! Your solution is working perfectly! Did not think about it cause I am still a newbie with TM1.

Anyway, great suggestion that I hope can help also somebody else.

Thanks again,
Leonardo

Hi everybody! I'm on TM1 10.2.2, 64bit architecture and Excel 2007. I have a problem while aggregating some data that have different criteria on different dimensions. I have found something similar in the forum but nothing that can solve my problem. Here is the wrong situation that i have at the mom...

Thanks so much declanr!!!!!

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

Thanks again!

Leonardo

Hi, thanks everybody for answering the question! Anyway, even if I specify the formula like this ['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 dimensio...

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): http://oi61.tinypic.com/mkdg6....