<
OLAP for WPF and Silverlight | ComponentOne
C1.Olap Namespace / C1OlapEngine Class / Fields Property
Example

In This Topic
    Fields Property (C1OlapEngine)
    In This Topic
    Gets the list of C1OlapField objects exposed by the data source.
    Syntax
    'Declaration
     
    Public ReadOnly Property Fields As C1OlapFieldList
    public C1OlapFieldList Fields {get;}
    Remarks

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

    Olap views are defined by copying fields from this list to the lists that define the view: ValueFields, RowFields, ColumnFields, and 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 RowFields, ColumnFields, and 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();
    See Also