This project is read-only.
AdomdExtensions is a class library for data access from .NET to SSAS OLAP cubes via raw MDX.
It can be used with or without ADO.NET Entity Framework.
AdomdExtensions library allows to execute MDX and map ADOMD.NET result recordset into .NET objects mapping MDX hierarchical names to .NET property names. Typically because of names mismatch ADOMD.NET is used via positional binding, which is more fragile to changes compared to name match binding offered by AdomdExtensions.
AdomdExtensions is often a work around in cases when SSAS Entity Framework Provider does not provide functionality that is present in MDX (e.g. pivoting).

These are some examples of AdomdExtensions usage:

Scalar result:

var orders = adomdConnection.ExecuteMdxScalar<OrderDetail>
(
select
{
Measures.Quantity,
Measures.Unit Price,
Measures.Discount
}
on columns
from NorthwindEF


Collection result:

var customers = adomdConnection.ExecuteMdxCollection<Customer>
(
@"
with member Measures.Blank
as null
select
Measures.Blank
on columns,
(
Customers.Customer ID.Customer ID,
Customers.Contact Name.Contact Name,
Customers.Company Name.Company Name,
Customers.Contact Title.Contact Title
)
on rows
from NorthwindEF"
);

Last edited Sep 9, 2011 at 1:26 AM by grand, version 6

Comments

No comments yet.