README.md

incorta-Essbase-Connector

usage: EsbDataQuery

Parameter	Use
-App <-App=applicationname>	Essbase Application
-checkSyntax	Check MDX syntax
-D <-D>	Use this if you are using encryption
-Db <-Db=databasename>	Essbase Database
-delimiter <-delimiter=delimitercharacter>	Delimiter character
-encrypt <-encrypt=>	Use this for encrypting strings
-getData	Get data from the Essbase database <required\
-help	prints usage
-key <-key=key>	Key to encrypt strings
-MDX <-MDX=MDXQuery>	MDX query to get data <required|
-p <-p=password>	Password for connecting to Essbase <required>
-S <-S=servername>	Essbase Server Name
-u <-u=username>	Username for connecting to Essbase <required|

-u=admin -p=password -S=OEL5-INTEKGRATE -App=Sample -Db=Basic -getData -MDX="SELECT {[Jan],[Feb],[Apr]} ON COLUMNS,{[Sales],[COGS]} ON ROWS from [Sample.Basic] WHERE [New York];" -delimiter="|"

You can use check MDX syntax using

-u=admin -p=password -S=OEL5-INTEKGRATE -App=Sample -Db=Basic -getData -MDX="SELECT {[Jan],[Feb]} ON AXIS(1),{[Sales],[COGS]} ON AXIS(0),{[Actual]} ON AXIS(2), {[100-10]} on AXIS(3) from [Sample.Basic]" -checkSyntax

You can also use with expression MDX

WITH MEMBER [Measures].[Max Qtr2 Sales] AS 'Max ({[Year].[Qtr2]},[Measures].[Sales])' SELECT {[Measures].[Max Qtr2 Sales]} ON COLUMNS, {[Product].children} ON ROWS FROM Sample.Basic;