Dashboard DateTime Parameter Answered
Hello Experts:
Trying to use Date as parameter in the dashboard. Customer is on 2019.06 B1UP (HANA)
1. Setup Parameter as Date
2. Setup up Query:
select "CardCode", "CardName", "DocTotal", "DocDate", "DocDueDate"
from ODLN where "DocDate" > @Parameter1
3. Setup Parameter
Keep on getting error message ?
Comments
8 comments
Hi Bo
I've moved this post from Feature request to Community Question and Answer section as it is not a feature request
regarding parameters please see this video that explains how they work: https://youtu.be/4MEG6RxYszc
Hello Rasmus:
Thank you, I have view the youtube video and went through several post. But I am still not unable to make a date format parameter to work in the dashboard. I can convert them to string and it work. But using date type as parameter, set the date type in query (even taking out "@", because this is Hana) Still give me the out of range of valid value error.
I also tried to convert TO_TIMESTAMP and TO_DATE, in query it works with static date, but as soon as I plug-in the parameter it fails, not with conversion failure message. So I assume it is something I did wrong.
Thank you for the help
Bo
Please try and have your date in the yyyy-MM-dd format... That is the format SAP uses... In general dates are normally give as string-input when provided by user
Hello Rasmus:
When I set parameter as date type, the format it give is always MM/DD/YYYY. But this is boyum dashboard's given form, is it something controlled by localization in SBO configuration?
Hmm, just tried and it seems yet again that HANA is not intelligent enough to do this :-/ Works 100% in MSSQL... The underlying technology of Dashboards officially does not support HANA so the support is added via a Hack... But it seems Date as Parameters can't be handled by this hack... I will try and see if we can get it working but I'm not too optimistic :-(
Thanks, Rasmus. Please let us know. In the meantime we will continue with the string parameter just to push this function through.
Hi Rasmus
Has there been any improvement around date parameters on a dashboard when on SAP HANA?
Ideally I want the client to be able to enter a from and to date range on a dashboard.
Thanks
Ed
Hi Edward
I checked it out today and the HANA part has not become smarter :-( ... but I did manage to find a workaround for it in code instead so from B1UP 2021.09 version it should be possible :-)
Please sign in to leave a comment.