Change Theme Settings
Change Theme Settings
Themes
 
Show All Themes
v
...v

OLAP Drill Down

Click on the Cell to Get the Drill Down Result.
Country[Filter]
City[Filter]

This demo shows how to retrieve records that are used to calculate summaries for individual cells when the ASPxPivotGrid is bound to an OLAP server. Click a summary cell to view records from the control's underlying data source associated with this cell. The retrieved data is displayed by the ASPxGridView within a popup window.

To obtain drill-down data, use the pivot grid's CreateDrillDownDataSource method. You need to specify the data field index, row and column indexes to completely identify the required summary cell.

Note: Since drill-down data is provided by the OLAP server, the drill-down datasource can have some extra columns even if you don't have any corresponding fields in the ASPxPivotGrid control. The OLAP server can also return identity values.


See Also: