Hi,
Some times the XamPivotGrid doesn't connect to bring data from the Analysis Server.
Is there a way to assure that the pivot will retry until the connection will be successful ?
Regards,
Dimitris
Hi
You can listen to ResultChanged event of DataSource and check event argument for error. If error occurs you can call RefreshGrid method.
pivotGrid.DataSource.ResultChanged += (s, args) => { if (args.Error != null) { pivotGrid.DataSource.RefreshGrid(); } };
RegardsTodor
When the pivotGrid connects correctly, in DataSource_PropertyChanged event for the e.PropertyName I get the sequence of :
Databases, Database, Cubes, Cube, MeasureGroups, MeasureGroup, Metadata, Processing, Result, Processing
When it doesn't connect the sequence is :
Databases, Database, Cubes, Cube, MeasureGroups, MeasureGroup
and nothing more.
How can I solve this very urgent issue ?
Hello,
Could you check the values of these properties when connection fails:
xmlaDataSource.Cube.Measures
xmlaDataSource.Cube.Dimensions
xmlaDataSource.Cube.MeasureGroups
All these have to be set in order to proceed with creation of the metadata tree. If one of these is not filled the query that is responsible to fill it maybe is not executed yet or there is an exception during the execution. You can listen for these events and check the event arguments Error property:
xmlaDataSource.LoadMeasuresCompleted
xmlaDataSource.LoadDimensionsCompleted
xmlaDataSource.LoadMeasureGroupsCompleted
Checking these will point us where is the problem.
If the reason for this crash is a bug you can give a try to v11.1.
Regards.
PPilev.