Fields Property (C1OlapEngine)

Gets the list of C1OlapField objects exposed by the data source.

Syntax

Visual Basic
C#

'Declaration
 
Public ReadOnly Property Fields As C1OlapFieldList

public C1OlapFieldList Fields {get;}

Remarks

This list is created automatically whenever the C1OlapEngine.DataSource property is set.

Olap views are defined by copying fields from this list to the lists that define the view: C1OlapEngine.ValueFields, C1OlapEngine.RowFields, C1OlapEngine.ColumnFields, and C1OlapEngine.FilterFields.

Example

The code below assigns a data source to the Olap engine and then defines a view by adding fields to each of the C1OlapEngine.RowFields, C1OlapEngine.ColumnFields, and C1OlapEngine.ValueFields lists.

// 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();

Requirements

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

Reference

C1OlapEngine Class
C1OlapEngine Members