DashboardOlapDataSource Class

An OLAP data source that provides data for the dashboard.

Namespace: DevExpress.DashboardCommon

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

Declaration

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.

  1. 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.

  2. Add the created DashboardOlapDataSource object to the Dashboard.DataSources collection.
Note

For ASP.NET Core Dashboard, OLAP mode supports only XML for Analysis (XMLA) with MSMDPUMP. Set the DashboardOlapDataSource.OlapDataProvider static property to Xmla to specify the XMLA data provider.

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.

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)

Inheritance

Object
DashboardOlapDataSource

Implements

DevExpress.DashboardCommon.Native.IDashboardComponent
DevExpress.DataAccess.Native.ISupportPrefix
DevExpress.DashboardCommon.Native.IDashboardDataSourceInternal
DevExpress.DataAccess.Native.Sql.IDataConnectionParametersService
DevExpress.DataAccess.Native.ISensitiveInfoContainer
See Also