Custom LOV or How to selct a Employe and their Dept is passed into a prompt

[Former Member]

I have been given a change request to enhance an existing Webi report built over a universe with a BEx query as the source.

Currently they are prompted to enter an "employee name" but they now want to select the employee name but the result set to come back for the complete data set for they department they work in. For example select Andrew and the data for all employees in the consulting dept to be returned.

In old school BOBJ a work around was to put the prompt on the department name and amend the LOV to show 2 columns, Dept Name and Employee Name. So the users would scan down the list of employees ( column 2 in the LOV) and select them which would in fact select the department name and pass that back to the query to restrict the data set.

Is there any work around or thought you can suggest to help out in the new world of a universe over BEx ?

[MariannevL · Accepted solution]

Hi,

Sound like something that is easier implemented in the BEX query with a user exit variable.

Ask your BW developers if you want to know more...

Another option is to (ab)use the hierarchical display of prompts;

create an LOV object for department with a built in (XMLfilter) condition on employee (use the normal employee LOV).

set the LOV to use hierachical display.

create a custom (XML) filter for department and point to the LOV for this prompt to the new LOV object for department.

(hide the LOV object from the end-user...)

What that should give you is a list of employees with a plus sign in front.

Clicking on the plus will show the department.

This they can select...

Hope this helps,

Marianne