BusinessObjects Board

Dynamic visibility in list of prompts

building reports webintelligence
#1

Hi All,

We have a requirement as explained below.

We need to create a report to follow 2 hierarchies.
The first Hierarchy is BU->Profit Center->Brand->SKU
The second Hierarchy is BU->Mini BU->MPG->SKU

For the second Hierarchy the object Material code contains the value for BU, Mini BU etc.
How to achieve this in BO 4.0, if the user selects BU automatically the prompts that appear to the users should be BU->Profit Center->Brand->SKU.

If the user selects “Material Category” the next list of prompts that should appear are “Material Category Value” which will contain the value for the category selected in the “Material Category” and the prompt called “BU” should be disabled.

Can someone explain, how to achieve this?

Regards,
Judith

anithaju (BOB member since 2011-08-23)

#2

These should help get you started:-
https://bobj-board.org/t/146178/9

http://wiki.scn.sap.com/wiki/display/BOBJ/How+to+create+a+cascading+List+of+Values+(LOV)+in+UNX+with+hierarchical+display

Mak 1 :uk: (BOB member since 2005-01-06)