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.
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.
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.
Probably we will add such API call in one of the future builds but no plans for the nearest releases.