dashboard-devexpress-dot-dashboardcommon-41c08e83.md
The OlapDataProvider class is obsolete now. Use the DashboardOlapDataSource classe instead.
Represents a data provider for an OLAP data source.
Namespace : DevExpress.DashboardCommon
Assembly : DevExpress.Dashboard.v25.2.Core.dll
NuGet Package : DevExpress.Dashboard.Core
[Obsolete("The OlapDataProvider class is obsolete now. Use the DashboardOlapDataSource classe instead.")]
public class OlapDataProvider :
IDisposable,
IDataProvider
<Obsolete("The OlapDataProvider class is obsolete now. Use the DashboardOlapDataSource classe instead.")>
Public Class OlapDataProvider
Implements IDisposable,
IDataProvider
The following members return OlapDataProvider objects:
The following code snippets show how to bind the dashboard to the OLAP cube using DashboardOlapDataSource.
DashboardOlapDataSource allows you to establish a connection to the OLAP cube by specifying a connection string.
using DevExpress.XtraBars.Ribbon;
using DevExpress.DashboardCommon;
using DevExpress.DataAccess.ConnectionParameters;
namespace Dashboard_OlapDataProvider {
public partial class Form1 : RibbonForm {
public Form1() {
InitializeComponent();
#region #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);
#endregion #OLAPDataSource
InitializeDashboardItems();
}
void InitializeDashboardItems() {
IDashboardDataSource olapDataSource = dashboardDesigner1.Dashboard.DataSources[0];
PivotDashboardItem pivot = new PivotDashboardItem();
pivot.DataSource = olapDataSource;
pivot.Values.Add(new Measure("[Measures].[Sales Amount]"));
pivot.Columns.Add(new Dimension("[Sales Channel].[Sales Channel].[Sales Channel]"));
pivot.Rows.AddRange(
new Dimension("[Sales Territory].[Sales Territory].[Group]", 1),
new Dimension("[Sales Territory].[Sales Territory].[Country]", 1),
new Dimension("[Sales Territory].[Sales Territory].[Region]", 1));
pivot.AutoExpandRowGroups = true;
ChartDashboardItem chart = new ChartDashboardItem();
chart.DataSource = olapDataSource;
chart.Arguments.Add(new Dimension("[Sales Territory].[Sales Territory].[Country]"));
chart.Panes.Add(new ChartPane());
SimpleSeries salesAmountSeries = new SimpleSeries(SimpleSeriesType.Bar);
salesAmountSeries.Value = new Measure("[Measures].[Sales Amount]");
chart.Panes[0].Series.Add(salesAmountSeries);
dashboardDesigner1.Dashboard.Items.AddRange(pivot, chart);
}
}
}
Imports DevExpress.XtraBars.Ribbon
Imports DevExpress.DashboardCommon
Imports DevExpress.DataAccess.ConnectionParameters
Namespace Dashboard_OlapDataProvider
Partial Public Class Form1
Inherits RibbonForm
Public Sub New()
InitializeComponent()
' #Region "#OLAPDataSource"
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)
' #End Region ' #OLAPDataSource
InitializeDashboardItems()
End Sub
Private Sub InitializeDashboardItems()
Dim olapDataSource As IDashboardDataSource = dashboardDesigner1.Dashboard.DataSources(0)
Dim pivot As New PivotDashboardItem()
pivot.DataSource = olapDataSource
pivot.Values.Add(New Measure("[Measures].[Sales Amount]"))
pivot.Columns.Add(New Dimension("[Sales Channel].[Sales Channel].[Sales Channel]"))
pivot.Rows.AddRange(New Dimension("[Sales Territory].[Sales Territory].[Group]", 1), New Dimension("[Sales Territory].[Sales Territory].[Country]", 1), New Dimension("[Sales Territory].[Sales Territory].[Region]", 1))
pivot.AutoExpandRowGroups = True
Dim chart As New ChartDashboardItem()
chart.DataSource = olapDataSource
chart.Arguments.Add(New Dimension("[Sales Territory].[Sales Territory].[Country]"))
chart.Panes.Add(New ChartPane())
Dim salesAmountSeries As New SimpleSeries(SimpleSeriesType.Bar)
salesAmountSeries.Value = New Measure("[Measures].[Sales Amount]")
chart.Panes(0).Series.Add(salesAmountSeries)
dashboardDesigner1.Dashboard.Items.AddRange(pivot, chart)
End Sub
End Class
End Namespace
Object OlapDataProvider
See Also