To create a LOV item class:
- 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 the illustration itcwz1l.gif
- Select the List of Values check box.
- Click Next to display the "Item Class Wizard: Step 2".
Figure 9-3 Item Class Wizard: Step 2 dialog
Text description of the illustration itcwzsig.gif - Select the business area that contains the item you want to use to generate the list of values.
- 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".
- 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 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.
- Move the items that use this item class, from the Available items list to the Selected items list.
- 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 the illustration itcwzad4.gif
- Specify the number of values to retrieve in each group, and select other check boxes as required.
- 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 the illustration itcwzn5.gif
No comments:
Post a Comment