- OneStream Community
- Forums
- Reporting
- Rename members in BI Viewer
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-15-2023 03:18 PM
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.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-15-2023 05:19 PM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-15-2023 05:19 PM
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.
