Is there a way I could pass the Pivot Grid some MDX that I have generated and then it put the fields in the UI where the different fields are supposed to go ? So the user can start off from a base of a report that already exists from one of my mdx queries ?
For Example:
SELECT NON EMPTY { [Measures].[Delivered Price], [Measures].[Delivered Price Previous Month], [Measures].[Previous Month Quantity]
} ON COLUMNS, NON EMPTY { ( [Distributor].[Dist Short Name].[Dist Short Name].ALLMEMBERS * [Distributor].[Dist ID].[Dist ID].ALLMEMBERS * [Time].[Month Start].[Month Start].ALLMEMBERS * [Time].[Month End].[Month End].ALLMEMBERS * [Time].[Previous Month Start].[Previous Month Start].ALLMEMBERS * [PA Product].[PA Uom].[PA Uom].ALLMEMBERS * [Time].[Previous Month End].[Previous Month End].ALLMEMBERS * [Time].[Current Week End].[Current Week End].ALLMEMBERS * [Distributor].[Dist Name].[Dist Name].ALLMEMBERS * [PA Product].[PA Product ID].[PA Product ID].ALLMEMBERS * [PA Product].[PA Description].[PA Description].ALLMEMBERS * [Concept].[Concept Name].[Concept Name].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM ( SELECT ( [Concept].[Concept ID].&[1761] ) ON COLUMNS FROM ( SELECT ( [Time].[Week Start].&[2018-02-18T00:00:00]
) ON COLUMNS FROM [Reporting]))
and the different fields would be put into Filters, Rows, Columns, and Data ?
Replies
User
Description
Posted On
Vyacheslav SemenkovClient
Hello, Micah.
I'm afraid you can not do this. Also this feature is not part of our nearest roadmap.