Menu
Download Free Trial

MDX query behind the pivot table

Answered

Hi, i was wondering if it is possible to get the MDX query behind the pivot table when connected to an OLAP cube ? Surely there must be a query sent somewhere, but i checked the api and could not find anything related to MDX. 
 
Thanks !

3 answers

Public
Roman Petrusha Flexmonster August 10, 2017

Hi Arnaud,

Unfortunately, there is no such API. You can see MDX queries in XMLA requests using browser’s DevTools but I’m not sure it helps in your case.

Regards,
  Roman

Public
arnaud desbiens August 10, 2017

And there is no possible way to access the mdx query behind the pivot table ? I mean, it’s there in the header call. It could be really useful to be able to access it through the api.

Public
Roman Petrusha Flexmonster August 11, 2017

Probably we will add such API call in one of the future builds but no plans for the nearest releases.

Regards,
  Roman

Please login or Register to Submit Answer