Add Lexical Parameter in Data Model

The following are the steps to add lexical parameter in the data model:

1. Edit the data set G_Case. Add Lexical Parameter &gl_orderby, as declared in the package.

   See Also:

   Lexical Parameters

   
2. When Lexical Parameters are added for the first time in the Data Model, Oracle Analytics Publisher will ask for lexical references in SQL that is, Default Value for the Lexical Parameter.
   
3. Create a List of Values, Order By as shown below:
   
4. Create the parameter pi_orderby in the Data Model and assign the LOV-OrderBy as shown below:
   
5. View the Report by selecting the parameter OrderBy.
6. Execute the Report and verify that data is in order by Case ID as per the selected option. You can find that the XML value of pi_orderby is '2'. In the package pi_orderby value '2' means Order By case_id.

   See Also:

   Lexical Parameters

   
7. Check the case data for the order of cases by case_id: 10031420 and 10031421 in figure shown below:
   
8. Now, select the Order By case_num option in the Data Model.
   
9. Verify the case data for order of cases by case_num: 10031420 and 10031424, in the figure shown below: