change a charactaristic in a cube

[Former Member]

Hello,

I have a characteristic in a cube that I want to change its value from X to Y. I know that in an ODS I can do update rule to itself and in the start routine to change the value (it is possible because in ODS the key figure can be overwritten).

How can I do it in a cube?

David

[Former Member]

hi,

One option is that you'll have to chage it in the update rouitne and reload the data from PSA. Before you need to delete the data.

And the second one i could think is that try to write an ABAP code on the dim table to change it from X to Y. But i was not sure how this will react. Never tried it.

[Former Member]

Hi Siva,

The cube contain 10M records. I need to change more than 1000 records.

It is not practical to change it in the PSA.

What do you mean by ABAP code on the dim table ?

Thank you,

David

[Former Member]

I would do an update rule from the cube's export DataSource back to itself (or a transformation in 2004s). In the start routine, you can make 2 copies of each record.

In one copy, reverse the value of all the key figures so that the existing record will have zero values after update.

In the other copy, set the characteristic to the new value that you want it to have, leaving the original key figures intact.

This will make the totals the way you need them. If you have a need to remove those records, you can either do a compression that removes zeroes or a selective deletion on the same set of records that you selected for this update.