Hi,
In Samples for Silverlight DV, for XamPivotGrid, there is a nice sample showing how to save and load views.
How do I save the settings class (SavedPivotGridView) to the database ?
I tried to serialize it as Xml, but it does't work (classes inside are not serializable). I also tried using PersistenceManager, but it didn't store the collections' content (Rows, Columns, Filters, Measures).
Thanks,
Alex
Hi Atanas,
I am trying to save the sorting too in external of xml file. I try this at my end and got sucess to save the sorting. But I was unable to apply saved sorting information. I already put post on same forum with below link.
https://es.infragistics.com/community/forums/f/retired-products-and-controls/52969/sorting-don-t-apply-at-runtime
I just thought that everyone should be aware that the newest sample code on the website for the save/load includes a limitation that the PivotGrid cannot be serialized because it uses interfaces (like IHierarchy and IMeasure).
Actually, I have figure it out. In the Fill method:
// Preseving the order for Measures
foreach(string ms in this.Measures)
{
var f = pivotGrid.DataSource.Cube.Measures.Where(p => p.Name == ms.ToString());
if(f.Count() > 0)
IMeasure meas = f.First();
IMeasureViewModel mvm = pivotGrid.DataSource.CreateMeasureViewModel(meas);
pivotGrid.DataSource.Measures.Add(mvm);
}
//rows
foreach (string st in this.RowHierarchies)
foreach (IDimension dim in pivotGrid.DataSource.Cube.Dimensions)
var rows = dim.Hierarchies.Where(r => r.UniqueName == st);
if (rows.Count() > 0)
IFilterViewModel fvm = pivotGrid.DataSource.CreateFilterViewModel(rows.First());
pivotGrid.DataSource.Rows.Add(fvm);
//columns order
foreach (string st in this.ColumnHierarchies)
var colmns = dim.Hierarchies.Where(r => r.UniqueName == st);
if (colmns.Count() > 0)
IFilterViewModel fvm = pivotGrid.DataSource.CreateFilterViewModel(colmns.First());
pivotGrid.DataSource.Columns.Add(fvm);
Regards.
I am working with PivotGrid and in my application I save / load grid layout in / from xml file in the local folder. All looks good and I am using your example to save and load. There is one issue though. If columns, rows or measures on the grid on save in the specific order, this order is not perseved on load. As an example. If columns order on save is Distance, Km Per Liter, Usage, CO2, CO2e. After load from the file the order is CO2, CO2e, Km Per Liter, Distance, Usage. The same issue for rows and measures. Is ther any way to keep the order on load? Or any grid settings can help with this?
Thank you.
Irina
Hello Atanas
I added the BackgroundWorker thread to your example class SavedPivotGridView (less work for others regarding integration) since it will not influence using a flat file source in a negative way and in addition it allows using the XMLA source.
Looking forward to your Article.
With kind regards,
Achim