cascading prompt

building semantic layer
1

Hi all ,

I have created cascading prompt for 4 levels
1.Therapist
2.Study
3.Region
4.Country

When I am applying prompt on 4.Country in report level , LOV’s are refreshing fine .

But result objects are giving more data except selected country prompt .

I tried with applying prompts on remaining fields with same prompt message(1.Therapist, 2. Study and 3. Region ) . With that when I ran report , report is giving more prompt messages .

Can some one please let me know how to get only selected prompt values in result ( on level 4. Country)

Thanks in advance

patriot3029 :india: (BOB member since 2006-12-08)

2

Only the lowest level of the cascading prompt is going to appear in the “where” clause of the SQL, and therefore the remaining levels are only useful to restrict the values showing in the LOV. I explained this in more detail in this topic not long ago.

Dave Rathbun :us: (BOB member since 2002-06-06)

3

Dave Thanks for you quick reply .

So we dont have any other way to restict data for Cascading prompt .

I mean any work around or any other solution .

Thanks in advance

patriot3029 :india: (BOB member since 2006-12-08)

4

Dave is it same behavior with Crystal Reports also ??

patriot3029 :india: (BOB member since 2006-12-08)

5

With Crystal you can access the intermediate prompts and apply them as conditions.

With Web Intelligence what I have done in the past is to create concatenated objects to base the LOV from. More details in this topic.

Dave Rathbun :us: (BOB member since 2002-06-06)