TM1 Forum

Hello,

I have a source cube "ca_tax" and a target cube "ca_bal_sheet_cash_flow".

the source cube has 3 dimensions: Years, Company_BU, Tax_Meas
the target cube has 3 dimensions: Years, Company, Statementline
"Deferred tax Asset" and "Deferred Tax Liability" exist in both Tax_Meas and StatementLine dimensions.

The difference between dimensions "Company_BU" and "Company" is that "Company" has only the consolidated elements from "Company_BU":
i.e. in dimension Company_BU, I have BU
31101
31102
31103
31104
31105 all rolled up into company 31

where in dimension Company, I only have 31 as an element.

I can't use DB directly in rules to pull DTA/DTL as this triggers circular references given how the other balance sheet items are calculated. So I came up with a TI to copy the data over from source to target. However nothing got copied although the subsets and views were created successfully in both cubes. Is it because "31" is a consolidated element in the source view and a level-0 element in the target view? Can someone please show me how to make this work?

thanks so much,

I created a new cube and use rules to pull the numbers then use TI, it works. I think I know the answer. TI can only read/write from/to leaf-level cells?

lynnsong986 wrote: ↑Wed Jan 08, 2020 7:24 pm I created a new cube and use rules to pull the numbers then use TI, it works. I think I know the answer. TI can only read/write from/to leaf-level cells?

Not quite. TI can read from any intersection. Generally you would considder that TI can only write numeric data to leaf intersections but there is an exception if using the CellPutProportionalSpread function.

There are different ways you can achieve what you want to do via TI
1. process zero supressed leaf cells from source to target. This approach will probably be faster even though processing more cells. But you need to remenber to use the CellIncrementN function NOT CellPutN and map from Company_BU to Company, either with a AttrS or SubSt the first 2 characters to get the company from company_BU
2. process zero supressed consolidated cells where the source view only contains company level. For this approach you don't need to transform company_BU to company but you do need to be more carefult with how the view is constructed and make sure not to skip consolidations

################
Admins I think also the OP posted in the wrong forum.

Thank you so much lotsaram for your time explaining this to me! I'll definitely give it a try!