Query returns values but when passed as a pram trucates other prams in OTBI PPM custom report.
Summary:
Query returns values but when passed as a parameter trucates others in OTBI PPM custom report.
Content (please ensure you mask any confidential information):
We have developed a custom OTBI report for PPM Projects with the following parameter:
- Project Country
- Project Type (this is the pram that truncates the others)
- Project Status
- *Project Number
- Currency
- Exchange Rate Year
Project Type Query:
SELECT PT.DESCRIPTION D , PT.PROJECT_TYPE_ID R FROM PJF_PROJECT_TYPES_VL PT ORDER BY PT.DESCRIPTION
When we run the query in a dataset, we receive a list of values.
When we use the query as a LOV parameter, we are unable to select the LOV, evenmore, if there are other parameters we have the same escenario for the others.
0