How to only show elements in consolidation and not by themsl

[TomHine]

Good Afternoon,

I've written a TI process to import elemnts into a dimension but only want to show them in the consolidations rather than individually.

How do I do this, I've pasted the code I've used in Metadata below and followed an example on the internet which shows in the format I would like but I can't acheive it.

DIMENSIONELEMENTINSERT('Test', '', TimeData, 'n');
DIMENSIONELEMENTINSERT('Test','',P,'c');
DIMENSIONELEMENTINSERT('Test','',Q,'c');
DIMENSIONELEMENTINSERT('Test','',H,'c');
DIMENSIONELEMENTINSERT('Test','',F,'c');
DIMENSIONELEMENTINSERT('Test','',A,'c');
DIMENSIONELEMENTCOMPONENTADD('Test',Q,P,1.000000);
DIMENSIONELEMENTCOMPONENTADD('Test',H,Q,1.000000);
DIMENSIONELEMENTCOMPONENTADD('Test',F,H,1.000000);
DIMENSIONELEMENTCOMPONENTADD('Test',A,F,1.000000);
DIMENSIONELEMENTCOMPONENTADD('Test',P,TimeData,1.000000);

Your help would be must appreciated.

Regards

Tom

[jim wood]

I'm not sure what you mean? If you mean when you go int o the subset editor they are seperate then you need to sort you dimension by hierarchy.

I hope that helps?

Jim.

[paulsimon]

Hi,

To expand on what Jim said, you can use the DimensionSortOrder Function to specify the sort order.

Personally I prefer to put the sort directly into the }DimensionProperties cube, as I find then that it takes effect whenever the dimension changes, rather than only when the Dimension is empty as tends to be the case with DimensionSortOrder.

eg

CUBE: planning sample:}DimensionProperties


SORTCOMPONENTSSENSE SORTELEMENTSSENSE SORTCOMPONENTSTYPE SORTELEMENTSTYPE
model ASCENDING ASCENDING BYNAME BYHIERARCHY

Regards

Paul Simon

[TomHine]

Just realised I didn't say thank you for the help on this post.

It helped a great deal thank you.