Monday, December 12, 2016

Oracle Data Visualization Desktop Connecting to Essbase

With the December update to Oracle Data Visualization Desktop came the beta connection to Essbase.
This is a nice first step to OLAP connections but definitely has a way to go.
To create the connection to Essbase create a new Connection
Select Essbase
Provide Connection Information.  I just put the name of the server running Essbase. (IP address works too.)
Select your Cube
Create new Project
And view the Project Details

For Essbase users there are a few things to note:

  • Measures Dimension is flattened
  • Gen1 of the hierarchy is dropped
  • UDAs come in as separate columns on Dimension
Inspecting the Data Source provides very little information and there are no options to pick a dimension to use as measure.

This new connection is a great first step but harkens back to the days of OBIEE 10 connecting to Essbase.

I am looking forward to kicking the tires on this connection in some DVD Projects.