Suspend automatic updates to the output table while defining the Olap view.
The code below shows how to define a new Olap view efficiently by enclosing the changes between calls to
BeginUpdate and
EndUpdate.
// set data source (populates Fields list)
olap.DataSource = GetDataTable();
// prevent updates while building Olap view
olap.BeginUpdate();
// show countries in rows
olap.RowFields.Add("Country");
// show categories and products in columns
olap.ColumnFields.Add("Category");
olap.ColumnFields.Add("Product");
// show total sales in cells
olap.ValueFields.Add("Sales");
// done defining the view
olap.EndUpdate();
Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2