Help with MDX SCOPE and LINKMEMBER functions
Hello All
I am trying to modify how a role-playing dimension reports based on the level of another hierarchy.
Here's an example from AdventureWorks (contrived but it's the closest I can get to my situation):
Say I want values from a measure to be taken from the [Fiscal] hierarchy in the [Date] dimension for the [Employee].[Employee Department].[Department] and [Employee].[Employee Department].[Employee] levels, but I want values from the [Calendar] hierarchy for the (middle) [Employee].[Employee Department].[Title].
I have tried combining SCOPE with Linkmember:
SCOPE ([Employee].[Employee Department].[Title].members);
this = linkmember([Date].[Fiscal].currentmember,[Date].[Calendar]);
end scope;
But that doesn't work (it returns no values), can anybody point me in the right direction?
Thanks
Philippe
What is the Intended Final Product?
Are you attempting to retrieve the data you describe via a report, a browse within Analysis Services, or within a calculated member whose output is then to be presented via some other means?
Could you clarify what the intended final product is supposed to be? I may be able to help you if I can understand the objective.
Thanks.
Bill