Skip to main content
Expert
Oct 13, 2022 10:07 AM UTC
Solved

Concatenate strings in the "Name" function

Hi,

I'm trying to build a cube view having a list of Entities on the rows. I'd like the row label to be the entity description followed by the entity currency.

I was trying to use the Name function to do that. I am able to display the entity currency like this for example:

E#Tot_Entity.TreeDescendantsInclusive:Name(XFMemberProperty(DimType=Entity, Member=|MFEntity|, Property=Currency))

Similarly I can use the XFmemberproperty function to retrieve the member description, like this:

E#Tot_Entity.TreeDescendantsInclusive:Name(XFMemberProperty(DimType=Entity, Member=|MFEntity|, Property=Description))

 

However, I have been unable to combine the 2 things. How do I concatenate strings within the Name function?

Thank you

aricgresko
Veteran
Oct 13, 2022 11:43 AM UTC

Try this


E#Tot_Entity.TreeDescendantsInclusive:Name(|MFEntityDesc| XFMemberProperty(DimType=Entity, Member=|MFEntity|, Property=Currency, VaryByScenarioType=[], VaryByTime=[]))

2 replies

aricgresko
Veteran
Oct 13, 2022 11:43 AM UTC

Try this


E#Tot_Entity.TreeDescendantsInclusive:Name(|MFEntityDesc| XFMemberProperty(DimType=Entity, Member=|MFEntity|, Property=Currency, VaryByScenarioType=[], VaryByTime=[]))

AndreaFAuthor
Expert
Oct 13, 2022 12:46 PM UTC

That works brilliantly, thank you very much!