Hi Martin, thank you very much, this sample is awesome.

can you help me to know how can I save the expanded/collapsed states of the
colums or rows of the data as well as any applied filters at the same time.

I using $("#pivotView").igPivotView({...});

thanks again.

regards.

J.

Hi Maya,

When I load the dataSourse it's works fine, then I save state and apparently it works ok, but when I click load state I receive this error message:

...velSortDirections=a;return a}else{return this._appliedLevelSortDirections}},_app...

Hello Joan,

The dataSourec optioins should be defined as a simple json object, no need to instantiate a OlapXmlaDataSource on the options as they’ll need to be extended with the options stored in localStorage.

Example:

var dsOptions = {

                                                serverUrl: 'http://sampledata.infragistics.com/olap/msmdpump.dll',

                                                catalog: 'Adventure Works DW Standard Edition',

                                                cube: 'Adventure Works',

                                                rows: "[Ship Date].[Calendar]",

                                                columns: "[Delivery Date].[Calendar]",

                                                measures: "[Measures].[Product Gross Profit Margin Status],[Measures].[Product Gross Profit Margin Goal]",

                                };

Also to have the expansion states re-applied you’ll have to wait for the grid to fully render before calling the expandTupleMember API method because if it’s called while the remote data is still loading the grid will not have anything to expand and the change won’t be applied.

You can handle the pivotGridRendered event and reaply the expansion states there after the loadState function was called, for example:

function loadState() {

                                                createGrid(JSON.parse(localStorage.getItem("s1")));                                    

                                                expanded = JSON.parse(localStorage.getItem("expanded"));

                                                isRebind = true;

}

pivotGridRendered: function(evt, ui) {

                if(isRebind){

                                isRebind = false;

                                $(expanded).each(function(){                                                  

                                                $("#pivotGrid").igPivotGrid("expandTupleMember", this.axisName, this.tupleIndex, this.memberIndex, true);

                                });

                }

}

This will ensure the method is called only when needed.

Modified sample is attached for your reference. Let me know if you have any questions.

Best Regards,

Maya Kirova

Infragistics, Inc.

http://ko.infragistics.com/support

Hi Maya, thank you very much!, this is a nice script, I've try integrated the script with $.ig.OlapXmlaDataSource instead of $.ig.OlapFlatDataSource like your sample, but I can't get it, it is posible?, I attach my script, can you help me to check this out? thanks again!

Regards.

Joan.