UJ_VALIDATION in EMBEDDED BPC

[former_member331251]

Hello Experts,

In standard BPC we have the option to create Validation rules/BADI's for certain validations.

Is the same functionality is available for Embedded BPC? I tried to execute the T.code UJ_VALIDATION in Embedded BPC, however I am not able to find my Environment in Drop down.

Regards,

Ganadhish

[gregor_dieckmann]

Hi Ganadhish,

you can use report SAP_RSADMIN_MAINTAIN to maintain the table RSADMIN.

Regards,

Gregor

[gregor_dieckmann]

Hi Ganadhish,

if this is about new lines then there exists a global setting to check whether new lines exists already in the result set. You can add a record to table RSADMIN with OBJECT = RSPLS_PQ_MODE_FOR_NEW_LINES and VALUE = C.

Regards,

Gregor

[former_member331251]

Hi Gregor,

Thanks for the help. Can you please guide me the steps, how to do this Global setting?

Regards,

Ganadhish

[former_member186338]

May be it's better to use VBA to check before sending?

[Former Member]

Ganadhish,

Please use "Data Validation" option from Formatting sheet in EPM Add-In for such requirement. Apply a warning for user to input only amount in that particular input form.

JP

[former_member331251]

Hi Priyanka,

I have already gone through the link you have provided. Here I have some unique requirement.

When there are 2 records entered in BPC where the characteristic combinations are exactly the same (example below), the standard BPC behavior is to combine both of them.

So in the example above, it will combine the duplicate records as follows:

This is not an issue for forecasting if the input being made is an amount.

However if the input being made is % or rate per stat unit, we would like it should throws out an error. It should not combine the duplicate records. For example, the following examples should reject the input:

Example 1:

Example 2:

Regards,

Ganadhish

[Former Member]

After looking at proper screenshots now.....one question! Can you explain me the business scenario as to why the same account has different inputs??? One in amounts, one in %, one in rate/stat unit input??

[Former Member]

Hi Ganadhish,

Please refer below blog for validations in Embedded BPC...

https://blogs.sap.com/2016/11/24/bpc-10.1-embedded-how-to-validate-your-data/

Regards,

JP