1. D Cube R2 Software Developers

Im new to oracle multidimensional models...

D Cube R2 Software Developers

I have followed the 'Creating a Multidimensional Model' 15 min Oracle tutorial. Tutorial LinkNote: This tutorial use sql developer data modeler.

• This article is created to help those technical newbies who want to learn creation of OLAP Cube in SSAS (SQL Server Analysis Services) using Microsoft BIDS (Business Intelligence Development Studio) Environment and Data Warehouse. We will first take a glimpse at the basic introduction to requirement.
• Software Developer; Creative Designer. I'm going to create a more complicated 3-D object. It's going to be a cube that I can rotate along any of the three spatial directions. Creating a 3-D.

Building a Cube in Analysis Services Step by Step and Best Practices Rhode Island Business Intelligence Group November 15, 2012. Business Intelligence Development Studio. HP Pavilion dv6; Dual core, 8GB RAM Windows 7 Ultimate Software SQL Server 2008 R2.

I would like to know how to query the created data cube using SQL Developer (I.E. using regular SQL DML statements). Every time I look for information online I end up getting links on how to use the Oracle Analytic Workspace Manager. Why? I would like to just build the cube and query it without having to make use of the Oracle Analytic Workspace Manager.

I would appreciate if somone could let me know if I am missing some steps. (a short simple example would be nice)

Thanks in advance.

1 Answer

I realize you asked this in August 2013, but in case it still helps you or others, as of Feb 2014, SQL Developer has an OLAP extension which seems to be what you were looking for...

The OLAP extension enables you to use the familiar environment of SQL Developer to create and manage dimensional objects in Oracle Database 12c Release 1 (12.1.0.1.0) or higher. Oracle OLAP provides advanced multidimensional analytic capabilities and storage within the database, including excellent query performance, fast incremental data updates, efficient management of summary data, and rich analytic content, such as time series calculations and both additive and nonadditive aggregations.

Not the answer you're looking for? Browse other questions tagged oracleoracle11goracle-sqldeveloperolap-cubeoracle-olap or ask your own question.