Good day!
I'm using PivotGridControl connected to OLAP Cube in XMLA mode.
I need to run MDX query against the cube to get certain slice ("CREATE SUBCUBE [MyCube] AS select …" ) for further work with it.
All the classes and methods which could do that (XmlaMethodRequestUploader.UploadRequest(…) , XmlaConnection.CreateCommand(…), etc) are internal or private. Also I didn't find public methods in PivotGridXmlaDataSource and its parent OLAPDataSourceBase. There are some other tasks to do that needs to extend the built-in functionality of PivotGrid and its DataSource, but such inaccessibility complicates even the creation of own XmlaAdapter.
What do you suggest in this case ?
We have closed this ticket because another page addresses its subject:
Filtering PivotGrid data from an OLAP cubeRun custom MDX query against OLAP Cube in XMLA mode.
Answers approved by DevExpress Support
Hi Vadim,
I would like to recommend that you perform queries manually and load them into the PivotGridControl in the regular mode. Please look at the following sample to see how to do that:
How to perform custom MDX query
How to generate an MDX query automatically according to the current pivot grid layout
I hope to you will find our assistance useful.
Hi Vadim,
We will consider this functionality in the future. However I cannot guarantee that it will be implemented soon, since the current PivotGrid architecture does not support this scenario.
Good day!
The above mentioned "layout pre-filter approach" fell short of expectations. In spite of large tuning and great number of check-ups, it still doesn't do the job completely, especially when a user has the unrestricted access to all the data.
Recently the new update 15.2.5 has come, but nothing new there as for PivotGrid except the fixed bugs.
Are there any news about the subject and such possibility ?
The latest control version does not support this functionality as well. I can only suggest you check the solution with a fixed filter. Please refer to the following tickets where it was already discussed:
Q278651: Fixed filter (How to hide a filter from an end-user)
Q278673: OLAP - How can I prefilter data in the grid?