Dashboard - Data Source: UF SQL

Answered

Bijan Adatia

• January 14, 2022 01:16

Is there a way to use a UF (Type: SQL Report) as the data source for Dashboards? 

 

The use-case is that we use the query in different places, and only want to maintain it once. 

Vote

1

• 

  Sean Archer - Business Evolution

  • January 14, 2022 01:20

  You could put the SQL logic in a stored procedure and call that in both the report and dashboard.
• 

  SSP Automation

  • January 14, 2022 01:30

  Thank you for your request. It has been scheduled for review by the development team that will get back to you should there be questions.
  (Please note that as we are user-driven we can't guarantee that your request will be met unless it gets many votes and/or fit the product vision)
  Read more about the Feature Request process here
  [Internal Id: 69437]
  
• 

  Bijan Adatia

  • January 14, 2022 01:32

  Hi Sean,

   

  Thanks for the quick response. I thought of this as well. When calling the SP, I could simply do 

  SELECT

  T0."CardCode",
  T0."CardName"

  FROM

  SP_NAME T0

   

   

  Would that work directly? Because we want to be able to use the Formats when displaying the SQL Report. 
• 

  Sean Archer - Business Evolution

  • January 14, 2022 01:52

  Hi Bijan,

  The screenshot below uses a stored procedure to return the data.  You can add formatting to the returned columns.  If you need different columns in the UF that you do in the dashboard then you could use a view instead of a stored procedure.

  
• 

  Bijan Adatia

  • January 14, 2022 02:34

  Ah! It's the harder way .... That's okay too. 

  And, in HANA-land it would be: 

  CALL "BEGL_DASHBOARD_GetAPDeatils();

  or something similar, right? 

   

   

  Off to create an SP in HANA~ Thank you!!! 
• 

  Rasmus Jensen

  • January 14, 2022 07:35

  Hi Bijan

  Thank you for the suggestion. It is not something currently in the product (a repository of SQL Sentences) so I would properly go with SQL Views myself (gives best flexibility IMHO)
• 

  Bijan Adatia

  • January 14, 2022 17:07

  Hi Rasmus, 

   

  Thank you for the comment. A view was my go to as well, but I can't use a View as a data source for a dashboard, only SPs, right? 
• 

  Simon Simms

  • January 14, 2022 20:50

  Bijan,
  you can use a view in the same way as you use a select statement in the dashboard.

  Select * from [VIEW]
• 

  Bijan Adatia

  • January 14, 2022 20:52

  Ah yes! That is right. And same would be true for the UF, and it would be more manageable, and I prefer views when they're not functional in nature. 

   

  Thanks for the great advice everyone!! 

Please sign in to leave a comment.