Order of elements retrieved via ELCOMP furmula

[tosca1978]

Hi,

I am working in 9.5.2 and excel 2007.

Apologies if there is a simple solution to my problem that I have missed. I have tried looking for an answer in the TM1 help guides with no joy.

I have an elcomp formula in a worksheet that brings back all of the elements that are a component of the selected parent. The dimension that it is referencing has had elements added to it via a TI over time (whenever an element fails the DIMIX test it is added). The developer that built the TI had an Element Order of "By Input" selected in the Maps/Dimensions tab. Here is an example of what my ELCOMP formula displays:


Index No Elcomp result
28 0000212B
29 0000212C
30 0000212E
31 00002190
32 00002191
33 00002192
34 00002193
35 00002194
94 0000212A
95 0000212F
96 0000212G
97 0000212H

As you can see the order of the elements are not sorted A>Z, but this is what I want to achieve.

I have opened up the }DimensionProperties cube and typed "BYNAME" in SORTELEMENTSTYPE and SORTCOMPONENTSTYPE and "ASCENDING" in SORTELEMENTSSENSE and SORTCOMPONENTSSENSE and saved.

I was hoping that this would result in the order of the ELCOMP results being sorted A>Z, however nothing has changed. Does the ELCOMP formula reference the DIMIX number of the element when retrieving the value?

If anyone can tell me how to achieve the elements sorted A>Z I would be very grateful.

Cheers

[lotsaram]

The next time the dimension is compiled the change in order should take effect. (that is, add or remove an element).