MDX Help

[seancarbutt-eng]

Hi everyone. Apologies if i do not phrase this correctly.
I need help with some MDX code please. I need to create a new member off of an existing member, but this will be a one to many relationship.

The existing member is a Location code of 3 letters. I need to map one or more of the location codes to a Persons name. So Where Location "EAT" exists, create a new member called KAMS (Key account Manager) and assign Joe to that Location code. There could be 10 Locations codes that belong to Joe. So where the criteria is met, the new member will display Joe next to the Location code(s)

[ChristianMurphy]

Welcome @seancarbutt-eng 👋
It sounds like you're looking for help on multidimensional expressions?
This MDX project is a markdown language, and doesn't have relational expressions.

You'll have much better luck on a forum dedicated to OLAP / Analysis Services. A few good options:

• Microsoft Q&A (if you're on SSAS): https://learn.microsoft.com/en-us/answers/tags/139/sql-server-analysis-services
• Microsoft Fabric Community: https://community.fabric.microsoft.com
• SQLServerCentral forums: https://www.sqlservercentral.com/forums

If you're on SAP BW, Essbase, Cognos or similar, the vendor's own community is usually your best bet.

One tip when you post: mention which platform you're on. What you're describing sounds like a calculated member that maps Location codes to a KAM name, and the exact syntax varies between engines.

[seancarbutt-eng]

Cheers. Thanks for getting back to me. Much appreciated. Sean

…

On Mon, 20 Apr 2026 at 16:23, Christian Murphy ***@***.***> wrote: Welcome @seancarbutt-eng <https://github.com/seancarbutt-eng> 👋 It sounds like you're looking for help on multidimensional expressions? This MDX project is a markdown language, and doesn't have relational expressions. You'll have much better luck on a forum dedicated to OLAP / Analysis Services. A few good options: - Microsoft Q&A (if you're on SSAS): https://learn.microsoft.com/en-us/answers/tags/139/sql-server-analysis-services - Microsoft Fabric Community: https://community.fabric.microsoft.com - SQLServerCentral forums: https://www.sqlservercentral.com/forums If you're on SAP BW, Essbase, Cognos or similar, the vendor's own community is usually your best bet. One tip when you post: mention which platform you're on. What you're describing sounds like a calculated member that maps Location codes to a KAM name, and the exact syntax varies between engines. — Reply to this email directly, view it on GitHub <#2678?email_source=notifications&email_token=CCG5BPE2564RPJUBZDC6JG34WYXG3A5CNFSNUABIM5UWIORPF5TWS5BNNB2WEL2ENFZWG5LTONUW63SDN5WW2ZLOOQXTCNRWGM3DQNZYUZZGKYLTN5XKO3LFNZ2GS33OUVSXMZLOOSWGM33PORSXEX3DNRUWG2Y#discussioncomment-16636878>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/CCG5BPGQPGXMYXD7K7ECPDL4WYXG3AVCNFSM6AAAAACX7OZNUSVHI2DSMVQWIX3LMV43URDJONRXK43TNFXW4Q3PNVWWK3TUHMYTMNRTGY4DOOA> . You are receiving this because you were mentioned.Message ID: ***@***.***>