olap - Displaying multiple hierchy levels in an MDX query -
I am trying to get the following data from a TFS OLAP cube in a single query
< Code> [Job Item]. [System_id] | [Item of work] [System credit] | [Solution]. [BaselineWork] 13426 | Do some work. 5Is not it easy to think? Whatever I thought of this, but it has become very difficult with the knowledge of OLAP, TFS and MDX.
![]()
So, I can get this ...
select [remedy]. [Microsoft_VSTS_Scheduling_BaselineWork] on columns, [work items]. [System_id] on the lines .MEMBERS [Team System] where [Work Item] [System_WorkItemType] & amp; .. [WPS Task]
and this ...
select [remedy] [Microsoft_VSTS_Scheduling_BaselineWork] on columns, [work items] [System_Title] [Team System ] Where [work items]. [ME] MBM; on rows with [System_WorkItemType]. [WPS Task]
But the combination of both I got stumped. After a suggestion
I think this is what you are after:
Select[remedy]. [Microsoft_VSTS_Scheduling_BaselineWork] on columns, [work items]. [System_Title] .MEMBERS * [Work Item]. [System_id] on rows from .MEMBERS [team system] where [work items]. [System_WorkItemType]. & Amp; [WPS Task]
There is a Cross Join between Mutation, SystemTitD, and System_ID sets. More information is
Comments
Post a Comment