Essbase API’s used by CXO
Outline API for retrieving metadata from Essbase
MDX Provider API for executing MDX queries to retrieve data from Essbase
N.b.: CXO Software does not utilize the Essbase Grid API
CXO Essbase session management
CXO Essbase session management depends on the “Essbase Connector: Open Connection Per Query“ setting:
Setting set to “true“
The Essbase session scope will be per HTTP Request.
The Essbase session (“set active” Essbase command) starts whenever we execute Essbase query from CXO and set to inactive (“clear active” Essbase command) when http request finishes.
Example: if we have a report which in one api call executes 4 essbase mdx queries, then all those mdx queries will be executed in one session and then session will be set to inactive.
Setting set to “false“
The Essbase session will be active till the user logs us. CXO calls “clear active” Essbase command on logout.