Oracle OLAP degenerate dimension
HI, HI, Say, I want to create a data mart for sales Dimension: region,products Degenerate dimension: Order Number Measures: price,quantity Qyery: cross product A region B show order numbers where total quantity sold is more than 100000 How to achive this Oracle(11g) AWM or any other tool? How can I tag dimension as degenerate and [...]

Answer Question   |  March 19, 2009  7:47 AM
OLAP cube, Online Analytical Processing, Oracle 11g, Oracle Analytic Workspace Manager, Oracle AWM, Oracle Data Mart, Oracle OLAP

Data Modeling Tools for relational database & dimensional data mart
I am working with both an Oracle relational database as well as an Oracle data mart, with snowflake schema. Do I need a particular modeling tool to reverse engineer the data mart to produce a data model diagram? Presently I am using Toad Data Modeler to produce a data model for the transaction database.

Answer Question   |  May 31, 2008  2:27 PM
Data mart, Data Model Diagram, Data modeling, Oracle, Oracle Data Mart, Relational databases, Snowflake Schema, Toad Data Modeler