Skip to Content
0
Former Member
Apr 14, 2010 at 08:59 AM

How to update a characteristic in a cube ?

38 Views

Hi all,

is there a more comfortable to update an InfoCube record directly ? Or better to update a characteristic value of an InfoCube record.

Example:

My InfoCube record has three characterisitcs C1, C2, C3 and on Key Figure KF1

Assumed one of the characteristics (C3) is empty (not assigned) and I want to populate some value in it.

C1: AAA

C2: BBB

C3: #

KF1: 100

Right now, I have a transformation routine there the source is the same InfoCube. In Start- respectively Endroutine I'm able to add two records: the first does reverse the oriignal record and the second comes in with same KeyFigure value(s) and updated characteristic. At the end my cube's content does look like this:

C1 C2 C3 KF1

AAA BBB # 100 (original record)

AAA BBB # -100 (reverse the original)

AAA BBB CCC 100 (new "updated" record)

Generally that works fine as long as noone creates a query with disabled zero suppression. If there is no zero suppression active , then the query shows the aggregated zero value on AAA,BBB,# combination.

Therefore I would like if there is a possibility to directly updated my oriiginal record, so that at the end I have still only one record in my cube like

C1 C2 C3 KF1

AAA BBB CCC 100

Would s.o. know how this could work ?

Thanks