public async Task ExecuteCellSetAsync()
{
var connection = new XmlaConnection("Data Source=http://localhost/OLAP/msmdpump.dll;Initial Catalog=Analysis Services Tutorial");
await connection.OpenAsync();
//var statment = "SELECT FROM [Analysis Services Tutorial] WHERE [Measures].[Internet Sales Count]";
//var statment = "SELECT {HEAD(NONEMPTY({{[Product].[Category].[Category].ALLMEMBERS}}), 250000)} DIMENSION PROPERTIES MEMBER_TYPE ON 0 FROM [Analysis Services Tutorial] WHERE [Measures].[Internet Sales Count]";
var statment = "SELECT {HEAD(NONEMPTY({{[Product].[Category].&[4],[Product].[Category].&[1]}*{[Date].[Fiscal Year].[Fiscal Year].ALLMEMBERS}*{[Reseller Geography].[Country-Region].[Country-Region].ALLMEMBERS}}), 250000)} DIMENSION PROPERTIES MEMBER_TYPE ON 0 FROM [Analysis Services Tutorial] WHERE [Measures].[Internet Sales Count]";
var command = new XmlaCommand(statment, connection);
CellSet cellset = null;
cellset = await command.ExecuteCellSetAsync();
Assert.IsTrue(cellset != null && cellset.Axes.Count > 0 && cellset.Cells.Count > 0);
await connection.CloseAsync();
}
public async Task ExecuteAsync()
{
bool assert = true;
var connection = new XmlaConnection("Data Source=http://localhost/OLAP/msmdpump.dll;Initial Catalog=Analysis Services Tutorial");
var command = new XmlaCommand("", connection);
try
{
var result = await command.ExecuteAsync();
}
catch
{
assert = false;
}
Assert.IsTrue(assert);
}
public static XmlaConnection CreateConnectionToSsas(string sessionId = "")
{
SqlConnectionStringBuilder csBuilder = new SqlConnectionStringBuilder();
csBuilder.DataSource = TEST_DATASOURCE;
csBuilder.InitialCatalog = TEST_CATALOG;
csBuilder.ConnectTimeout = 30;
csBuilder.UserID = TEST_USERNAME;
csBuilder.Password = TEST_PASSWORD;
string cs = csBuilder.ConnectionString;
var connection = new XmlaConnection(cs);
if (!string.IsNullOrEmpty(sessionId))
{
connection.SessionID = sessionId;
}
return(connection);
}
public static XmlaConnection CreateConnectionToSsas(string sessionId = "")
{
SqlConnectionStringBuilder csBuilder = new SqlConnectionStringBuilder();
csBuilder.DataSource = "http://localhost/OLAP/msmdpump.dll";
csBuilder.InitialCatalog = @"Analysis Services Tutorial";
csBuilder.ConnectTimeout = 30;
//csBuilder.UserID = "sa";
//csBuilder.Password = "******";
//Data Source=http://localhost/OLAP/msmdpump.dll;Initial Catalog="Analysis Services Tutorial";Connect Timeout=30
string cs = csBuilder.ConnectionString;
var connection = new XmlaConnection(cs);
if (!string.IsNullOrEmpty(sessionId))
{
connection.SessionID = sessionId;
}
return(connection);
}
public static async Task <CubeDef> GetCubeAsync(XmlaConnection connection, string cubeName = "Analysis Services Tutorial")
{
return(await connection.Cubes.FindAsync(cubeName));
}
public static CubeDef GetCube(XmlaConnection connection, string cubeName = "Analysis Services Tutorial")
{
return(connection.Cubes.Find(cubeName));
}
public static async Task <CubeDef> GetCubeAsync(XmlaConnection connection, string cubeName = TEST_CUBE_NAME)
{
return(await connection.Cubes.FindAsync(cubeName));
}
public static CubeDef GetCube(XmlaConnection connection, string cubeName = TEST_CUBE_NAME)
{
return(connection.Cubes.Find(cubeName));
}
public CellSet(XmlaConnection connection, SoapEnvelope envelope)
{
_connection = connection;
_envelope = envelope;
}
public CubeCollection(XmlaConnection connection)
{
Connection = connection;
}
