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