FDI BIP Connection (Parameter Misssing)

Question

FDI data augmentation pipeline fails with “invalid document structure” though the BIP report runs fine (CSV-only, no params). BIP connection test and metadata load succeed. After ~1.5 hrs job is rejected.

Any known workaround or configuration to make FDI accept pure CSV BIP output without dummy parameters?

RVohra · Answer

There is a nice oracle blog outlining this process

https://blogs.oracle.com/analytics/load-data-from-oracle-standard-bi-publisher-connector-with-interative-parameters-in-to-fusion-data-intelligence

See if it can help you resolve the issue. Hope it helps!

Jestin Rajan · Answer

Also, to add, the source for the data model is an Analysis and not an SQL query, as I find it easier to locate columns from the subject area rather than from physical tables. I have applied some filters on the Analysis — could those be the reason for this error?

Jestin Rajan · Answer

https://community.oracle.com/products/oracleanalytics/discussion/comment/72348#Comment_72348

Hi @Sumanth V -Oracle  Thank you for your response. Actually, there are no parameters defined in the data model that could be set as mandatory, and therefore, in the BIP connector reporting configuration, I don’t have any parameters to enter. I also tried creating a dummy parameter in the data model, but even after doing so, I continued to receive the same error.