Load Data from Oracle BI Publisher into Fusion Analytics Warehouse

Question

Hi Team

We have enabled the Load Data from Oracle BI Publisher into Fusion Analytics Warehouse preview functionality and we are trying to pass the report parameter (Report Configuration) but getting fallowing error, Can you please help us on the same if you have faced similar issue.

Please find the below screenshot.

Error Message:

=======================================

Report parameters, along with its respective values, is missing for the Organization-Review-Report report in BIP connection properties. Please provide these details in the "Report Config Parameters" field in connection properties and retry.

Thanks in advance.

RanaAshutosh-Oracle · Answer

Reports with parameters need to define the parameter values in Report Configuration connection property. The parameter name and value need to be provided in a JSON format. Please check below sample json syntax expected:

[

{

"reportPath": "/~it_security_manager/User_Report.xdo",

"runInChunkMode": true,

"params": [

{

"name": "lastUpdateDate",

"value": "__lastUpdateDate__"

}

]

},

{

"reportPath": "/~it_security_manager/Department_Report.xdo",

"runInChunkMode": false,

"params": [

{

"name": "location",

"value": "S1- Chicago"

}

]

}

]