Skip to Content

Help with SELECT Statement in Script Logic (SAP BPC 10.1 Standard)

Hi,

Need guidance regarding usage of SELECT Statement in script logic. I am trying to dynamically pick up ID from a DIMENSION using the below statement:

*SELECT(%XYZ%,XYZ,VERSION,ID = USER%USER%)

Objective is to pass the XYZ property value of VERSION Dimension for ID equal to USER12345, if the user id of the executer is 12345. But ID = USER%USER% is not working. Can anybody advise what is wrong and what needs to be done with the statement as correction?

Thanks and Regards,

Swakshar

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Feb 28 at 01:20 PM

    Can anyone help with the correct concatenation logic for the string "USER" with user id of the executor?

    Regards,

    Swakshar

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 28 at 03:19 PM

    Please read: https://blogs.sap.com/2014/01/31/how-to-ask-questions-about-script-logic-issues/

    Provide real script with test result in UJKT!

    Now it's not possible to answer this question because you are not providing full info.

    Add comment
    10|10000 characters needed characters exceeded

    • Vadim Kalinin Swakshar Choudhury

      Absolutely not clear!

      "I have given a prompt to the user to input the user version" - what do you mean? Can you show advanced DM script?

      How the user version is related to user name?

      If you want help you need to provide detailed info!