Oracle OLAP degenerate dimension
Hi, How to declare a dimension as degenerate dimension in oracle Analytic workspace manager(AWM) tool? Is there any other tool to achieve this or any manual process involved? Thanks in advance, Vinay

Answer Question   |  March 25, 2009  6:56 AM
Degenerate Dimension, Online Analytical Processing, Oracle Analytic Workspace Manager, Oracle AWM, Oracle OLAP

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