DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: dimension error

  1. #1
    Join Date
    Dec 2000
    Posts
    126
    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.


  2. #2
    Join Date
    Dec 2000
    Posts
    126

    Question

    common *guys* and *gals*

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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width