deleting repeated elements in different consolidators

Post Reply
knightowl
Posts: 5
Joined: Fri Apr 01, 2011 4:18 pm
OLAP Product: TM1
Version: 9.5.2
Excel Version: 2003

deleting repeated elements in different consolidators

Post by knightowl »

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 !
David Usherwood
Site Admin
Posts: 1458
Joined: Wed May 28, 2008 9:09 am

Re: deleting repeated elements in different consolidators

Post by David Usherwood »

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.
knightowl
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

Post by knightowl »

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
lotsaram
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

Post by lotsaram »

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
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.
Wim Gielis
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

Post by Wim Gielis »

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
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
Post Reply