July 15, 2014 at 9:14 am
Apologies, a newbie question here
This, at the basic level, would be a piece of cake in SQL with a 2D, but I'm struggling in
If you have a hierarchy of
1. Team
2. Team Lead
3. Team Member
Where a Team Lead is also a Team Member (Identifiable because the Agent Id is the same as the supervisor Id)
and you wanted to return all measures except when a Team Member is also a Team Lead, is there a way of doing this with MDX
e.g. when the query runs at the moment I get
Team Name Team Lead ID Agent ID Monthly Value
Team 1....................5.................5..................200
Team 1....................5.................12.................15
When I only want
Team Name Team Lead ID Agent ID Monthly Value
Team 1....................5.................12.................15
I suspect this is one of those obvious questions for experienced MDX users and hopefully the obvious answer is not you can't do it 🙂
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply