ASCIIOutput without Aliases

Post Reply
ExApplix
Posts: 103
Joined: Mon Sep 21, 2009 7:09 pm
OLAP Product: Cognos Tm1
Version: 10.2.2
Excel Version: 2016

ASCIIOutput without Aliases

Post by ExApplix »

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.
Alan Kirk
Site Admin
Posts: 6667
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: PA2.0.9.18 Classic NO PAW!
Excel Version: 2013 and Office 365
Location: Sydney, Australia
Contact:

Re: ASCIIOutput without Aliases

Post by Alan Kirk »

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.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
Post Reply