LOVs in Discoverer Reports

LOVs in Discoverer Reports


We can create list of values (LOV) for any parameter in discoverer reports through Item Classes. Here suppose in Discoverer Report, we have a parameter called Period Name. It has a small LOV icon in the right side.

When clicked on the LOV icon, the below window with all the Period Names will appear where you can choose one or many period names.

Now the question is how to do this. You just need to do the below steps to accomplish this task.

1] Create a custom folder named ‘Time Periods’ in a business area with the below query.

select  distinct
        decode(period_num,1, 'January',
                          2, 'February',
                          3, 'March',
                          4, 'April',
                          5, 'May',
                          6, 'June',
                          7, 'July',
                          8, 'August',
                          9, 'September',
                          10, 'October',
                          11, 'November',
                          12, 'December', null) month_name
from gl_periods;

2] Select the business area in which you want to create an item class. Choose Insert > Item Class.

3] Select the LOV Item class attribute.


4] Select the above created folder (Time Periods) and choose the Period Name column.


5] Here you can select the various items of other folders that can use this item class. You can skip this stage and later you can manually assign this item class to other items.


6] Choose the defaults and click next.


7] Give a suitable name to the Item Class


8] Now go to the Item of the folder on which you created the Parameter (Period Name) and then go to Item Properties. Here you assign the item class that you have created just now.


9] If you already created the parameter in your workbook and your discover plus or desktop is open then close it and reopen. Then you can view the LOV attached to the parameter.

10] If you haven’t already created the parameter, then create the parameter and run the report. You can view the LOV attached to the parameter.

2 Responses to LOVs in Discoverer Reports

  1. Hari says:

    You are doing a great job,Very much impressed with your Articles as they are very easy to understand.

    Appreciate your work.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: