PivotGrid generates wrong MDX query to retrieve dimension calculated members

[Igor]

 

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 0 FROM [SDCOE]) WHERE ([Measures].[Value Cost])</p><p></p>

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

[Georgi Krustev]

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:

• https://github.com/telerik/kendo-ui-core/issues/1703

As a workaround till the issue is resolved, I would suggest you override the generated MDX in order to retrieve the data correctly:

• http://docs.telerik.com/kendo-ui/controls/data-management/pivotgrid/how-to/access-mdx-query

Regards,
Georgi Krustev
Telerik

 

 

[Igor]

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.

[Rosen]

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