BusinessObjects Board

Cascading LOV with -ALL- in BOXIr2

building semantic layer
#1

Has anybody created cascading LOV with option -ALL- in Designer XIr2 and can elaborate on this a little bit?

Marfi :poland: (BOB member since 2006-12-18)

cascade prompt
#2

Yes, I did it and showed a demo at the user conference last fall. You can download the presentation slides and see the logic that I used from the Integra presentations page here:

http://www.integrasolutions.net/library_presentations.htm

This was covered in Part II of “Tales of a Universe Ninja” :smiley:

The universe and other materials are not available for download as my virtual machine doesn’t have the Import Wizard on it, therefore I have not been able to create a BIAR file yet. It’s on the “to do” list. But the presentation slides show the logic and plenty of screen shots.

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

#3

Hi Dave , correct me if Im wrong but according to your doc each subsequent level should have previous levels attached to it, right?
So if I got 4 levels and each of them has very long name my tree will be huge

lvl1 -- lvl1>lvl2 -- lvl1>lvl2>lvl3 -- lvl1>lvl2>lvl3 -- lvl1>lvl2>lvl3>lvl4
       |                 |                        |                       |
       |                 |                        |                        -- lvl1>lvl2>lvl3>lvl4 
       |                 |                        |
       |                 |                        -- lvl1>lvl2>lvl3 -- lvl1>lvl2>lvl3>lvl4
       |                 |                        
       |                 | 
       |                 -- lvl1>lvl2>lvl3 -- lvl1>lvl2>lvl3 -- lvl1>lvl2>lvl3>lvl4
       |
        -- lvl1>lvl2 -- lvl1>lvl2>lvl3 -- lvl1>lvl2>lvl3 -- lvl1>lvl2>lvl3>lvl4

Im afraid users will not like it. This is the drawback that the last selection has to be unique. Is there any solution for that, like for example in Crystal you can display just description and hide the code?

Marfi :poland: (BOB member since 2006-12-18)

#4

I am sorry my schema has moved a little bit but I hope it still conveys the idea

Marfi :poland: (BOB member since 2006-12-18)

#5

Yes, in my scenario every level adds (concatenates) the prior level selections. It’s not pretty, but it does work.

There are several challenges with using ALL in a cascading LOV, the main one is passing the ALL through to the final level since you cannot stop in the middle of a cascading LOV… you have to continue to the final selectable value.

I added the “code” formatting to your prior post; it seems to help convey the idea you were trying to use. :slight_smile:

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