B1UP Issue - Parameters setup screen in Dashboards module

Follow

Comments

7 comments

  • Avatar
    Bill O'Brien

    Thanks Thomas for the heads up.

    I have been trying to duplicate the Dashboard UF in the Boyum instructional video but encountering the issue you describe.

    Even when I tab out of the field the error still presents itself. I have gone through both of the youtube videos related to Dashboard UFs but fail to find any clue as to why the parameter still won't work.

    Is there any step I need to take that is not shown in the videos? Have you found any other workarounds are required?

    Thanks for what you do.

    0
    Comment actions Permalink
  • Avatar
    Rasmus Jensen

    Hi Bill

    What B1UP are you using... In 2020.x release the error should be fully gone

    0
    Comment actions Permalink
  • Avatar
    Bill O'Brien

    We recently installed the 2020 release and I'm still having the problem.

     

    0
    Comment actions Permalink
  • Avatar
    Rasmus Jensen (Edited )

    I see this article explains it a bit confusing.

    When you do a Parameter it's name should not have a @ in it (that will be added automatically by the system) - The video (https://www.youtube.com/watch?v=xzIvSeR64ew) explains that wrong as that was how it worked in 2017 but changed later (Mentioned in a comment on the video).

    So if it looks like this it works (and do not have the error no matter how you exit the field)

    So basically the first screen in the article was wrong because it had the @ sign ... I've removed it now from the article.

    So if you were using a @ then please remove it. 

    If not please also note that HANA does not support parameters as such (The HANA SQL Language do not properly support them) so if you are using HANA you need to write something like this

    (It basically can't contains the @ in the SQL and it can't have the same name as any of the Columns)

    If still issue then please post a screenshot of how the error is presented to you + What SAP version / Type (MSSQ/HANA) / and Bit-version you use

     

    0
    Comment actions Permalink
  • Avatar
    Bill O'Brien

    We are using 9.3 (9.30.160) PL: 06 64 bit MSSQ

     

    This is the parameter. I used a different name to avoid conflict.

    This is the error message, I set the default for DocKey to a customer.

    Here is the Universal Function:

    Thanks for the help and support.

     

    0
    Comment actions Permalink
  • Avatar
    Rasmus Jensen

    Please in you SQL add a @ in front of "partner"

     

    ...Yes is confusing, but in the SQL the @ should be there but not on the next page where they are defined (unless you use HANA, then it should not be there.... ) It is not something we can change (controlled by the underlying dashboard provider)

    0
    Comment actions Permalink
  • Avatar
    Bill O'Brien

    Thank You!

    0
    Comment actions Permalink

Please sign in to leave a comment.