Dependent Lists of Values

[PAULSGS]

Has anyone built lists-of-values that depend upon each other?

I want to present three prompts, with list-of values to pick from. I want the choice made in prompt 1 to limit the choices in prompt 2. Then the choice made in prompt/lov 2 should limit the choice in prompt/lov 3.

I can imagine a way of doing it by using user-reponse to modify the sql in prompts 2 & 3, which would have to be refreshed, but has anybody done this?

 

[blom0344]

Hi Paul,

This is known as the issues with 'cascading' prompts. See :
thread393-239316.
Unfortunately, the thread starter never reacted how he achieved them. I sure like to know too, cause I used them in BO 4.1 and would like to build them again. I think lots of people want to get the answer !!! T. Blom
Information analist
Shimano Europe
tbl@shimano-eu.com

 

[promero]

I suppose cagekumar from Thread393-239316 made cascade prompts using the @Script function and the Ms Forms and Ms ADO libraries of VBA. As he said, that only works in the Full Client, not in Web Intelligence (because of Forms).

 

[PAULSGS]

I've been on to the BO website and there are two ways of doing this. Both are constructed through Designer, neither are particularly elegant, but clever nonetheless.

The first is to modify a list of values to include the objects which make up the hierarchy and the user then picks from a comprehensive list of Parents->Children->Grandchildren....

The second method involves modifying the "child" objects LOVs to include a condition and prompt for the "parent" object's value. For example "Resorts" are children of "Countries", so in the Resort object add a conditon

Country = @prompt('What country')

Then in your main query include the Resort object as a prompted condition and it will automatically call the prompt for Country. The choice you make for country, then limits the display of your choices of resorts in the next prompt. The only downside to this is that the prompting and value input occurs in the same window.

I've got both methods to work, but the BO resolution was made for version 4 and stated that it didn't work for WEBI, and I haven't tried to see whether that limitation still applies.

 

[blom0344]

Thanks Paul,

The last method you described is exactly what I did back when I was working with the first 4 version of BO. It works like it should ,but looks quite funny because the window stays up after you put in the first selection.

Perhaps this subject would be an candidate for a FAQ ? T. Blom
Information analist
Shimano Europe
tbl@shimano-eu.com