Represents a data source, based on the MS SQL Server Analysis Services.

Object Model

Syntax

Visual Basic (Declaration)
Public NotInheritable Class MdxDataSource Inherits DataSourceBase Implements IDataSource, IMultiplePerspectives, IPersistXmlSettings

C#
public sealed class MdxDataSource : DataSourceBase, IDataSource, IMultiplePerspectives, IPersistXmlSettings

Remarks

You should use this class to analyze data from an OLAP cube, maintained by the MS SQL Server Analysis Services.

Example

The following code sample demonstrates how to set up a connection to the MS SQL Server Analysis Services.

C#	Copy Code
MdxDataSource mdxDataSource = new MdxDataSource(); mdxDataSource.ConnectionString = "Provider=SQLOLEDB.1;Data Source=localhost;Initial Catalog=Adventure Works DW"; mdxDataSource = "Adventure Works"; // Optional. mdxDataSource.Connect(); pivotView.DataSource = mdxDataSource;

Copy Code

MdxDataSource mdxDataSource = new MdxDataSource();
mdxDataSource.ConnectionString = 
 "Provider=SQLOLEDB.1;Data Source=localhost;Initial Catalog=Adventure Works DW";
mdxDataSource = "Adventure Works"; // Optional.
mdxDataSource.Connect();
            
pivotView.DataSource = mdxDataSource;

Inheritance Hierarchy

System.Object
GrapeCity.ActiveAnalysis.DataSources.DataSourceBase
GrapeCity.ActiveAnalysis.DataSources.MdxDataSource

Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2