Oracle Essbase multi dimential data retrieval
Need to retrieve actual adn budget data by company business unit then by GL account using Essbase. Have been advised internally that Essbase gets confused with the dimensional (cross reference) request so will not retrieve the data. Does anyone out there have any idea what I am talking about and do you have any ideas what [...]

Answer Question   |  November 15, 2010  10:43 PM
Essbase, Online Analytical Processing, Oracle, Oracle Essbase, Oracle OLAP

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