reference based on variable selection

[Anubhav Srivas1]

Hello,

i have a catalogue which needs data based on variable selection. The data is present in a table and the relationship is required based on data that is present in the table.

can you please help me doing this , attaching screenshot for reference.

when business unit l1 is selected based on that business unit l2 options are required, then based on business unit l2 is selected application access profile options are required and then reporting access profile and based on that access level.

[Brad Bowman]

It's hard to be certain without seeing/knowing the relationships and variable types, which table(s), etc., but on the Business Unit L2 variable, if this a reference type variable referencing a table that holds the relationships, try a qualifier like this:

using the field_name in this table that would contain the l1 value, and your l1 variable name.  If the relationship is more complex or spans tables, then your qualifier would call a function in a Script Include, passing in the l1 value, something like this: