Prevent Negative values for Key Figures in SAP IBP

[Former Member]

Hello Experts,

Is there a way to prevent negative value upload in IBP KFs - through data integration as well as through Excel UI.

Regards,

A.Basu.

[Praveen_Jadhav · Accepted solution]

Hi Basu,

To prevent uploading negative values through the data integration app is not possible - you have to remove the -ve values from the upload file.

However, you can use CPI-DS for excluding negative values (there is a function available) for uploaded in IBP KFs.

In the case of Excel UI, there is an option of Data Validation. To use this functionality you need to have a template that contains these KFs and then activate the data validation for the KFs in the "EPM Formatting sheet" i.e. to only allow values >=0 (keeping ignore blank values) when you input the data.

Hope it Helps.

Regards,

Praveen

[Former Member · Accepted solution]

Hi Praveen,

Thanks for the response. I think the best way is use CPI-DS function along with Data Validation option in Excel. Also, should upload Excel with negative values.

Regards,

A. Basu

[manoj_gaikwad]

HI For Excel addin,

You can use EPM Data Validation check to restrict only positive values to be entered.

Note: This will only work when the user loads the specific template where the Data validation checks have been enabled.

Regards.

Manoj

[Former Member]

Hi Manoj,

Thanks for the response. EPM works fine for excel views. Wanted to check if negative value upload can be prevented.

Regards,

A.Basu

[manoj_gaikwad]

Hi Basu,

Using EPM you can prevent negative values from getting uploaded in IBP Excel addin.

Got to EPM -> Select the KF for which Checks needs to be enabled -? Right click and select EPM -> Data Validation.

Here you can put a cehck that on values grater than or equal to 0 can be entered.

Hope this helps.

Regards,

Manoj

[abasu07]

Thanks Manoj. This worked too

[former_member654033]

Hi,

I think at CPIDS level you may restrict it but with data integration job I don't think you can for excel upload.

Another option is after upload, use the KF syntax to suppress the -ve values in a calculated KF and then later using this calculated KF in other calculation.

Please check if this can help you.

Thanks

Girish

[Former Member]

Thanks Girish for the response. I have tried the option of a calculated KF & it worked, but was confirming if by any means we can stop negative value load through excel file load.