Skip to content

This example demonstrates how to specify connection settings and create fields that are bound to measures and dimensions of the cube on the OLAP server (Microsoft Analysis Services) to display data in the Pivot Grid.

License

DevExpress-Examples/winforms-pivot-grid-connect-to-an-olap-datasource

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

59 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Pivot Grid for WinForms - How to Connect the Pivot Grid to an OLAP Data Source at Runtime

This example demonstrates how to add connection settings to the Adventure Works cube on the OLAP server.

screenshot

To bind the Pivot Grid control to an OLAP cube, follow the steps below.

  1. Set the PivotGridControl.OLAPDataProvider property to ADOMD.
  2. Specify connection settings in the PivotGridControl.OLAPConnectionString property. The following connection string is used in this example:
    OlapConnectionString="Provider=MSOLAP;Data Source=http://demos.devexpress.com/Services/OLAP/msmdpump.dll; +
                         "Initial catalog=Adventure Works DW Standard Edition;Cube name=Adventure Works;Query Timeout=100;"
    
    Note that a valid connection string should include the following parameters: Provider, Data Source, Initial Catalog, and Cube Name.

You can create Pivot Grid fields and bind them to measures and dimensions in the OLAP cube in the following ways:

Specify the value of the PivotGridFieldBase.Name property for each field when you create Pivot Grid fields. You can use this value to determine fields in a stored layout.

Use the following properties to specify field location and visibility:

Use the invoked Customization Form to arrange fields.

Files to Review

Documentation

More Examples

About

This example demonstrates how to specify connection settings and create fields that are bound to measures and dimensions of the cube on the OLAP server (Microsoft Analysis Services) to display data in the Pivot Grid.

Topics

Resources

License

Stars

Watchers

Forks