Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
425
Cube Writeback
posted

Hello everybody,

 

I am looking for a quick how-to which provides insight on enabling the grid for Cube Writeback. My cube is definitly writeback-enabled and I set all reasonable properties on the grid.

 

  <igPivot:XamPivotGrid x:Name="pivotGrid" Loaded="pivotGrid_Loaded"
                              DataSource="{StaticResource adomdDataSource}"
                              AllowHeaderRowsSorting="True" AllowHeaderColumnsSorting="True" AllowDrop="True" AllowHiddingColumns="True" AllowHiddingRows="True" IsManipulationEnabled="True">
            <igPivot:XamPivotGrid.EditSettings>
                <igPivot:EditSettings AllowCellEdit="True" EditFormatedValue="True" >
                   
                </igPivot:EditSettings>
            </igPivot:XamPivotGrid.EditSettings>
        </igPivot:XamPivotGrid>
        <igPivot:Expander Grid.Column="1">
            <igPivot:XamPivotDataSelector x:Name="dataSelector"
                                          DataSource="{StaticResource adomdDataSource}" />
        </igPivot:Expander>

 

Setting the EditableMeasure collection happens in the Loaded event of the grid.

    private void pivotGrid_Loaded(object sender, RoutedEventArgs e)
        {
            foreach (Infragistics.Olap.Data.IMeasure item in pivotGrid.DataSource.Cube.Measures.ToList())
            {
                this.pivotGrid.EditSettings.EditableMeasures.Add(item);

            }
        }

 

Is there anything else I need to do/know in order to enable cube writeback in the pivotgrid?

 

Looking forward to your suggestions.

 

Thanks,