TM1 Forum

Does anyone have suggestions on how this might be done?
Scenario: Two data fields - Corporate Value and Local Value, Dimension - Location Hierarchy
North America
Canada
US
Mexico

Each country has values in Local Currency that are converted to Corporate Currency in a rule using a converison cube. Users need to see both values. However, we only want the Corporate Value consolidated at the NA level. How should this be done? I've looked in the various forums and help files and haven't found anything that I think applies, but maybe I'm missing the obvious. I'd like to do it as a rule, but maybe that isn't the 'right' way.

TM1 9.5.2; Excel 2007, Windows 2008

Thanks so much!

Pretty easy:

['Local Value']=C:0;

This will stop the local currency value from consolidating, which is what you really want in a currency conversion scheme. No need for it to consolidate at any level under "NA", which I assume to be "North America", because the user can just look at USD to see the consolidated amounts for North America.

FYI, you will need to have the following in your tm1s.cfg file in order for this to work:
AllowSeparateNandCRules=T

Thanks Tomok - that was it! As I suspected, I was missing the obvious.