Hello Erik,
Thank you for your post. I have been looking into it and I can suggest you see the sample in the Samples Browser under xamPivotGrid / Data / Save and Load Data Source Customizations section, which shows how to save/load the user customizations. Please let me know if this helps you or you need further assistance on this matter.
Looking forward for your reply.
Hi Stefan,
Yes, I know that. It works fine to seralize the user customizations. No problem.
My question were more related to the 'raw data' loaded into the grid - if the grid is based on flat-table date (i.e. not OLAP-cube).
So my question is: Is it possible to serialize the grid including also the data?
You might wounder why this would be interesting? It is because that would create the possibility to create 'micro-cubes' based on relational data without having to use SSAS or other XMLA complient OLAP-server. Say that we have 500 000 records with say 10 columns/dimensions and 3 measures in SQL Server (relational data). We can load that into the pivotgrid. Works fine. Then we would like to after this "processing" of the 'micro-cube' (which can take some time) save the pivotgrid including the loaded data down to a binary field in SQL Server. I.e. we would like to first do a binary serialization, and then compress the binary stream, and then save to the database. The next user that wants to browse this data can open the 'micro-cube' (i.e. get the data from the blob-field, deserialize etc), and show the grid to the user. (without the need to fetch the 500 000 records from the relational databas again).
My guess is that this is not possible. But it would be a very cool feature and make it possible to provide smaller customers with 'OLAP-like' functionallity without needing to build SSAS cubes etc.
/Erik
I can say that the FlatDataSource class is not serializable, but the thing you can do is to serialize its ItemsSource. Since you use SQL server I guess you have DataSets, which are serializable. You can combine this with my previous suggestion for saving/loading the view. You can also log new product idea for future versions (or vote for existing ones) at http://ideas.infragistics.com.
There are many benefits to submitting an product idea:
- Direct communication with our product management team regarding your product idea.
- Notifications whenever new information regarding your idea becomes available.
- Ability to vote on your favorite product ideas to let us know which ones are the most important to you. You will have ten votes for this and can change which ideas you are voting for at any time.
- Allow you to shape the future of our products by requesting new controls and products altogether.
- You and other developers can discuss existing product ideas with members of our Product Management team.
Steps to create your idea:
The Product Idea site puts you in the driver’s seat and allows you to track the progress of your ideas at any time, see how many votes it got, read comments from other developers in the community, and see if someone from the product team has additional questions for you.