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
change in hierarchies
-
charan
- Posts: 148
- Joined: Tue Nov 23, 2010 9:04 am
- OLAP Product: cognos tm1
- Version: 9.5
- Excel Version: 2007
Re: change in hierarchies
please find the atachment
- Attachments
-
- hier_error.JPG (107.87 KiB) Viewed 4084 times
-
declanr
- MVP
- Posts: 1831
- Joined: Mon Dec 05, 2011 11:51 am
- OLAP Product: Cognos TM1
- Version: PA2.0 and most of the old ones
- Excel Version: All of em
- Location: Manchester, United Kingdom
- Contact:
Re: change in hierarchies
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.
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.
Declan Rodger
-
charan
- Posts: 148
- Joined: Tue Nov 23, 2010 9:04 am
- OLAP Product: cognos tm1
- Version: 9.5
- Excel Version: 2007
Re: change in hierarchies
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.
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.
- Attachments
-
- Hier_xls.xlsx
- (8.92 KiB) Downloaded 332 times
-
declanr
- MVP
- Posts: 1831
- Joined: Mon Dec 05, 2011 11:51 am
- OLAP Product: Cognos TM1
- Version: PA2.0 and most of the old ones
- Excel Version: All of em
- Location: Manchester, United Kingdom
- Contact:
Re: change in hierarchies
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.
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.
Declan Rodger
-
charan
- Posts: 148
- Joined: Tue Nov 23, 2010 9:04 am
- OLAP Product: cognos tm1
- Version: 9.5
- Excel Version: 2007
Re: change in hierarchies
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.
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.