Cascading Filters in Business Objects Universe /Reports

[Former Member]

Hi

I am trying to define cascading filters for a Universe to be used in a BO Report.

I am very new to BO and still trying out things.

My requirement.

Mail Class: MainReport

Picklist Class1: Region-Country

Picklist Class2: Person-age

Join:

Main Class:: Picklist Class1   - RegionName to RegionName AND CountryName to CountryName

Main Class:: Picklist Class2   - Person to Person AND Age to Age

For the BO Report , i will want to have filters for Region

- User has option to select by selected Region(s) [If none selected all regions should be selected]

  Based on Region selected , the respective country list should show up in list for selection.

- User has option to select by selected Age(s) [If none selected all  should be selected]

  Based on Age selected , the respective person(s) list should show up in list for selection.

Thanks

[TammyPowlas]

Former Member

This is the Design Studio space.  Right now it does not support universes, so this is not the right space.  It might help if you state what tool you are using.

I will move this to the Semantic Layer space.

Tammy (Moderator)

[Former Member]

Thanks Tammy,

I am using Business Objects Designer for the Universes. And will be creating reports via Webi.

[former_member262009]

Hi,

You can achieve this in

1. By creating Cascading LOV.

Goto Tools -> List of Values - > Create Cascading List of Values

2. Create @prompt() based on region and country and assign it as query filter for LOV of age object.

Thanks

-Nanda