Skip to main content
Newcomer
March 31, 2023

Reporting : How to show English Description of member in Cube view instead of Default Description?

  • March 31, 2023
  • 2 replies
  • 0 views

I am trying to create a Cube view report that should show English Description of Entity members istead of default Description. Is there any XF member property function to do the same or any other solution?

 

Thanks,

Neha

2 replies

Veteran
March 31, 2023

Hi NV,
Check that the user you are impersonnating has the required culture under System.
Go to your cube view and check Current under Culture.

NicolasArgente_0-1680261439771.png

 

OneStream Employee
April 3, 2023

With this, you can only change all cubeview descriptions to the selected culture, but if you use:

Ud1#[Ud1Member].base:name(|MfUd1Desc|) or f#[FlowMember].base:name(|MfFlowDesc|)

You can still show the description of the other dimensions.

With:

name(XFMemberProperty(DimType=Account, Member=|MFAccount|, Property=Text1), name(XFMemberProperty(DimType=Account, Member=|MFAccount|, Property=AccountType)

you can access member properties like Text1 or AccountType (including Description).

I wasn't able to access a culture with name(), but there might be a solution for it as well.

Cheers

Christian