Can you create OLAP cubes using Oracle SQL Developer or Microsoft SQL Server Management Studio?

Question

Can you create OLAP cubes using Oracle SQL Developer or Microsoft SQL Server Management Studio?

Answer 1

Microsoft SQL Server:

You can access SQL Server Analysis Services (SSAS) OLAP cubes from Microsoft SQL Server Management Studio. In order to create cubes, you'll need to install SQL Server Data Tools (SSDT).

Oracle:

Analytic Workspace Manager is the primary tool for creating, developing, and managing dimensional objects in Oracle Database.

There is also an Oracle SQL Developer OLAP extension. See this answer for details.