TM1 Forum

Hey all,

I was wondering if someone has worked on a TI code to export multiply mapped elements to a .csv file.

Thanks,

Mems wrote:I was wondering if someone has worked on a TI code to export multiply mapped elements to a .csv file.

Would you care to elaborate on what you mean by "multiply mapped elements"? (With full details of the cube, etc.)

Apologies,

I have a Cost Pool dimension with 8 levels of data. The dimension is reshuffled each year. I want to make sure that one cost pool element is not mapped under two different levels creating a double count.

Each year this takes me days to complete and I was hoping somebody could help me verify which elements are under multiple roll ups.

Thanks

Mems wrote:I have a Cost Pool dimension with 8 levels of data. The dimension is reshuffled each year. I want to make sure that one cost pool element is not mapped under two different levels creating a double count.

I'm making a few assumptions, but if you want to remove the old parent child relationship when an element moves from one branch of a hierachy to another, have a look at the "unwind" TI processes from Bedrock - Bedrock.Dim.Hierarchy.Unwind.All and Bedrock.Dim.Hierarchy.Unwind.Consolidation.

http://bedrocktm1.org/documentation.php

You'll want to run one of these as appropriate before you rebuild your hierarchy.

If you can't unwind the hiearachy and rebuild it from scrath, here's two simple ideas:

Run a TI with the dimension as the data source, look at ElParN for each element on the Data tab. You can combine this with an ElIsAnc if you have multiple valid hierarchies. If ElParN is > 1 then AsciiOutput

or

Have an Excel workbook where cell A1 is =DimNm( "Server:Dimension",Row()), cell B1 is =ElParN( "Server:Dimension", A1) copy both cells down for however many elements you have in your dimension, put autofilter on and look to see if you have any values in column B that are greater than 1.