Re: Data Warehouse Cursor Problem

>
> Without seeing the full schema and the full specification any helpful
> hint might be worse than wrong.
>
> What I would like to see, as an instructor, is formatting. put your
> keywords like SELECT, FROM, WHERE, ORDER BY in caps, be consistent
> with you use of case ... for example why is SALES_REP_ID capitalized?
> And 'FROM' should be on the left margin.
>

Daniel,
Thanks for the advice, I have formatted the code.

Just in case you or anyone else wants to see the relevant tables, here they are:

The fact table is structured thus:

Sale FACT table:

 CLIENT_TYPE_ID             NUMBER(4)
 PRODUCT_ID                    NUMBER(6)
 SR_ID                                  NUMBER(6)
 REGION_ID                        NUMBER
 TIMECODE                        VARCHAR2(10)
 QUANTITY                        NUMBER(4)
 SALEVALUE                      NUMBER(8)
 COSTVALUE                     NUMBER(8)

Region dimension table:
 REGION_ID                        NUMBER
 REGION_NAME                VARCHAR2(20)
 MANAGEMENT_AREA    VARCHAR2(20)
 COUNTRY                          VARCHAR2(20)

Operational Table Sales_region(The Region dimension table was populated using this table except for REGION_ID which was populated using a sequence.):

 REGION_ID                        NOT NULL NUMBER(4)
 REGION_NAME                VARCHAR2(20)
 MANAGEMENT_AREA    VARCHAR2(20)
 COUNTRY                         VARCHAR2(20)