Skip to Content

UJ_VALIDATION in EMBEDDED BPC

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

6 Answers

  • avatar image
    Former Member
    Mar 06, 2017 at 06:39 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 06, 2017 at 07:00 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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??

  • avatar image
    Former Member
    Mar 06, 2017 at 07:14 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 06, 2017 at 07:44 AM

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

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 06, 2017 at 08:43 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 07, 2017 at 01:37 PM

    Hi Ganadhish,

    you can use report SAP_RSADMIN_MAINTAIN to maintain the table RSADMIN.

    Regards,

    Gregor

    Add comment
    10|10000 characters needed characters exceeded