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.
Create a List of Values, Order By as shown below:
Create the parameter pi_orderby in the Data Model and assign the LOV-OrderBy as shown below:
View the Report by selecting the parameter OrderBy.
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.