Dynamic Cascading prompt in Webi

[Former Member]

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

[Former Member · Accepted solution]

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.

[Former Member]

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

[Former Member]

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.

[Former Member]

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