TM1 Forum

Hi,
I have an requirement like I have an Hierarchy like restructuring,
The consolidate element in one hierarchy will be a child in another hierarchy,
I have tried with that by updating the cube,I got an error like please find the attachment,any suggestions

Thank you

TM1 9.5.2
excel 2007

please find the atachment

Charan,

If you had googled or searched the forum for your particular error message you would have found the below topic:
http://www.tm1forum.com/viewtopic.php?f=3&t=381

Your variables must be mapped as elements etc.

Personally I avoid the "wizard" TIs anyway but that is just personal preference.

Declanr,
Boss the concept here is "Restructuring" like example, I have an hierarchy:
please find the attachment, this is an requirement there will be restructuring that is change in element properties in hierarchy the consolidate element will become leaf element in the second hierarchy, when there upload foe the second time, it keeps on changing with the same elements but only change in hierarchy.
For example,please find the attachment.

ACC ACC
ACC A ACC A
CC1 CC1
CC2 CC2
CC3 CC3


I'm not sure I quite grasp the concept of what you are trying to do.
Are you creating:
A/ a NEW hierarchy in the same dimension
B/ Changing the hierarchy in the dimension
C/ Creating a NEW hierarchy in a different dimension based on the original dimension

If it is the same dimension you cannot have an Element called "ACC A" which exists both as a consolidation and an N-Level element.

What factor determines which consolidations are to become leaf level?



It all depends on what you are actually doing but essentially you are going to need to focus on the functions below:

DimensionElementInsert()
DimensionElementComponentAdd()

With some use of an IF() formula to decide whether the element in question is actually one that needs changing or not.

Declanr thank you,
i have done it,the functions are for uneven hierarchy,but my requirement is
We need to update the dimension from datasource, in the same and cube the source will be having different hierarchy when it is updated in TM1.
We have tried manually by updating in CSV files to the cube, the hierarchy is changing.
I am requesting you if any concerns, or what happens any limitations when we do it in real scenario like from the database itself.