Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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

 

 

 

 

 

 

 

Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    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.

2 Replies

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    7 years ago

    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's avatar
      Anonymous
      Not applicable
      7 years ago