This is a migrated thread and some comments may be shown as answers.

Hierarchies in Json pivotDataSource

3 Answers 235 Views
PivotGrid
This is a migrated thread and some comments may be shown as answers.
Àngel
Top achievements
Rank 1
Àngel asked on 18 Dec 2015, 04:06 PM

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!

3 Answers, 1 is accepted

Sort by
0
Nikolay Rusev
Telerik team
answered on 23 Dec 2015, 08:58 AM

Hello Àngel,

 

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

 

Regards,
Nikolay Rusev
Telerik
 
Join us on our journey to create the world's most complete HTML 5 UI Framework - download Kendo UI now!
 
0
Àngel
Top achievements
Rank 1
answered on 28 Dec 2015, 10:38 AM

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!

0
Georgi Krustev
Telerik team
answered on 04 Jan 2016, 07:40 AM
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
 
Join us on our journey to create the world's most complete HTML 5 UI Framework - download Kendo UI now!
 
Tags
PivotGrid
Asked by
Àngel
Top achievements
Rank 1
Answers by
Nikolay Rusev
Telerik team
Àngel
Top achievements
Rank 1
Georgi Krustev
Telerik team
Share this question
or