COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: Archana_M on 21 Aug 2013 03:45:22 AM

Title: Give alias name to displayed name.
Post by: Archana_M on 21 Aug 2013 03:45:22 AM
Hi All,
I need to display the data with the alias name in pie diagram.
Eg:If the displayed Employee Name is Jack Canfield then I should be able to alias as "JC"

Kindly guide,is there any option to make such changes.

Regards
Archana
Title: Re: Give alias name to displayed name.
Post by: Satheesh on 21 Aug 2013 07:18:22 AM
hi,


If you have data item with alias names drag and drop insted of Emplyee name data item place.

Title: Re: Give alias name to displayed name.
Post by: RKMI on 21 Aug 2013 05:38:32 PM
Or if you have First Name and Last Name in the FM. You can create a alias data item - substring ([First Name],0,1)+''+substring ([Last Name],0,1).