PivotGrid with flat dynamic objects

[Maxim]

Hello,

 

We have list of flat POJO objects, where objects are dynamic, we don’t know their list of fields/properties at design time. In Silverlight version of telerik Pivot grid we were able to populate list of fields and provide list of objects so that users can create columns, rows and measures at run time.Is this approach feasible with Kendo UI Pivot? Or do we have to define model and cube with dimensions and measures in advance? An example would be very useful.

 

Thank you, Sergey

[Georgi Krustev]

Hello Sergey,

In general, you can build the dimensions collection of the DataSource dynamically using the fields of the POJO instance. Here is a Dojo demo that demonstrates how this could be done:

• http://dojo.telerik.com/@ggkrustev/OvEGa

Please note that this is a custom approach and it is up to the developer responsible for the feature to handle it accordingly.

Regards,
Georgi Krustev
Telerik

 

 

[Maxim]

Hello Georgi,

Thank you, it is what I was looking for. However, setDataSource() only works for me once. I'm not able to update data source and I need to change number of records on demand. For an example, try to add button and call this function in your Dojo:

    var that = this;
    var getProducts = function () {
        $.getJSON("http://demos.telerik.com/kendo-ui/service/Northwind.svc/Products?$format=json", function (data) {
            var source = that.buildDataSource(data.d);
            $("#pivotgrid").kendoPivotGrid().data("kendoPivotGrid").setDataSource(source);
            $("#configurator").kendoPivotConfigurator().data("kendoPivotConfigurator").setDataSource(source);
        });
    }

Thanks again,

Sergey

[Maxim]

Hi Georgi,

This issue is resolved by using static variables for the pivot grid and configurator and initializing them only once in controller's constructor.

Thank you,

Sergey