Skip to main content
D
OneStream Employee
DRiderOneStream Employee
OneStream Employee
December 15, 2023
Solved

Rename members in BI Viewer

  • December 15, 2023
  • 1 reply
  • 0 views

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.

    Best answer by ecubed00

    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.

    1 reply

    E
    OneStream Employee
    ecubed00OneStream EmployeeAnswer
    OneStream Employee
    December 15, 2023

    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.

      Terms & ConditionsAccessibility statement