How to create Display value and Key value lov parameter in BI Publisher Data Model

Sometimes while creating BI reports we get requirement to display List of value as some user understandable values, so that it will be easy for users to run the report by selecting the parameters.

For example if we want to list AR invoices based on customer accounts.

We will not be providing customer account ID in parameter for the user to run the report, since user cant remember the system generated ID's. 

So we can have the below solution: 

Note: Here in the example we will use sample query to fetch the customer account details. Similarly we can do for invoices or any such requirement.

Display account number as display value and internally user cust account id as key value in the main data set.

Below screenshots explains the steps:

 

 Create  a list of value:

 Create  a menu parameter and attach the list of value we created in previous step :

 

 

Create Data Set to fetch customer account details