How to get the Alias in Asciioutput TI function

Post Reply
telula
Posts: 99
Joined: Tue Nov 18, 2008 5:40 am

How to get the Alias in Asciioutput TI function

Post by telula »

Hello,
I am trying to export some details from a cube using the ASCIIOUTPUT function in TI. One problem is that for the Employee element, the ID is what is exported. I need to export the first and last name of the employee which is the alias of the staff element ( i.e, the first and last name shows when the Alias is turned on). How do I export the alias of the element ?
Alan Kirk
Site Admin
Posts: 6643
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: How to get the Alias in Asciioutput TI function

Post by Alan Kirk »

telula wrote:Hello,
I am trying to export some details from a cube using the ASCIIOUTPUT function in TI. One problem is that for the Employee element, the ID is what is exported. I need to export the first and last name of the employee which is the alias of the staff element ( i.e, the first and last name shows when the Alias is turned on). How do I export the alias of the element ?
Just use the ATTRS Rules function to read the alias from the employee element into a variable, and write the variable value instead.
s_EmployeeName = ATTRS(dimension, element, attribute);
ASCIIOutput(FileName, s_EmployeeName);
"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