cancel
Showing results for 
Search instead for 
Did you mean: 

How to make use of a static or dynamic LOV in Desktop Instelligence reports

Former Member
0 Kudos

I want to use static LOV as well as dynamic LOV as a prompt for one of my report.

I have created a dynamic LOV but I dont know how to include it as a prompt to my reports. Please teach me the same.

For example I have two classes called COMPANY and EMPLOYEE in my universe. Each entry in the company class will have n number of employees in the employee class. My requirement is when I run the report it should prompt the user to select the company name which is a object in the COMPANY class. Based on the users's input the report should pull the employee data.

For this I have to create a COMPANY name LOV and this should be used in the 'Conditions' section of the Desktop Intellegence.

Please guide me for the same.

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

LEt me know where u need the prompt object to be created in UNV or in report level.

In Unv:

Select Company name object-> double click it and in Select clause define as below

@variable('1. Enter Company Name'')

In Report level: Go to Query panel select Company class object in where clause and select required operator as LIKE OR IN LIST OR NOT IN LIST OR DIFFERENT FROM and select prompt and give some prompt message.

Cheers,

Suresh Aluri.