Data Binding in WPF OLAP Gauge

18 Nov 20183 minutes to read

Binding an OLAP gauge to an offline cube

To connect to an OLAP cube available on the local machine, the physical path of the cube should be specified in the connection string. The following code snippet illustrates the same.

  • C#
    • string connectionString = @"DataSource = system drive:\Cube\Adventure_Works_Ext.cub; Provider = MSOLAP;";
OlapDataManager DataManager = new OlapDataManager(connectionString);

    Binding an OLAP gauge to a cube in local SQL Server

    To connect to the OLAP cube available in SQL Server Analysis Services on the local machine, the server name and database name should be specified in the connection string. The following code example illustrates the same.

    NOTE

    If credentials are required to connect to the cube, specify the user ID and password accordingly.

    string connectionString = "Data source=localhost; Initial Catalog=Adventure Works DW;";
OlapDataManager DataManager = new OlapDataManager(connectionString);
    Dim connectionString As String = "Data source=localhost; Initial Catalog=Adventure Works DW;"
Dim DataManager As New OlapDataManager(connectionString)

    Binding OLAP gauge to cube in online SQL Server

    To connect to the OLAP cube available in SQL server Analysis Services on a the online server through XML/A, the host server link and database name should be specified in the connection string. The following code example illustrates the same.

    NOTE

    If credentials are required to connect to the cube, specify the user ID and password accordingly.

    string connectionString = "Data Source=http://bi.syncfusion.com/olap/msmdpump.dll; Initial Catalog=Adventure Works DW 2008 SE;";
OlapDataManager DataManager = new OlapDataManager(connectionString);
    Dim connectionString As String = "Data Source=http://bi.syncfusion.com/olap/msmdpump.dll; Initial Catalog=Adventure Works DW 2008 SE;"
Dim DataManager As New OlapDataManager(connectionString)

    Binding OLAP gauge to cube in online Mondrian server

    To connect to the OLAP cube available on a Mondrian server through XML/A, the host server link and database name should be specified in the connection string. The following code example illustrates the same.

    NOTE

    If credentials are required to connect to the cube, specify the user ID and password accordingly.

    string connectionString = @"Data Source = http://localhost:8080/mondrian/xmla; Initial Catalog =FoodMart;";
OlapDataManager DataManager = new OlapDataManager(connectionString);
DataManager.DataProvider.ProviderName = Syncfusion.Olap.DataProvider.Providers.Mondrian;
    Dim connectionString As String = "Data Source = http://localhost:8080/mondrian/xmla; Initial Catalog =FoodMart;"
Dim DataManager As New OlapDataManager(connectionString)
DataManager.DataProvider.ProviderName = Syncfusion.Olap.DataProvider.Providers.Mondrian

    Binding OLAP gauge to cube in online ActivePivot Server

    To connect to the OLAP cube available in ActivePivot Server through XML/A, the host server link and database name should be specified in the connection string. The following code example illustrates the same.

    NOTE

    If credentials are required to connect to the cube, specify the user ID and password accordingly.

    string connectionString = @"Data Source = http://localhost:8080/cva_s/xmla; Initial Catalog = CVAS;";
OlapDataManager DataManager = new OlapDataManager(connectionString);
DataManager.DataProvider.ProviderName=Syncfusion.Olap.DataProvider.Providers.ActivePivot;
    Dim connectionString As String = "Data Source = http://localhost:8080/cva_s/xmla; Initial Catalog = CVAS;"
Dim DataManager As New OlapDataManager(connectionString)
DataManager.DataProvider.ProviderName=Syncfusion.Olap.DataProvider.Providers.ActivePivot