dimension error

[culonbu]

hi expert,

i have a problem when creating time dimension.

here is my table structure
Name Null? Type
----------------------------------------------------- -------- -------------------------
TOTTIME CHAR(7)
FNCL_YR NUMBER
FNCL_QTR VARCHAR2(82)
FNCL_MTH VARCHAR2(8)
FNCL_PRD NOT NULL NUMBER(6)


and sample data


TOTTIME FNCL_YR FNCL_QTR FNCL_MTH FNCL_PRD
------- --------- ------------ -------- ---------
TOTTIME 2001 Q1/2001 Aug 2000 200105
TOTTIME 2001 Q1/2001 Aug 2000 200106
TOTTIME 2001 Q1/2001 Aug 2000 200107
TOTTIME 2001 Q1/2001 Aug 2000 200108
TOTTIME 2001 Q1/2001 Aug 2000 200109
TOTTIME 2001 Q1/2001 Jul 2000 200101
TOTTIME 2001 Q1/2001 Jul 2000 200102
TOTTIME 2001 Q1/2001 Jul 2000 200103
TOTTIME 2001 Q1/2001 Jul 2000 200104
TOTTIME 2001 Q1/2001 Jul 2000 200105
TOTTIME 2001 Q1/2001 Sep 2000 200109
TOTTIME 2001 Q1/2001 Sep 2000 200110
TOTTIME 2001 Q1/2001 Sep 2000 200111
TOTTIME 2001 Q1/2001 Sep 2000 200112
TOTTIME 2001 Q1/2001 Sep 2000 200113
TOTTIME 2001 Q1/2001 Sep 2000 200114
TOTTIME 2001 Q2/2001 Dec 2000 200122
TOTTIME 2001 Q2/2001 Dec 2000 200123
TOTTIME 2001 Q2/2001 Dec 2000 200124
TOTTIME 2001 Q2/2001 Dec 2000 200125
TOTTIME 2001 Q2/2001 Dec 2000 200126



dimension created:
CREATE DIMENSION dwdba.dwdim_baking
LEVEL tot_time IS dwcal_time_baking.tottime
LEVEL fncl_yr IS dwcal_time_baking.fncl_yr
LEVEL fncl_qtr IS dwcal_time_baking.fncl_qtr
LEVEL fncl_mth IS dwcal_time_baking.fncl_mth
LEVEL fncl_prd IS dwcal_time_baking.fncl_prd
HIERARCHY baking_rollup(
fncl_prd CHILD OF
fncl_mth CHILD OF
fncl_qtr CHILD OF
fncl_yr CHILD OF
tot_time)
;

after exec dbms_olap.validate_dimension('dwdim_baking','dwdba',false,true)

this is error i received:
OWNER TABLE_NAME DIMENSION_NAME RELATIONSHI BAD_ROWID
---------- -------------------- ------------------------------ ----------- ------------------
DWDBA DWCAL_TIME_BAKING DWDIM_BAKING CHILD OF AAAEyCAAFAAAEQFABF
DWDBA DWCAL_TIME_BAKING DWDIM_BAKING CHILD OF AAAEyCAAFAAAEQFABG
DWDBA DWCAL_TIME_BAKING DWDIM_BAKING CHILD OF AAAEyCAAFAAAEQGAAM
DWDBA DWCAL_TIME_BAKING DWDIM_BAKING CHILD OF AAAEyCAAFAAAEQGAAN
DWDBA DWCAL_TIME_BAKING DWDIM_BAKING CHILD OF AAAEyCAAFAAAEQGAAO
DWDBA DWCAL_TIME_BAKING DWDIM_BAKING CHILD OF AAAEyCAAFAAAEQGAAP
DWDBA DWCAL_TIME_BAKING DWDIM_BAKING CHILD OF AAAEyCAAFAAAEQGAAQ
DWDBA DWCAL_TIME_BAKING DWDIM_BAKING CHILD OF AAAEyCAAFAAAEQGAAR
DWDBA DWCAL_TIME_BAKING DWDIM_BAKING CHILD OF AAAEyCAAFAAAEQGAAS
DWDBA DWCAL_TIME_BAKING DWDIM_BAKING CHILD OF AAAEyCAAFAAAEQGAAo
DWDBA DWCAL_TIME_BAKING DWDIM_BAKING CHILD OF AAAEyCAAFAAAEQGAAp
DWDBA DWCAL_TIME_BAKING DWDIM_BAKING CHILD OF AAAEyCAAFAAAEQGAAq
DWDBA DWCAL_TIME_BAKING DWDIM_BAKING CHILD OF AAAEyCAAFAAAEQGAAr
DWDBA DWCAL_TIME_BAKING DWDIM_BAKING CHILD OF AAAEyCAAFAAAEQGAAs
DWDBA DWCAL_TIME_BAKING DWDIM_BAKING CHILD OF AAAEyCAAFAAAEQGAAt
DWDBA DWCAL_TIME_BAKING DWDIM_BAKING CHILD OF AAAEyCAAFAAAEQGAAu
DWDBA DWCAL_TIME_BAKING DWDIM_BAKING CHILD OF AAAEyCAAFAAAEQGABE
DWDBA DWCAL_TIME_BAKING DWDIM_BAKING CHILD OF AAAEyCAAFAAAEQGABF
DWDBA DWCAL_TIME_BAKING DWDIM_BAKING CHILD OF AAAEyCAAFAAAEQGABG
DWDBA DWCAL_TIME_BAKING DWDIM_BAKING CHILD OF AAAEyCAAFAAAEQGABH
DWDBA DWCAL_TIME_BAKING DWDIM_BAKING CHILD OF AAAEyCAAFAAAEQGABI



how can i find out what cause the error ?

any help appreciated.

[culonbu]

common *guys* and *gals*

there must be someome out there have solution for this problem ?