kiamkhai wrote:Dear TM1 Developers
I am using TM1 version 9.1 SP3. I notice from the developer guide section 2.27, we can either add siblings or children to existing elements. Unfortunately I am unable to add siblings to existing elements but able to add child to existing elements. For the drop down menu after clicking the Edit menu from the Dimension editor, unable to find ' Insert Siblings". Hope to get assistance from those who have use this function before.
2. What is the different between add sibling and add child to exiting elements?
The documentation doesn't explain what a sibling is. Sigh, what a frappin' surprise.
OK, it's like this:
- If you have NOTHING selected in the dimension editor, the menu item will read "Insert Element". That will allow you to put in a new element which can be either an N level, S level or a C level, though in the case of a new C element it'll have no children at the time that you create it.
- If you have a CONSOLIDATION selected, the option will be "Insert Element". This option functions in the same way as the one above.
- ALSO, if you have a consolidation selected, you can choose to insert a child; that is, a new element which will roll up into that consolidation.
- If you have an N LEVEL element selected, AND that N level element is part of a consolidation, THEN you can insert a sibling. A sibling is another term describing a brother or sister. In this case, it will be a new element which has the same parent.
Suppose that you have a department dimension with Dept 101 and Dept 102 which roll up to the consolidated element Total Departments.
Suppose also that you want to add a new Dept 103, and you want it to add into Total Departments as well.
You can do it in one of two ways:
- Select Total Departments and select Add Child to add dept 103 underneath it; OR
- Select either Dept 101 or Dept 102, and select Add Sibling to add dept 103 to the same parent consolidation. In other words, dept 103 is like a brother or sister to 101 and 102; it shares the same parent (Total Departments) and is at the same level as them.
Remember; you can only add a sibling if you have a child of a consolidation element selected. At any other time, the Insert Sibling option won't be available.
