Forum Discussion

DDrider's avatar
DDrider
New Contributor III
2 years ago

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 ...
BI Viewer
Reports
  • ecubed00's avatar
    ecubed00
    2 years ago

    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.

ecubed00's avatar
ecubed00
New Contributor
2 years ago

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.