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
Country (Object 1)
If User 90012 has selected USA on report, then he should see zones only under USA.
Please let us know how to implement this.