DashboardOlapDataSource Class

An OLAP data source that provides data for the dashboard.

Namespace : DevExpress.DashboardCommon

Assembly : DevExpress.Dashboard.v25.2.Core.dll

NuGet Package : DevExpress.Dashboard.Core

Declaration

C#
VB.NET

csharp

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

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

Remarks

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.
Add the created DashboardOlapDataSource object to the Dashboard.DataSources collection.

For .NET Dashboard, OLAP mode supports the following data providers:

XML for Analysis (XMLA) with MSMDPUMP
ADOMD.NET

Use the DashboardOlapDataSource.OlapDataProvider static property to specify the data provider.

Example

The following code snippets show 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.

Form1.vb
Form1.cs

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)

csharp

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);

Implements

IDashboardDataSource

IDataComponent

Inheritance

Object DashboardOlapDataSource