public void Parse_NotValidMdx_Failed()
{
var query = "SELECT [Measures].[NonEXisting] ON 0, [Date].[Calendar].[Calendar Year].&[2010] ON 1 FROM [Adventure Works]";
var cmd = new AdomdCommand(query, new AdomdConnection(ConnectionStringReader.GetAdomd()));
var qe = new QueryAdomdEngine(cmd);
var pr = qe.Parse();
Assert.That(pr.IsSuccesful, Is.False);
}
public void ExecuteCellSet_ValidMdx_CellSetWithFormatProperties()
{
var query = "SELECT [Measures].[Amount] ON 0, [Date].[Calendar].[Calendar Year] ON 1 FROM [Adventure Works]";
var cmd = new AdomdCommand(query, new AdomdConnection(ConnectionStringReader.GetAdomd()));
var qe = new QueryAdomdEngine(cmd);
var cellSet = qe.ExecuteCellSet();
var cell = cellSet.Cells[0, 0];
Assert.That(cell.FormattedValue, Is.EqualTo("$1,874,469.00"));
}
public void Execute_ValidMdx_GetResult()
{
var query = "SELECT [Measures].[Amount] ON 0, [Date].[Calendar].[Calendar Year] ON 1 FROM [Adventure Works]";
var cmd = new AdomdCommand(query, new AdomdConnection(ConnectionStringReader.GetAdomd()));
var qe = new QueryAdomdEngine(cmd);
var ds = qe.Execute();
Assert.IsInstanceOf <string>(ds.Tables[0].Rows[0][0]);
Assert.AreEqual((string)ds.Tables[0].Rows[0][0], "CY 2005");
Assert.AreEqual((string)ds.Tables[0].Rows[1][0], "CY 2006");
Assert.IsInstanceOf <double>(ds.Tables[0].Rows[1][1]);
}
public void Execute_ValidMdxWithNull_GetResult()
{
var query = "SELECT [Measures].[Amount] ON 0, [Date].[Calendar].[Calendar Year].&[2010] ON 1 FROM [Adventure Works]";
var cmd = new AdomdCommand(query, new AdomdConnection(ConnectionStringReader.GetAdomd()));
var qe = new QueryAdomdEngine(cmd);
var ds = qe.Execute();
Assert.IsInstanceOf <string>(ds.Tables[0].Rows[0][0]);
Assert.AreEqual((string)ds.Tables[0].Rows[0][0], "CY 2010");
Assert.IsInstanceOf <System.DBNull>(ds.Tables[0].Rows[0][1]);
Assert.That(ds.Tables[0].Rows[0].IsNull(1), Is.True);
}
public void ExecuteCellSet_ValidMdx_CellSet()
{
var query = "SELECT [Measures].[Amount] ON 0, [Date].[Calendar].[Calendar Year] ON 1 FROM [Adventure Works]";
var cmd = new AdomdCommand(query, new AdomdConnection(ConnectionStringReader.GetAdomd()));
var qe = new QueryAdomdEngine(cmd);
var cellSet = qe.ExecuteCellSet();
Assert.That(cellSet, Is.InstanceOf <CellSet>());
Assert.That(cellSet.Cells[0, 0].Value, Is.InstanceOf <double>());
Assert.That(cellSet.Cells[0, 0].Value, Is.EqualTo(1874469));
Assert.That(cellSet.Axes[1].Positions[0].Members[0].Caption, Is.EqualTo("CY 2005"));
Assert.That(cellSet.Axes[1].Positions[1].Members[0].Caption, Is.EqualTo("CY 2006"));
}
public void Execute_ValidDax_GetResult()
{
var query = "EVALUATE CALCULATETABLE(VALUES('Product Subcategory'[Product Subcategory Name]),'Product Category'[Product Category Name] = \"Bikes\")";
var cmd = new AdomdCommand(query, new AdomdConnection(ConnectionStringReader.GetAdomdTabular()));
var qe = new QueryAdomdEngine(cmd);
var ds = qe.Execute();
Assert.IsInstanceOf <string>(ds.Tables[0].Rows[0][0]);
Assert.AreEqual((string)ds.Tables[0].Rows[0][0], "Mountain Bikes");
Assert.AreEqual((string)ds.Tables[0].Rows[1][0], "Road Bikes");
Assert.AreEqual((string)ds.Tables[0].Rows[2][0], "Touring Bikes");
Assert.AreEqual(ds.Tables[0].Rows.Count, 3);
Assert.AreEqual(ds.Tables[0].Columns.Count, 1);
}