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 ?
How to get the Alias in Asciioutput TI function
-
- 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
Just use the ATTRS Rules function to read the alias from the employee element into a variable, and write the variable value instead.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 ?
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.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.