Forum Discussion
CUBE formula to show member name based on member code
Hello everyone,
I would like to ask for some help with CUBE formulas.
I am dealing with a CUBE where I have multiple members with multiple properties.
Below there is a Pivot built on the CUBE and I have the account code (Natural Code) and to each account is assigned a name (Natural name), multiple Groups and Groups Names....
Would you be able to help me with a CUBE formula to show the Natural name based on the Natural code?
For example, for the first line, I would like to have a formula that would show me Group 3 "Volume Discount" based on the Natural code 94997.
I have been looking around for this and tried CUBEMEMBER formulas, but I don't seem to manage to make it work!
Thanks a lot for the help!
1 Reply
- LorenzoSilver Contributor
https://support.microsoft.com/en-us/office/cubememberproperty-function-001e57d6-b35a-49e5-abcd-05ff599e8951 if you deal with an OLAP cube
https://answers.microsoft.com/en-us/msoffice/forum/all/cubememberproperty-excel-data-model/2a6c85ec-641f-47f8-9965-c109edfa9828 if you deal with an Excel Data Model