Import MDX into Pivot Table

StatusIDPriorityType
Closed32948MajorQuestion
ProfileReply
Micah.ArmantroutClient

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

UserDescriptionPosted On
Vyacheslav SemenkovClient

Hello, Micah.

I'm afraid you can not do this. Also this feature is not part of our nearest roadmap.

Best regards,
Vyacheslav Semenkov

× This ticket is closed.

Write US