TM1 Forum

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 ?

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);