Drill through with OLAP Universe on Essbase cube

[DeanFarrow]

Hi all

How can I achieve drill through from an Essbase cube to an Oracle database?

Is there an option in OLAP universes to achieve this?

If not do I have alternative options?

Thank you for your help and kind regards,

Dean

[Former Member · Accepted solution]

Hi,

There is no way to activate drill-through from Essbase to any other database within OLAP universes.

If you are using Web Intelligence you have 2 alternatives:

<li> The first one is to create 2 data providers (1 on Essbase and 1 on Oracle) and synchronize them.

This is not really a drill thorugh operation but you have both data sources in sync in the same document.

<li> The second option is to create 2 Web Intelligence documents (1 on Essbase and 1 on Oracle) and then parameterize the Essbase document to use Opendoc capabilities (hyperlink) to dril-through on the Oracle document.

Didier

[DeanFarrow · Accepted solution]

Thank you very much for your help.

Will OLAP universes have this capability in the future?

Kind regards,

Dean

[Former Member · Accepted solution]

This is in our plans but not in the coming releases.

Regards,

Didier