Brook Preloader

Blog

Connectivity To Essbase Cube From On-Premises And Cloud In Microsoft Power BI And Oracle Analytics Cloud

Power BI is an Analytics tool and service that offers interactive and paginated reports, dashboards and apps. It connects to over 90 different data sources, including relational, flat files, websites and Big Data. Interface options are similar to Excel for advanced users.

Let us see how to connect to Essbase cubes or applications from Microsoft Power BI and Oracle Data Visualization (DV) in on-premises as well as cloud environments.

Power BI integration with on-premises Essbase:

The only adapter available for on-premises Essbase from Power BI (PBI) is Essbase. We can create dynamic dashboards to “slice and dice” our data and perform many types of analysis. Power BI is more robust than Smartview or OBIEE and allows us to perform better.

The Essbase adapter has a built-in connector that allows us to retrieve data directly from Essbase, at any level of the hierarchy, including aggregated and calculated data.

http://<SERVER NAME>:19000/aps/XMLA

The server name & port number are to be modified as per the environment. By clicking OK, we will be directed to the basic login screen, where the login credentials of the Essbase server are to be provided. After connecting to the application, go to the database and select the required fields.

Power BI integration with Essbase in Cloud:

Connection Steps:

  • Export data as Excel and load Offline as Cube
  • Export data as CSV and load offline as Table
  • Rest API, using Data Direct

As a table:

Power BI Desktop → Get Data → CSV/txt → Browse to file → Import → Rename Table.

As a cube:

Power BI Desktop → Get Data → Excel → Browse to file → Import → Bring each table into data view.

Web:

Power BI Desktop → Get Data → Web <Oracle Application Cloud URL> → Login with credentials as you would for OAC.

Connectivity to Essbase Cube from Oracle Data Visualization both on-premises and Cloud:

Oracle Data Visualization provides business users with a graphical representation of data and enables them to discover the hidden patterns within the dataset just by plugging the available data set. TheData Visualization user interface takes a few and simple inputs, then automatically creates rich graphics. Oracle Analytics Desktop is available as a stand-alone or as part of Oracle Analytics Cloud (OAC, which is an enterprise data visualization solution).

Connecting OACS (Data Visualization) to Essbase:

In order to connect to Essbase from OACS DV, we need Data Source Name (DSN) which is the connection URL to connect to Essbase as follows

http(s)://<instance>-<CloudAccount>.analytics.ocp.oraclecloud.com/essbase/agent

Comparison between Power BI & Oracle Data Visualization:

  Power BI Oracle DV
Price Free, Monthly Payment DV Desktop is free, Quote-Based
Installation Easy Complex
Special Features Q&A Question Box Data Column Filtering, Score Cards
Interactivity It has interactive dashboards with a real-time feed of data Real-time data visualization is enabled
Employee skills required Deep knowledge of MS Excel, as all BI solutions are based on Excel interface On-job or remote data visualization / analytics training is required
Publishing Published on SharePoint portals Published online through BI services
Advanced Analytics Not Available Predictive Analytics
Environment Multiplatform support (Web, Desktop, Mobile) Multiplatform support (Web, Desktop, Mobile)
Integrations MS PBI is integrated with the Microsoft Office 365 suite
Also Visio, OneNote, Outlook, Sway, etc. in addition to Excel, Word, PowerPoint etc.
Oracle Hyperion
Android & iOS Wearables
Cloudera Impala
Spotlight Search
Data Warehousing Yes No
Disadvantages The System frequently freezes up or slows down Deep data scientist / analytics skills are required for development.

Let us conclude the article with an example for the same data, how the dashboard will be in Power BI and Oracle DV for better understanding, which is as follows:

Power BI:

OACS DV:

Contact for further details

Mary Margaret Thumma
Technology Analyst – Analytics Visualization
maryt.in@mouritech.com
MOURI Tech

0 0 vote
Rating
guest
0 Comments
Inline Feedbacks
View all comments