Skip to Content
0

UJ_VALIDATION in EMBEDDED BPC

Mar 06, 2017 at 06:00 AM

194

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

6 Answers

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

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

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Mar 06, 2017 at 07:00 AM
0

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


capture1.jpg (37.6 kB)
capture2.jpg (21.4 kB)
capture1.jpg (37.6 kB)
capture1.jpg (24.4 kB)
capture2.jpg (21.4 kB)
capture3.jpg (26.6 kB)
capture4.jpg (30.2 kB)
Show 1 Share
10 |10000 characters needed characters left 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??

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

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

Share
10 |10000 characters needed characters left characters exceeded
Vadim Kalinin Mar 06, 2017 at 07:44 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Gregor Dieckmann
Mar 06, 2017 at 08:43 AM
0

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

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi Gregor,

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

Regards,

Ganadhish

0
Gregor Dieckmann
Mar 07, 2017 at 01:37 PM
0

Hi Ganadhish,

you can use report SAP_RSADMIN_MAINTAIN to maintain the table RSADMIN.

Regards,

Gregor

Share
10 |10000 characters needed characters left characters exceeded