Skip to Content
0
Former Member
Jul 06, 2011 at 04:15 AM

Modify Cube Data

13 Views

Hi Experts,

Is it possible to modify specific data in a cube?

For example:

I want to modify the Div data from 6 to9 and div data from 5 to 6 for all the rows where PRD = 100.

i.e.

UPDATE table_name
SET Div = 9
WHERE PRD = 100 AND Div = 6

UPDATE table_name
SET Div = 6
WHERE PRD = 100 AND Div = 5

Current data:

RET	PRD	KEY	Div	Wnr	 Amnt
123	100	200	2	1	 $30,677.00 
124	100	200	3	2	 $2,038.00 
129	100	200	4	3	 $60.00 
131	100	200	5	25	 $100.00 
132	100	200	5	33	 $132.00 
133	100	200	6	1	 $-   

After modification of Div data from 6 to 9 and 5 to 6:

RET	PRD	KEY	Div	Wnr	 Amnt
123	100	200	2	1	 $30,677.00 
124	100	200	3	2	 $2,038.00 
125	100	200	3	2	 $2,038.00 
126	100	200	3	2	 $2,038.00 
127	100	200	4	2	 $40.00 
128	100	200	4	6	 $120.00 
129	100	200	4	3	 $60.00 
131	100	200	6	25	 $100.00 
132	100	200	6	33	 $132.00 
133	100	200	9	1	 $-   

Please let me know if you need any further clarification.

Thanks a lot