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