I would like to start using the OLAP functionality now built in to SQL Developer. I would like to create an Analytical Workspace, Dimensions, Measures etc. The help says
To create an analytic workspace:
In the Connectors navigator under OLAP Option, right-click Analytic Workspaces, and select New Analytic Workspace.
Complete the New Analytic Workspace dialog box and click OK.
The new analytic workspace appears under Analytic Workspaces
I am not seeing an OLAP Option. How do I access it? I do see it in the version 4EA2, but there are no functions attached to it. I do not see in the production release version 4. If it was removed from the scope of version 4, is it scheduled to be part of a future implementation?
I have (per the help) gone to the About option on the help menu and clicked on Extensions. I see the OLAP extension listed, so if I understand correctly, it should be loaded.
I am using Windows 7 64 bit, and SQL Developer:
If you read the OLAP section in the release notes, you will see SQL Developer provides this OLAP support for Oracle Database 12c Release 1 (220.127.116.11.0) or higher:
The OLAP Option node should appear in the Connections navigator tree for a 12c connection. You can also verify in Tools > Features > Database that the OLAP feature's box is checked.
SQL Developer Team