Dashboard DateTime Parameter

Respondida

Bo Peng

• 12 de octubre de 2020 19:44

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 ? 

Vote

0

• 

  Rasmus Jensen

  • 13 de octubre de 2020 06:06

  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
• 

  Bo Peng

  • 3 de noviembre de 2020 13:09

  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
• 

  Rasmus Jensen

  • 3 de noviembre de 2020 13:19

  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
• 

  Bo Peng

  • 3 de noviembre de 2020 13:22

  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? 

  
• 

  Rasmus Jensen

  • 3 de noviembre de 2020 13:46

  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 :-(
• 

  Bo Peng

  • 3 de noviembre de 2020 14:07

  Thanks, Rasmus. Please let us know. In the meantime we will continue with the string parameter just to push this function through. 
• 

  Edward Bentley

  • 18 de agosto de 2021 17:32

  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
• 

  Rasmus Jensen

  • 19 de agosto de 2021 09:34

  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 :-)

Iniciar sesión para dejar un comentario.