Thanks Atanas, I'm waiting for your updated sample

Best regards :)

Dear Alex,

The article I mentioned is not yet ready, but the Silverlight sample that shows how to persist the data in the PivotGrid is ready.

I am attaching a solution that demonstrates how to save and load the states:

1. to and from memory with no serialization (updated save/load sample),
2. to and from an XML file with XML serialization
3. to and from memory with Binary Serialization.

In the third case the only thing that you need to do in order to save the states in a database is to upload the byte array called savedBinaryData with the serialized result to the database. One way to do that is to use a WCF service. More on that in the coming article.

I hope that this is helpful. If you have any questions feel free to ask me!

All the best,

Atanas Dyulgerov

P.S.

The solution comes with sample data generator, FlatDataSource that uses the generator and prepares a nice sample initial view, a custom class that represents each saved view (this is majorly different than the same class from the SamplesBrowser). This last class is also the one that we serialize. In the main page we have a number of buttons that trigger the different serializations and deserializations. The GroupBox class and the contents of the Themes folder implement a helper control to make the UI a bit more useful.

The two files that will help you most are MainPage.xaml.cs and SavedPivotGridView.cs

One more thing, the sample will look for the following assemblies:

• InfragisticsSL4.Controls.Grids.XamPivotGrid.v10.2.dll
• InfragisticsSL4.Controls.Menus.XamTree.v10.2.dll
• InfragisticsSL4.DragDrop.v10.2.dll
• InfragisticsSL4.Olap.FlatData.v10.2.dll
• InfragisticsSL4.Olap.v10.2.dll
• InfragisticsSL4.v10.2.dll

The default location for those after you install the Silverlight NetAdvantage trial package is:

C:\Program Files (x86)\Infragistics\NetAdvantage 2010.2\Silverlight DV\Bin

If you have chosen a different location you have to update the references.

Thanks a lot Atanas

Hi Achim,

The problem is solved. The issue was in the save algorithm of the sample. I'm attaching the corrected version of the SavedPivotGridView class. After you extract the file just replace it in the original solution.

All the best,

Nasko

Hello Atanas,

your example code is working now. In my scenario I the member expansion hangs my browser. I am working with an XmlaDataSource together with a SSAS 2008 cube. I pin-pointed the issue to the ManualResetEvent used in the ExpandMembers method.

ManualResetEvent manualResetEvent = new ManualResetEvent(false);
filterViewModel.LoadFilterMembersCompleted += (sender1, e1) => manualResetEvent.Set();
...
manualResetEvent.WaitOne();

When working with the XmlaDataSource the event does not seem to get fired and the browser waits forever. It would be great if you could also test with your AdventureWorks XmlaDataSource used in one of the examples. I could reproduce this behaviour using your AdventureWorks Cube.

With kind regards,

Achim

p.s. thanks for your great support!

Hi, Achim,

The XMLA data source works in a different way.

The browser hangs because waitOne suspends the whole thread and the pivotgrid cant expand its members (which means the event that stops the waiting never fires). If you want to use XMLA data source you need to take the expansion process in a separate thread.

I'm attaching a sample that expands filter members up to a certain level with XMLA data source. You will find all you need there.

If you cant figure out what to change in the serialization sample I'll post the modified version tomorrow.

All the best,

Atanas