Skip to Content
0
Former Member
Feb 28, 2011 at 05:18 PM

Change entris on dimension table

37 Views

Hi All,

We have two entries in DIM table one for Fixed currency info object in the cube like blow.

1. DIMID SID_0CURRENCY SID_0SALES_UNIT

0 1000000044 2

DIMID is zero beacuse we have created Info Object with fixed currency.

Now we have to open this filed for all the currency but system not allowing to change the Info Object beacuse data in the cube and we have almost 2 Billion record in the cubes.

So we are thinking to do the changes like below.

We have another entries in the table for not fixed currency Info Object

2.DIMID ; SID_0CURRENCY SID_0SALES_UNIT

2 1000000045 3

SO now we are planning to overwrite record 1 with record 2. so my new record 1 look like below.

1. DIMID SID_0CURRENCY SID_0SALES_UNIT

02 1000000045 3

Please suggest me can we change the DIM table.

Saleem.