Hi All,
I have the following in a dimension
Consolidator A
Child 1
Child 2
Child n
In my TI process, I do a dimensionelementcomponenetAdd( Dimname, ParentConsolidatorA, ConsolidatorA, 1)
I do this multiple times and I roll up these consolidators under one big consolidator
I need to remove elements from the new consolidator ( ParentConsolidatorA) for example I want to remove child 2 but since Child 2 exits in two roll ups
i.e. consolidatorA and ParentConslidatorA, the DimensionelementComponentDelete( DimName, ConsolidatorA, Child 2) will fail similarly if I replace consolidator A with ParentconsolidatorA, it will also fail
I want to delete specific members from this new ParentConsolidatorA but not from the original ConsolidatorA. Any help would be appreciated !
deleting repeated elements in different consolidators
-
- Site Admin
- Posts: 1458
- Joined: Wed May 28, 2008 9:09 am
Re: deleting repeated elements in different consolidators
Er....
How about
DimensionelementComponentDelete( DimName, ParentConsolidatorA, Child 2)
?
Deleting elements from a consolidation doesn't delete the element itself. If it fails, I suspect you haven't added it in successfully. Possibly two passes through the source are needed. Put some elispar checks in.
How about
DimensionelementComponentDelete( DimName, ParentConsolidatorA, Child 2)
?
Deleting elements from a consolidation doesn't delete the element itself. If it fails, I suspect you haven't added it in successfully. Possibly two passes through the source are needed. Put some elispar checks in.
-
- Posts: 5
- Joined: Fri Apr 01, 2011 4:18 pm
- OLAP Product: TM1
- Version: 9.5.2
- Excel Version: 2003
Re: deleting repeated elements in different consolidators
Doing that does not work.. I think it is because it exists in different consolidators... the error says something along the lines of could not delete child 2
-
- MVP
- Posts: 3703
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: deleting repeated elements in different consolidators
DimensionElementComponentDelete applies to specific children in specific consolidations. If you are getting an error message then I echo the previous guidance, you are trying to delete an element from a parent of which it is not a direct child.knightowl wrote:Doing that does not work.. I think it is because it exists in different consolidators... the error says something along the lines of could not delete child 2
-
- MVP
- Posts: 3231
- Joined: Mon Dec 29, 2008 6:26 pm
- OLAP Product: TM1, Jedox
- Version: PAL 2.1.5
- Excel Version: Microsoft 365
- Location: Brussels, Belgium
- Contact:
A
Instead of your DimensionElementComponentDelete, use an AsciiOutput to output both child and parent to a text file. Then look at the result in the text file and try to see why it generates errors.
As said earlier, use the ELISPAR and ELISCOMP functions for checks.
Wim
As said earlier, use the ELISPAR and ELISCOMP functions for checks.
Wim
Best regards,
Wim Gielis
IBM Champion 2024-2025
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Wim Gielis
IBM Champion 2024-2025
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly