Rename Membername in a "server time dimension" - Calendar 2007 -> 2007

Hi.

Possibly a simple question...

I generated a server time dimension and want overwrite the shown text. Instead of e.g. Calendar 2007 I want only show 2007. But I do not find a way to overwrite the member labels.

THX for any help,

Nils

Hi,

Create a named calculation with the name "CALYEAR" and in Expression

Substring(fieldname,10,4)

Note: fieldname is your column name

It will create a new named calculation with the name "CALYEAR"

Open the Server time Dimension and click on the field Calenderyear and select the Properties.

In properties Select NameColumn and Select the Source and change the ColumnID -> CALYEAR.

Deploy it and check it out

This will help you

Dinesh