Hi,
Is there any way to make the Pivot Grid editable. That is allow user to change the cell values by typing into it. And also how can these be committed to the underlying FlatDataSource.
Thanks
Sangeetha
It is working great now. Thanks a lot.
Thank You Mircho.
Now all editable measures are in the list. But there still is this problem when. when I right click and invoke ''Allow Edit cell" which sets the equivalent property of the PivotGrid, the existing Measure is not editable although it is in EditableMeasures. However when I select/Drag/Drop a Measure form the selectro to the grid, it becomes editable.
You can get measures from datasource like this:
IMeasure measure = dataSource.Cube.Measures[index] and from this measure you can create IMeasureViewModel mvm = dataSource.CreateMeasureViewModel(measure)
dataSource - your data source object
Thanks for your reply Mircho.
So how can I get this Initial list of Measures?
When you call GeneratInitialItems method string parameters are only filled in a string collection, according to which initial data will be loaded once you have the metadata loaded. But in the moment this method is called there is no metadata loaded. That's why GeneralInitialItems method do not return List<IMeasure> or List<IMeasureViewModel>.