PivotGrid generates wrong MDX query to retrieve dimension calculated members

4 posts, 0 answers
  1. Igor
    Igor avatar
    4 posts
    Member since:
    May 2016

    Posted 22 May Link to this post

     

    Hi

    I use PivotGrid  v2016.1) with MS SSAS (v2014) cube.
    In my cube I created several calculated members, (one named EAC)  on  dimension named Category.
    When I’m using this dimension in PivotGrid as a column PivotGrid doesn’t show any calculated members, but only dimension child members.
    PivotGrid generates this MDX query:

    SELECT NON EMPTY {[Category].[Category].[All],[Category].[Category].[All].Children} DIMENSION PROPERTIESCHILDREN_CARDINALITY, PARENT_UNIQUE_NAME ON COLUMNS FROM [SDCOE] WHERE ([Measures].[Value Cost])<br>

    Filter in PivotConfigurator is able to see all dimension members, children and calculated as wel. But when  I explicitly specify Category members in filter to include in query than PivotGrid returns all members but NOT calculated.

    PivotGrid generates this MDX query:

    <p>SELECT NON EMPTY {[Category].[Category].[All],[Category].[Category].[All].Children} DIMENSION PROPERTIESCHILDREN_CARDINALITY, PARENT_UNIQUE_NAME ON COLUMNS FROM (SELECT ({[Category].[Category].&[1],[Category].[Category].[All].[EAC]}) ON FROM [SDCOE]) WHERE ([Measures].[Value Cost])</p><p></p>

     Does it mean PivotGrid does't support dimension calculated members?

  2. Georgi Krustev
    Admin
    Georgi Krustev avatar
    3706 posts

    Posted 24 May Link to this post

    Hello Igor,

    Thank you for drawing our attention to this limitation.  I logged the case in Github and we will address it in some of our future Kendo UI releases: As a workaround till the issue is resolved, I would suggest you override the generated MDX in order to retrieve the data correctly:
    Regards,
    Georgi Krustev
    Telerik
     
    Join us on our journey to create the world's most complete HTML 5 UI Framework - download Kendo UI now!
     
  3. Kendo UI is VS 2017 Ready
  4. Igor
    Igor avatar
    4 posts
    Member since:
    May 2016

    Posted 24 May in reply to Georgi Krustev Link to this post

    Hi Georgi,

    how can I access generated MDX when I use ASP.NET MVC PivotGrid? What will be the wrapper code to achieve that?

    Cannot find parameterMap method anywhere.

  5. Rosen
    Admin
    Rosen avatar
    3234 posts

    Posted 27 May Link to this post

    Hello Igor,

    When using UI for ASP.NET MVC wrappers it is only possible to override the parameterMap globally. This can be done by placing similar to the following script before any of the PivotGrids' declaration:

    <script>
        var original = kendo.data.transports.xmla.fn.options.parameterMap;
     
        kendo.data.transports.xmla.fn.options.parameterMap = function (options, type) {
            var query = original(options, type);
     
            //modify the query here if needed
            return query;
        }
    </script>


    Regards,
    Rosen
    Telerik
     
    Join us on our journey to create the world's most complete HTML 5 UI Framework - download Kendo UI now!
     
Back to Top
Kendo UI is VS 2017 Ready