How to show both "ID and Name" in the NemeColumn of a dimension?

Hi All,

When creating a new dimension we are restricted in selecting one coulmn from the table to be shown as the "NameColumn" of the dimension; i need to display both ID and Name from the table as the "NameColumn", how could i do this?

Since in AS 2000 this can be done easily

Thanks,

Ghadeer Omari

Since you want to show ID and name, you have to somehow concatinate them. And there could be multiple ways to do that - with space, with dash, etc. I usually in such cases go to data source views and create named calculations :

FullName: ID + '-' + Name

Then I use new named calculation in name column.

Vidas Matelis

|||

Dear Matelis,

Thanks very much this works.