Skip to Content
0
Former Member
Sep 23, 2013 at 02:39 PM

Cascading LOV Webi Xi3.1 - overridden SQL for LOV for top level

15 Views

Hi,

We have a requirement to implement cascading prompts and filter the list of values at top level.

Example: I have a hierarchy like Object 1 at top level and Object 2 and Object 3 (same level) below level 1.

Object 1 has an overridden LOV because of user security implemented like User AB can see only USA and Canada. Hence, I cannot create cascading LOV in Universe because it does not take overridden LOV. Tried creating custom hierarchy on these three objects and setting cascading LOV but overridden LOV does not work.

Object 1 comes from table Country and Object 2 and Object 3 come from table Zone.

User Security Table

User id

Country (Object 1)

Role

90012

USA

Distributor

90012

Canada

Distributor

90457

USA

Distributor

If User 90012 has selected USA on report, then he should see zones only under USA.

Please let us know how to implement this.

  1. Thanks.