Forum Discussion
Using MDX in Essbase connector
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
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:1423It specifies the Essbase server directly
Best Regards
MaggieCommunity 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.
2 Replies
v-juanli-msftCommunity Support
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:1423It specifies the Essbase server directly
Best Regards
MaggieCommunity 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.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