Import MDX into Pivot Table

StatusIDPriorityType
Closed32948MajorQuestion
Profile Reply
Micah.Armantrout Client

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 Semenkov Agent

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