Pivot Grid Data Source Engine Component

The Pivot Grid Data Source Engine component is responsible for runtime data source manipulation to retrieve the data required for a grid and chart. Any events in the grid and chart will result in a data source modification and it being rerun, which are handled by the data source engine. The Pivot Grid Data Source Engine component enables you to:

• Set Pivot Grid metadata.

  Pivot Grid metadata includes axis members, Value members, total attribute, total name, column label, tree name, tree node, aggregate functions for Value members, and Pivot Grid viewing options.

• Retrieve Pivot Grid metadata from the database.

• Return a result set for a chart, a result set for a grid, unique values for axis members, unique values for filters, and drill-down values for detailed view.