Saturday 15 September 2012

Oracle Discoverer to create a LOV item class

To create a LOV item class:

  1. Choose Insert | Item Class to display the "Item Class Wizard dialog".

    If Discoverer displays the "Item Class Wizard: Step 2" press the

    Figure 9-2 The Item Class Wizard dialog


    Text description of itcwz1l.gif follows.
    Text description of the illustration itcwz1l.gif

  1. Select the List of Values check box.

  2. Click Next to display the "Item Class Wizard: Step 2".

    Figure 9-3 Item Class Wizard: Step 2 dialog


    Text description of itcwzsig.gif follows.
    Text description of the illustration itcwzsig.gif
  3. Select the business area that contains the item you want to use to generate the list of values.

  4. Select the item that you want to use to generate the list of values.

Note: By default, Discoverer uses a SELECT DISTINCT query to retrieve a list of values. If you select an item in a folder with a large number of rows compared to the number of distinct values, then the query can be inefficient. It is more efficient to select an item from a smaller table (attached to the folder with a large number of rows) rather than using the large table itself. If a smaller table does not exist, it might be worth creating it to speed up the list of values process.

Alternatively if you have a small number of values, use a custom folder to create a local list of values within the End User Layer. For more information, see "How to create a list of values using a custom folder".

  1. Click Next to display the "Item Class Wizard: Step 3" to select the items that use this item class.

    Figure 9-4 Item Class Wizard: Step 3 dialog


    Text description of itcwzsil.gif follows.
    Text description of the illustration itcwzsil.gif

Note: If you had also selected the Drill to detail check box on the first page of the Item Class Wizard, end users will be able to drill between any of the items that you select on this page.

  1. Move the items that use this item class, from the Available items list to the Selected items list.

  2. Click Next to display the "Item Class Wizard: Step 4" to specify options controlling how LOVs are selected and displayed in Discoverer Plus.

    Figure 9-5 Item Class Wizard: Step 4 dialog


    Text description of itcwzad4.gif follows.
    Text description of the illustration itcwzad4.gif

  1. Specify the number of values to retrieve in each group, and select other check boxes as required.

  2. Click Next to display the "Item Class Wizard: Step 5" dialog and specify a name and description for the new item class.

    Figure 9-6 Item Class Wizard: Step 5 dialog


    Text description of itcwzn5.gif follows.
    Text description of the illustration itcwzn5.gif

  1. Enter a name and description for your new item class.

  2. Click Finish.

    Discoverer creates a new List of Values item class.

No comments:

Post a Comment