cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mrbajana Frequent Visitor
Frequent Visitor

Oracle OLAP

Somebody knows how to connect an Oracle Olap DatabaBase or Oracle Cube

6 REPLIES 6
mrbajana Frequent Visitor
Frequent Visitor

Obiee Oracle Business Intelligence

How do I connect to Oracle DataWareHouse or Cubes in Power BI??

Moderator v-yuezhe-msft
Moderator

Re: Oracle OLAP

Hi @mrbajana

There is no built-in connector for Oracle OLAP or cube in Power BI Desktop. As a workaround, you can connect to Oracle OLAP in Excel using Simba MDX OLE-DB Provider, then connect to the Excel file via “File->Import->Excel workbook contents” in Power BI Desktop.

For more details about connecting to Oracle OLAP in Excel using Simba MDX OLE-DB Provider, please review the following articles.
http://www.oracle.com/webfolder/technetwork/tutorials/obe/db/11g/r2/prod/bidw/olap11g_excel/olap_exc...
https://www.rittmanmead.com/blog/2010/08/oracle-olap-11g-reporting-in-excel-using-simba-mdx-ole-db-p...


Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
mrbajana Frequent Visitor
Frequent Visitor

Re: Oracle OLAP

Thanks a lot Lydia for your Answer. 

 

Marco

sandralynn Frequent Visitor
Frequent Visitor

Re: Oracle OLAP

Oracle offers Essbase for customers without the Oracle Database or who require multiple data-sources to load their cubes.

harrygates Frequent Visitor
Frequent Visitor

Re: Oracle OLAP

We've created a full-fledged, supported Power BI to Essbase connector: https://casabasesoftware.com/introducing-the-power-bi-casabase-connector-for-oracle-essbase/

 

Let us know if you're interested.

 

Thanks,

Harry Gates

Casabase Software

anitaberg Regular Visitor
Regular Visitor

Re: Oracle OLAP

Hi! I am currently assesing the same thing. Oracle OLAP cube connector to Power BI. Found this link interesting https://support.biconnector.com/support/solutions/articles/8000048783-connect-power-bi-desktop-to-ob...

 

That again I found at Tableau https://community.tableau.com/docs/DOC-9857. Looks like they are recomending that connector for Tableau. And it looks like it can conncet directly to Oracle reports which is what I want to do.

 

This thread is relevant too: http://community.powerbi.com/t5/Desktop/Connect-to-OBIEE-RPD-using-ODBC-Connection/td-p/33008 Was able to connect by using Blank Query and pasting the info below, and fist setting up ODBC connection in Windows (https://gerardnico.com/dat/obiee/obis/odbc_driver_bi_server_create). Also I put a setting to the Presentation layer in Oracle Administration Tool to Export logical keys.

 

let
    Source =  Odbc.DataSource("dsn=MYDSN", [HierarchicalNavigation=false])
in
    Source