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

Dynamic Prompt in Dashboard?

Hello,

I've opened a post here, and referring to that post, I know that we can have dynamic prompt in JOIN/CROSSTAB (I know we usually put the prompt in WHERE statement) in IDT, but when I create dashboard by using Query Browser, I can't get the prompt. The prompt only exist in the query itself (q1.png). How can I have the prompt out of query window, I mean how can I trigger the use of Query Prompt Selector (q3.png) (if no object is not under the query filter panel as shown in q2i.png)?

I hope that someone can understand my explanation... Sorry for the poor explanation. I don't know how to explain well.

Thank you.

Regards,

amano

q3.png (10.3 kB)
q2i.png (49.8 kB)
q1.png (45.3 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Sep 24, 2013 at 10:19 AM

    Hi Amano

    Give the prompt as optional prompt in query.

    Now put a query prompt selector in dashboard whose source prompt is our prompt in query and destination prompt also our prompt in query. The drop down in query prompt selector's properties will catch the prompts in all queries used. You have to select from that.

    Regards

    Sandeep

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Runali,

      Thanks. It works. Just in case, the correction will be as following:-

      SELECT lecID, lecName, [F] AS Female, [M] AS Male

      FROM

      (SELECT l.lecID, l.lecName, s.gender, s.studName

      FROM "tblLecturer" l LEFT JOIN "tblStudent" s ON l.lecID = s.lecID) p

      PIVOT

      (COUNT(studName)

      FOR gender IN ([F], [M])

      ) AS PVT

      WHERE lecID = 'L05'

      Thank you so much.

      Regards,

      amano

  • author's profile photo Former Member
    Former Member
    Posted on Sep 24, 2013 at 05:09 PM

    Hi Amano

    In the IDT - have you set the Prompt to directly apply to the class/object its part of? If so, it applies the prompt to the query but doesn't appear in the Query panel filter area.

    Can you please post the definition of your prompt from IDT?

    Runali

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 26, 2013 at 07:56 AM

    HI Amano,

    Prompt in query will not appear in prompts tab of query browser in dashboard.

    If you are using prompt at filter level then only it will display the prompt in prompts tab .. to map it further in excel cells.

    Hence make sure that you don't have any prompt in query....

    Hope this is helpful...

    Regards

    Subbarao M

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Subbarao M,

      This is sad... *sighs*

      Does this mean that the query following cannot be done by having query prompt and I can only change the query in order the get the desired results?

      SELECT lecName, [F] AS Female, [M] AS Male

      FROM

      (SELECT l.lecName, s.gender, s.studName

      FROM "tblLecturer" l LEFT JOIN "tblStudent" s ON l.lecID = @Prompt('LecID:', 'A',,,,)) p

      PIVOT

      (COUNT(studName)

      FOR gender IN ([F], [M])

      ) AS PVT

      Regards,

      amano

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.