TM1 Forum

Hi ,

I have one question

I want to delete the elements from the dimension starting with Alphabetic.

For Example : I have Dimension in that i have 10 elements .

In that i have 3 elements starting with "A" and 3 elements starting with "B" and 4 elements starting with "S".

I want to delete the elements which are starting with "S".

can any one expline how can i achive this?

Regards
Ashok

There are at least 3 tools with which you can do it: Dimension Editor, Turbo Integrator, Dimension Sheet (XDI). You need to let us know how you normally manage your dimensions.

The quickest way would be to use the Dimension Editor. Right click on the dimension, Edit DImension Structure, then Filter by Wildcard (S*) then mark all the elements that are left, right click, Delete Element and save changes.

You could also write a TI process that would have a Subset as its data source, for example. This subset could be a dynamic or a static one, containing all the elements you want to delete. On the Metadata tab you would have to put DimensionElementDelete().