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.
 
 

2 comments:

  1. Hi Wayne,
    I always use this method to open the ESSBASE via DVD, But my measures didn't show in the project list(Only the measure Folder), Does there have any setup on this ?

    Thanks,
    Norman

    ReplyDelete
  2. Any manual that recommend to learn more about cubes?

    ReplyDelete