Fields in OLAP Mode

• Sep 06, 2024

In OLAP mode, a pivot grid field represents one of the following cube elements: a measure, dimension, or named set. As with fields in standard data loading modes, fields in OLAP mode are visually represented by field headers, which can be moved between the control’s areas using drag-and-drop operations.

You can bind pivot grid fields to specific cube elements using the following techniques:

• Manually create fields and then bind them to cube elements via a field’s UniqueName property.

• Use the TcxPivotGridOLAPDataSource component to retrieve all cube elements as fields using the RetrieveFields method.

The limitations of fields bound to OLAP cube elements are listed in the OLAP Requirements and Limitations topic.

End-users can customize a field layout via the Customization Form.