How to show Parameter along with its description but link data set with only parameter in Fusion

 Hi

In this post let us see how to link parameters and BIP report data set when we want to show both field and description in parameter but in data set only field is present.

Go to your datamodel and edit LOV

Sample Query: Select field||'-'||description, field from table1

This query shows the corresponding field along with description in parameter selection part but internally it returns field to the data set.

Example: P_Item: select item_number||'-'||item_description, item_number from items_table

How it is shown in parameters

Item Number : Item1-Test Item

Internally value passed will be "Item1"

Hope this helps...