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
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.