Hierarchies in Json pivotDataSource

[Àngel]

Hi!

I need to define some Hierarches in a pivot table with json data (not olap/xmla).

I can't find an example of this, the only example of Local Binding (http://demos.telerik.com/kendo-ui/pivotgrid/local-flat-data-binding) is very simple.

In this example, "All Categories" and "All Product" are two different ways to separate the data. What i need is a nested relation Category -> Product, so i can't view mesaures by product if i don't open the category first.

An example of this can be viewed on the "Basic Usage" example (http://demos.telerik.com/kendo-ui/pivotgrid/index). If you drag "Customer" fields into "ROWS" section, you will see nested fields in the pivot table (All Customes -> Australia, Canada, France...). See the image.

Any advice to configure the hierarchies?

Thanks!

[Nikolay Rusev]

Hello Àngel,

 

It seems that you are looking for something like in this article - Add Dimension to Column Axis

 

Regards,
Nikolay Rusev
Telerik

 

 

[Àngel]

Hi Nikolay,

Thanks for you reply, but it's not the same. This article explains how to add dynamically a column, but i need to define hierarchical relations between dimensions in the datasource (or something with the same result)

Watch the example in the image on my first post, you can see some rows in hierarchical mode.

Thanks!

[Georgi Krustev]

Hello Àngel,

Currently, defining custom hierarchies is not supported when client cube is used. I am afraid that there is no feasible workaround for this limitation. You will need to use server solution (OLAP for instance) to build dynamic hierarchies. 

Regards,
Georgi Krustev
Telerik