Fusion BIP : How to show one parameter in report and pass different value to the datamodel

Hi All,

There can be a scenario where we might need to show one value in the report and a different value to the actual query. Lets say a person_name to the user and person_id to the underlying data model.

Here the query builder for the parameter shows only single query field :
==>

So in this case we can write the query as below

select A , B from dual;

Here  the field A will be shown to the user and the field B would be passed to the data model.


Thanks,
Srikanth