Skip to Content
author's profile photo Former Member
Former Member

How can I execute Universe queries dynamically in Dashboards 4.1?

Hi all,

I am building an application using Dashboards 4.1; up until now I have been connecting via a UNX file to the back-end (SQL Server Database) using Query Browser.

Depending on different actions by the user, I would like to run different queries against the database. For example, I have one query that returns amounts by volume (cubic metres), another by mass (KG). It is better for performance to use simple queries like this.

I am having some difficulty working out how to tell Query Browser to execute one query, and not the other, depending on the unit of measure selected. Note that the dashboards must be refreshed whenever the user selects a dimensional value (location, date range, etc.) - that's the real difficulty.

Could anyone point me in the direction of a design pattern or some examples that might help me out?

Thanks in advance.

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jan 28, 2014 at 01:54 AM

    You can achieve this easily by using a trigger cell for your query browser queries and then having your components insert the desired value based on user selection into the designated cells..

    search for for trigger cells in Scn and you will get many blogs explaining them in details..

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thanks Durgamadhab.

      I understand about the use of trigger cells, although I will search SCN again as you suggest.

      The problem is that the triggering conditions are quite complex.

      Say I have query A and query B. Query A only is run when the user selects KG as unit of measure (UOM), Query 2 when cubic metres are chosen. That is easy to implement. However, Query A and B are also run when the user selects a new location. So the full conditions are:

      Query A: run when UOM is first picked as KG or (a new location is picked and UOM is already KG)

      Query B: run when UOM is first picked as cubic metres or (a new location is picked and UOM is already cubic metres)

      Maybe I'm missing something obvious, but I'm finding it a struggle to write formulas to capture this logic.

  • Posted on Jan 28, 2014 at 06:44 PM

    You should be able to use excel formula to perform the logic

    use the result of the formula i A6 to trigger the query

    I am assuming that you can get the location and the UOM back as part of the query result. You can then compare the last retrieved values with the values from the selector objects in the dashboard.

    If the currently selected UOM and selected location are the same as those retrieved by the last query result do nothing, If either the selected location or the selected uom is different from the last query result run either query A or query B depending upon the UOM in the selector

    hope this helps


    SCN Solution.JPG (47.0 kB)
    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.