How to connect the Essbase data Dynamically

[Dasarinavya]

Hi all ,Hope all are Good, i have a small query today

Currently iam working on june file how to connect the essbase data with main data dynamically  is there any logic for this how to resolve this query please help me i hve attached the files below.

[apathetichell]

Are you pulling data from Oracle Essbase/Hyperion? You probably have an excel add-in going on in the background. You can probably pull this via API with Alteryx but you may need a service accoune. 

[albert_alaluf]

Hi @Dasarinavya 

You can use exoinsight Alteryx connectors from casabasesoftware , after then you can use the connector or API.

[Dasarinavya]

Thank you all