Update. This issue does not exist in the 2020 releases
The parameter window in the B1 Dashboards query editor has an issue that prevents us from using parameter names. It gives an error "Object reference not set to an instance of an object" if you try to add/remove characters and move out of the field using the mouse. The workaround is to tab out of the field instead of using the mouse.
We have logged this error to the underlying tech provider.
Comments
7 comments
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.
Hi Bill
What B1UP are you using... In 2020.x release the error should be fully gone
We recently installed the 2020 release and I'm still having the problem.
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
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.
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)
Thank You!
Please sign in to leave a comment.