Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> slowly changing Dimensions and cubes in owb

slowly changing Dimensions and cubes in owb

From: <Douglas.Pieter_at_gmail.com>
Date: 4 Aug 2005 07:38:51 -0700
Message-ID: <1123166331.866507.191840@f14g2000cwb.googlegroups.com>


Hi,

I want to create a database with SCD in owb. (type 2 = with effective_date and expiration_date)

The dimensions are ok.
But the problem is that if the dimension changes i have to add a new record into the cube. (the pk of the dim changes)

Is there a fix for this problem or is this normal?

The dimensions look like this:

   name:GEO_DIM_TYPE2
   Level1: CITY
   Level1 attributes: polulation/name/id    Level2: STATE
   Level1 attributes: buget/name/id
   hierachy:GEO
   hierachy levels:state and city
   column: EFFECTIVE_DATE/EXPIRATION_DATE

The cube looks like this

   name: mycube
   the dimensions connected to the cube GEO_DIM_TYPE2.state.id    measures: countryname
   column: EFFECTIVE_DATE/EXPIRATION_DATE

Pieter, Received on Thu Aug 04 2005 - 09:38:51 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US