Problem with cascading prompt

[system]

Hi,

FAQ: Designer

How do I create cascading or nested prompts? Author: Robert Metzker Let’s create a Series of Cascading Prompts for the Island Resort Marketing Universe. We’ll simply work our way through the Resort class for a quick example. All of the prompts will be fairly similar, and I am going under the assumption that everyone has some Designer Experience. Let’s start at the Highest Level that we’d need a prompt for. That would be the Resort itself, since we need to know what Resorts we’re int…

– In this URL - Example of a cascading prompt is explained. The example hierarchy is - Multilevel hierarchy.
Country
|
Resort
|
Service Line

I need to implement a different hierarchy.
I have a prompt: Select the Time Unit: Month/Quarter/Year
If user selects Month - Another prompt should come with all the Months.
hierarchy:
Time Unit
/ |
Month Qtr Year

Please suggest , How i’ll proceed with this.

Thanks

---

mithranclt (BOB member since 2008-10-14)

[system]

Hi,

To implement the required logic, first you should have following objects created in universe-

1. <Month_Obj> (to get list of months)
2. <Qtr_Obj> (to get list of quarters)
3. <Year_Obj> (to get list of years)

Now, create one more object (e.g <Prompt_Object>) with following definition-

case when @Prompt(‘Prompt Type’,‘A’,{‘Month’,‘Quarter’,‘Year’},mono,constrained) = ‘Month’ then @Select(Class_Name\Month_Obj) when @Prompt(‘Prompt Type’,‘A’,{‘Month’,‘Quarter’,‘Year’},mono,constrained) = ‘Quarter’ then @Select(Class_Name\Qtr_Obj) when @Prompt(‘Prompt Type’,‘A’,{‘Month’,‘Quarter’,‘Year’},mono,constrained) = ‘Year’ then @Select(Class_Name\Year_Obj) end

After that, create one condition (Prompt) based on above object

@Select(Class_Name\Prompt_Object) IN @Prompt(‘Select Values from List’,‘A’,‘Class_Name\Prompt_Object’,multi,constrained)

If you use this prompt in the report, you should get expected results.

Hope this helps.

---

soni_ak (BOB member since 2008-09-15)

[system]

Thanks a lot!! This really helps!! Thanks.

I just created the objects and condition as you suggested.

Then I just put the <Prompt_Object> in the Query Panel of Desktop Intelligence and put that in the Where clause and Ran it.

Then following prompts came in one window
Prompt Type:
Select Values from List:

I just want first prompt - “Prompt Type:” - in first window. Is that possible?

Thanks again!

---

mithranclt (BOB member since 2008-10-14)

[system]

Hi,

I think it may not be possible in the given code, it will show two prompt windows only.

---

soni_ak (BOB member since 2008-09-15)