Skip to Content
avatar image
Former Member

Prevent user to input wrong value in AOffice

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Nov 03, 2017 at 10:46 AM

    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/

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 07, 2017 at 03:56 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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