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.