Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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.
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.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
117 | |
104 | |
77 | |
73 | |
52 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |