Rename members in BI Viewer
I am building a donut chart in bi viewer. I am using my Geography UD2 as the arguments. My member names are long: 'United States Region', 'Asia Region', etc. I would like to rename them visually for this report. Is this possible?
I cannot rename them in my dimension library, and renaming them in the cube view with the :name() member expansion does nothing.
Thank you in advance.
1. Right-click Calculated Fields, and then click Add Calculated Field.
2. Enter the following syntax:
Iif([UD2]='United States Region', 'US',
Iif([UD2]='Europe Region', 'EMEA',
Iif([UD2]='Asia Pacific Region', 'APAC',[UD2])))
3. Save the calculated field.
