Essbase: ODBC driver for MS SQL (source code )

Essbase: ODBC driver for MS SQL

his decision for getting Essbase data on the database side with out any flat files. It’s executes   MDX query through APS server and returns result as table grid. Also you can use any parameters in the MDX query for getting Dynamic Data

For use it you need knowledge of this topics

  1. Essbase MDX Query
  2. MS SQL TSQL Table Function
  3. CLR C# Extensions for MS SQL

Any way to install this you need to go this following steps
1) Download DLL files
2) Install CLR extensions to the MSSQL server (2008 or 2012)

3) Fix name of APS server (must be placed with essbase on the same server ) Essbase login and password
4) and execute MDX

SELECT NON EMPTY {( [Actual])} ON COLUMNS,
NON EMPTY NONEMPTYBLOCK CrossJoin (CrossJoin (Descendants ([Product]) , Descendants ([Market]) ), CrossJoin ({[Jan]} ,{[COGS]} ))
ON ROWS FROM Sample.Basic

If you need make changes – you can download source code
or the Visual Studio 2010 Express Essbase ODBC TSQL interface project

p.s. Also you can refer post on the Russian