TM1 Forum

I am using ASCIIOutput() function to export the cube data to a text file.
But my output has got the Alias names instead of Element names. I want the output with the actual element names - not the aliases. I know if I change my data source (to element names instead of using aliases in the source view) but I dont want to go on that path.

Is there a function by which I can get the element names? Please advice.

ExApplix wrote:I am using ASCIIOutput() function to export the cube data to a text file.

Code: Select all

ASCIIOutput(FileName, Dim1, Dim2, Dim3);

But my output has got the Alias names instead of Element names. I want the output with the actual element names - not the aliases. I know if I change my data source (to element names instead of using aliases in the source view) but I dont want to go on that path.

Is there a function by which I can get the element names? Please advice.

Look for the TI function DimensionElementPrincipalName in the help file / TM1 Reference Manual; that should do what you need.