Skip to main content

Power BI

Completed

Hyperion ESSBASE

Vote (663) Share
Eric Vogelpohl's profile image

Eric Vogelpohl on 19 Dec 2014 12:16:37

Get data from Hyperion Essbase

Administrator on 13 Apr 2019 01:34:07

We're glad to let you know that this feature is now Generally Available. Please refer to the Power BI Desktop April release announcement for more details: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-april-2019-feature-summary/ Thanks for your feedback!

Comments (174)
Eric Vogelpohl's profile image Profile Picture

4434167f 95f2-4104-b9b2-02d012e680da on 05 Jul 2020 22:42:53

RE: Hyperion ESSBASE

Agree. We would definitely like to utilize Power BI with Essbase.

Eric Vogelpohl's profile image Profile Picture

518d107e 14f9-40da-8916-d74ff9eb5a59 on 05 Jul 2020 22:42:36

RE: Hyperion ESSBASE

Agree, this would help us a lot

Eric Vogelpohl's profile image Profile Picture

d74fb70c 8208-4b4c-bb15-bf5c0c44ada8 on 05 Jul 2020 22:42:08

RE: Hyperion ESSBASE

I agreee

Eric Vogelpohl's profile image Profile Picture

d74fb70c 8208-4b4c-bb15-bf5c0c44ada8 on 05 Jul 2020 22:42:08

RE: Hyperion ESSBASE

Plees

Eric Vogelpohl's profile image Profile Picture

ff73233a 1082-431c-9033-cf5419062ddb on 05 Jul 2020 22:41:19

RE: Hyperion ESSBASE

Pls push development

Eric Vogelpohl's profile image Profile Picture

d7b37ef4 f04e-4329-8ce3-e36a0ae91feb on 05 Jul 2020 22:41:12

RE: Hyperion ESSBASE

I have to implement few workaround based on SQL export but it's very dirty :(
http://hyperioncenter.blogspot.fr/2014/11/essbase-load-and-export-sql-data.html

Eric Vogelpohl's profile image Profile Picture

dac6413b 3030-4ea3-9873-bfb1cac50d8d on 05 Jul 2020 22:40:50

RE: Hyperion ESSBASE

I agreee

Eric Vogelpohl's profile image Profile Picture

bf84ef25 a258-4908-aa11-a85bb6a75014 on 05 Jul 2020 22:40:22

RE: Hyperion ESSBASE

This feature is crucial for several customers, is a deal breaker vs tableau and Qlik view

Eric Vogelpohl's profile image Profile Picture

331a9eb7 cb75-43f0-82bb-54fd03465d11 on 05 Jul 2020 22:39:36

RE: Hyperion ESSBASE

There is no connector, there may never be since Oracle could just block the connex or not support it from a licensing point of view (they did this with ancient Hyperion Analyzer).
What we did was use CubePort and port the cubes to SSAS (MD), and then connect PBI to those cubes. What was surprising is that the cubes we converted, especially the BSO ones were dramatically smaller than the originals, and the technology is similar, and the admin is now MS-oriented. Good luck.

Eric Vogelpohl's profile image Profile Picture

0275667c dc48-49ea-abbb-8a7cc502eeb5 on 05 Jul 2020 22:38:34

RE: Hyperion ESSBASE

Would be great to have such feature available. Looks like there is also a work around:
http://harrygates-essbase-blog.blogspot.nl/2016/09/power-query-how-to-connect-to-essbase.html

I