public class DashboardOlapDataSource :
    IDashboardDataSource,
    IDashboardComponent,
    IDisposable,
    IComponent,
    ISupportInitialize,
    ISupportPrefix,
    IDashboardDataSourceInternal,
    IDataComponent,
    IDataConnectionParametersService,
    ISensitiveInfoContainer

Public Class DashboardOlapDataSource
    Implements IDashboardDataSource,
               IDashboardComponent,
               IDisposable,
               IComponent,
               ISupportInitialize,
               ISupportPrefix,
               IDashboardDataSourceInternal,
               IDataComponent,
               IDataConnectionParametersService,
               ISensitiveInfoContainer

To create a data source that uses a connection to an OLAP cube, create the instance of the DashboardOlapDataSource class and perform the following steps.

Create the OlapConnectionParameters class object and specify the DashboardOlapDataSource.ConnectionString property.

Pass the resulting OlapConnectionParameters object to the DashboardOlapDataSource constructor.

Note
As an alternative, you can add a connection string with required parameters to the application configuration file. Then, assign the connection string name to the DashboardOlapDataSource.ConnectionName property.
Add the created DashboardOlapDataSource object to the Dashboard.DataSources collection.

Examples

The following example demonstrates how to bind a dashboard to an OLAP cube using DashboardOlapDataSource.

The DashboardOlapDataSource allows you to establish a connection to the OLAP cube by specifying a connection string.

Note

A complete sample project is available at https://github.com/DevExpress-Examples/how-to-bind-a-dashboard-to-an-olap-cube-using-dashboardolapdatasource-t216477.

VB.NET
C#

Dim olapParams As New OlapConnectionParameters()
olapParams.ConnectionString = "provider=MSOLAP;" _
                    & ControlChars.CrLf & _
                    "data source=http://demos.devexpress.com/Services/OLAP/msmdpump.dll;" _
                    & ControlChars.CrLf & _
                    "initial catalog=Adventure Works DW Standard Edition;" _
                    & ControlChars.CrLf & _
                    "cube name=Adventure Works;"

Dim olapDataSource As New DashboardOlapDataSource(olapParams)
olapDataSource.Fill()

dashboardDesigner1.Dashboard.DataSources.Add(olapDataSource)

OlapConnectionParameters olapParams = new OlapConnectionParameters();
olapParams.ConnectionString = @"provider=MSOLAP;
                      data source=http://demos.devexpress.com/Services/OLAP/msmdpump.dll;
                      initial catalog=Adventure Works DW Standard Edition;
                      cube name=Adventure Works;";

DashboardOlapDataSource olapDataSource = new DashboardOlapDataSource(olapParams);
olapDataSource.Fill();

dashboardDesigner1.Dashboard.DataSources.Add(olapDataSource);

Object

DashboardOlapDataSource

Implements

General Information

.NET Subscription

Common Tools

Desktop

Controls

Tools

Web

Controls and Extensions

Tools

Enterprise and Analytic Tools

Code / Debug / Refactor

Frameworks and Libraries

IOS, Android & Xamarin

General Information

.NET Subscription

Common Tools

Desktop

Controls

Tools

Web

Controls and Extensions

Tools

Enterprise and Analytic Tools

Code / Debug / Refactor

Frameworks and Libraries

IOS, Android & Xamarin

DashboardOlapDataSource Class

Declaration

Note

Examples

Note

Inheritance

Implements