Oracle Fusion HCM Analytics

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Load Data from Oracle BI Publisher into Fusion Analytics Warehouse

Received Response
48
Views
1
Comments

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.



Answers

  • RanaAshutosh-Oracle
    RanaAshutosh-Oracle Rank 6 - Analytics Lead

    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"

    }

    ]

    }

    ]