Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> slowly changing Dimensions and cubes in owb
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