Skip to main content
BuyLog In
Silverlight Controls
Search in…
Docs > Silverlight Controls > Controls > Pivot Grid > Examples > Binding to Data > How to: Bind a Pivot Grid to an OLAP Cube
All docs
V14.2
Silverlight Controls
What Is New
Installation and Demos
Common Concepts
Controls
Reporting
Data Grid
Ribbon Controls
Toolbar-Menu
Chart Control
Pivot Grid
Product Information
Getting Started
Fundamentals
Concepts
Visual Elements
End-User Capabilities
Examples
Binding to Data
How to: Bind a Pivot Grid to an OLAP Cube
How to: Bind a Pivot Grid to an Embedded XML File
How to: Bind a Pivot Grid to an Embedded XML File in Code
How to: Display Unbound Data in a PivotGrid Control
How to: Format Cell Values
How to: Obtain Underlying Data (Drill-Down)
Grouping, Filtering and Summarizing
Appearance
Miscellaneous
Scheduler
Rich Text Editor
Tree List
Gauge Controls
Map Control
Dock Windows
Tile and Layout
Printing-Exporting
Data Editors
Navigation Bar
Utility Controls
Spell Checker
LightSwitch Reporting
Localization
Redistribution and Deployment
Get More Help
API Reference

How to: Bind a Pivot Grid to an OLAP Cube

The following example demonstrates how to bind a PivotGridControl to an OLAP cube via the XMLA data access standard.

In this example, OLAP connection parameters are specified in a connection string passed to the PivotGridControl.OlapConnectionString property.

The following parameters are provided:

  • Data Source - a path to a data pump that was previously configured on an IIS server and will be used as a middle-ware component to access the datasource;
  • Initial Catalog - a data catalog that contains cubes;
  • Cube Name - the name of the cube that provides OLAP data.

To learn how to bind a pivot grid to an OLAP cube step-by-step, see Lesson 1 - Binding a Pivot Grid to an OLAP Cube.