Ticket T245813
Visible to All Users
Duplicate

We have closed this ticket because another page addresses its subject:

Filtering PivotGrid data from an OLAP cube

Run custom MDX query against OLAP Cube in XMLA mode.

created 10 years ago

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 ?

Answers approved by DevExpress Support

created 10 years ago

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.

    Show previous comments (3)
    DevExpress Support Team 10 years ago

      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.

      VK VK
      Vadim Khalimovskiy 9 years ago

        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 ?

        DevExpress Support Team 9 years ago

          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?

          Disclaimer: The information provided on DevExpress.com and affiliated web properties (including the DevExpress Support Center) is provided "as is" without warranty of any kind. Developer Express Inc disclaims all warranties, either express or implied, including the warranties of merchantability and fitness for a particular purpose. Please refer to the DevExpress.com Website Terms of Use for more information in this regard.

          Confidential Information: Developer Express Inc does not wish to receive, will not act to procure, nor will it solicit, confidential or proprietary materials and information from you through the DevExpress Support Center or its web properties. Any and all materials or information divulged during chats, email communications, online discussions, Support Center tickets, or made available to Developer Express Inc in any manner will be deemed NOT to be confidential by Developer Express Inc. Please refer to the DevExpress.com Website Terms of Use for more information in this regard.