OIC-Execute BIP Query Dynamically

Summary:

Hi,

Today my customer asked for a specific requirement. We are executing the BIP report of Oracle Fusion Cloud from OIC and retrieving the data.

But whenever we need to update the BIP Data Model SQL query we need to inform the customer and update the Oracle Fusion Cloud. Instead of that can we have this SQL query control at OIC side, in other words,

can we create this BIP SQL query string in OIC and send it to Oracle Fusion Cloud to execute and get the response back to OIC?

Appreciate your inputs.

Thanks, Sreedhar