Skip to Content
avatar image
Former Member

Dynamic Cascading prompt in Webi

Is there a way either at Webi/Universe level to create dynamic cascading prompt in webi based on selection from first filter object.

e.g. two objects, Region and Office.

In webi, Region is the first filter, Office is the second.

After user selects a Region, I want the second Office prompt values to display only the offices for the region that user's selected.

Is there is a way to do? or a work round?

If I just create cascading LOV, it will just display all regions and it's offices together.

Thanks

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Former Member
    Apr 19, 2011 at 02:48 AM

    Hi Rona,

    If you create a cascading LOV, you will get a tree structure, so when a Region node is expanded, only the offices in that region will show. Is this not what you see when you create a cascading LOV?

    Otherwise I don't think this is possible with prompts

    One potential option: you can schedule your webi report to run overnight, then allow your users to filter using simple filters, which will be dynamic, provided that region and office are in a hierarchy. Of course this is only a solution if you don't need to-the-minute data, or row level security, and have less than a million or so rows.

    Hope that helps.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 19, 2011 at 05:09 AM

    You try the below

    Go to the Office Property.

    • Edit the List of Values for the Office object.

    • Check the Automatic Refresh Before Use option.

    • Click Edit.

    • Bring Region into the Conditions and set it to: in list Prompt('What Region?')

    • Click Save and Close

    • Click Apply and edit the next LOV object.

    Save this Universe and let's generate a report.

    Now in the report you create the Prompt on Region. Prompt('What Region?')

    Have a look in to

    http://homepage.mac.com/rmetzk/PDF_Files/Cascading_Prompts.pdf

    Hope this may help you out.

    Edited by: srrachna on Apr 19, 2011 7:26 AM

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 19, 2011 at 09:15 AM

    Hi Rona,

    I believe that you should investigate how to create nested prompts in your corresponding universe. In other words define the LOV (List of Values) for Offices as a query filtered by a prompt on region, so that every time you integrate in a WebI query a filter on Offices, your user will be required to enter a value for region to view the corresponding LOV (for Offices).

    This has to be defined in the universe, with Designer.

    Hope that helps,

    David.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 12, 2016 at 01:49 PM

    Hi David,

    I have a scenario where dates need to be specified in the prompts. for everyday it needs to be changed to the current day. I am new to this options. When i schedule the reports, it takes the last selected values. I need to report to take values dynamically everyday. I need to report to be scheduled with dynamic prompts, so that it takes the prompts value from the system date and run the report regularly. Is there a way to do it? if so, can you explain me how it can be done?

    Prompts i have used in my query is pasted below,

    t418.trdt BETWEEN  @prompt('Start Date:','D',,Mono,Free,Persistent,,User:2)  AND  @prompt('End Date:','D',,Mono,Free,Persistent,,User:3)

    I dont have access to universes. I need to get this done by report level. Please advice

    Regards,

    Karthik

    Add comment
    10|10000 characters needed characters exceeded