Skip to Content
0

Prevent user to input wrong value in AOffice

Nov 03, 2017 at 10:25 AM

75

avatar image
Former Member

Dear All,

I'm new using Analysis for Office. Currently we are using the latest version 2.5 to create some manual data.

We have some problem when user input the wrong value in the selection screen. The location should be SG, but user didn't use the help F4 and directly type SINGAPORE instead of SG. Actually after user execute the selection screen, there is warning said that SINGAPORE doesn't exist in the master data, user ignored it and save the data. Now we have SG and SINGAPORE.

My question is there anyway to prevent user, so they only input the value based on master data that we have?

Thanks,
Harry

error.png (16.4 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Tammy Powlas
Nov 03, 2017 at 10:46 AM
0

Harry - I wonder if this is something that can be handled in the backend, as it sounds like in this blog BPC wouldn't allow this type of entry error - see https://blogs.sap.com/2016/11/24/bpc-10.1-embedded-how-to-validate-your-data/

Share
10 |10000 characters needed characters left characters exceeded
Gregor Dieckmann
Nov 07, 2017 at 03:56 PM
0

Hi,

the characteristic 'Location' should have a master data table, then the variable screen checks the values against the master data table. The system might create a new SID for not yet existing master data values entered in the variable screen but not new master data values; configure the F4 help to return only master data values.

Regards,

Gregor

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

Thanks Gregor for your reply,

I tried to configure our query, but still got the same result.

Is it the correct configuration?

Regards,

Harry

0

Hi Harry,

the setting in the screen shot has nothing to do with the effect. Check your characteristic in RSD1 and find out whether the flag 'With Master Data' is used on the third tab 'Master Data/Texts'.

Regards,

Gregor

0