Hierarchies in Json pivotDataSource

4 posts, 0 answers
  1. Àngel
    Àngel avatar
    2 posts
    Member since:
    Dec 2015

    Posted 18 Dec 2015 Link to this post

    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!

  2. Nikolay Rusev
    Admin
    Nikolay Rusev avatar
    2284 posts

    Posted 23 Dec 2015 Link to this post

    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!
     
  3. Kendo UI is VS 2017 Ready
  4. Àngel
    Àngel avatar
    2 posts
    Member since:
    Dec 2015

    Posted 28 Dec 2015 in reply to Nikolay Rusev Link to this post

    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!

  5. Georgi Krustev
    Admin
    Georgi Krustev avatar
    3706 posts

    Posted 04 Jan Link to this post

    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!
     
Back to Top
Kendo UI is VS 2017 Ready