cancel
Showing results for 
Search instead for 
Did you mean: 

Updating key figures in BI Infocube from update rules

Former Member
0 Kudos

Hi,

  I have a 3.x standard content flow for an infocube (9ADEMAND in SAP SCM SPP).  There are quantity related key figures in cube. I am loading data for this cube from a file and the input for these quantities could be negative. I need to make the key figures 0 if the final/target value is negative. ie., in the infocube if there is a value of 20 and if I am loading -50, the final value in cube will be -30. In such scenarios, I need to make the KF as 0 instead of -30. I checked in the update rules (start routine, routine specific to that IO) but I couldn't  do it. what is the best way to achieve this?

Regards,

Anu

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi Anu

Have u fixed this issue of -ve values.

we are getting -ve values in 9ADEMAND, when transfer of data from DSO to INFO CUBE,

please share if u have solved this issue.  thanks

with regards

SRS Kannan

esjewett
Active Contributor
0 Kudos

Since this is a question about BW, it belongs in the BW space (called SAP Netweaver Business Warehouse) and not the Data Warehousing space. I've moved the thread, but please use this space for these types of questions in the future.

Regards,

Ethan

(moderator)

former_member182470
Active Contributor
0 Kudos

Hi,

Try with Update Routine.

Regards,

Suman