Technical data

Understanding Analytic Models Chapter 3
SALES
2004/01 2004/02 2004/03
010
020
070
090
COST_OF_GOODS
2004/01 2004/02 2004/03
010
020
070
090
Adding the 090 product code to the PRODUCT_CODES dimension on the SALES cube
When updating an analytic model, you can use a combination of existing a nd new d imensions when you
define a d ata cube. For example, suppose you createacubecalledSALARY.Youwanttotrackmonthly
data, so you attach the existing MONTHS dimension to the data cube. You also want to track the salary for
each employee, so you create a new EMPLOYEES dimension and attach it to the SALARY cube. This
is an example of this image:
18 Copyright © 1988-2007, Oracl e. All rights reserved.