Using MDX in Essbase connector

[Anonymous]

Hi, 

Trying to get the Essbase connector to work using MDX. Questions: 

I know the URL I have to specify to use import/direct querry. It looks something like this: 

http://XXX.XX.XXX.XXX:XXXXX/aps/XMLA

Question: 

What do I specify in the fields which become mandatory when I type in MDX: 

1) Server? 

2) Application? 

Does anyone have a basic example where this works? 

Thanks in advance for your help! 

Marcin

[v-juanli-msft · Accepted solution]

Hi @Anonymous 

When using MDX to connect to Essbase, we use "Essbase.Cubes"

Syntax
Essbase.Cubes(url as text, optional options as nullable record) as table

It returns a table of cubes grouped by Essbase server from an Essbase instance at APS server url. 

The url should be like

http://host: port/aps/XMLA

For example: http://host:port/aps/Essbase?ClusterName=EssCluster1.

This is APS URL with an Essbase cluster name,

where host:port is the APS server to resolve the Essbase cluster name. 

For example, EssServer1:1423

It specifies the Essbase server directly

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

@v-juanli-msft 

Thanks a lot for your advise. I will work with the group responsible for Essbase to understand what are the right parameters. Your answer will make it way way easier! 

Really appreciate. 

Marcin