How to create Custom BICC PVO Creation in Fusion

Question

Can someone share details on if it's possible to create Custom PVOs for the tables for which the standard PVOs are not available? If yes, please share the steps to create it.

RVohra · Answer

Not sure, if you have already got the answer. Can you please update with your findings for community members like me. I was also checking but found only these BICC capabilities, nothing related to Custom BICC PVO.

* Configure an external storage location that works for your data needs.
* Extract complete or partial data. You can select offerings or specific objects.
* Run extracts on-demand or schedule them to run at specified intervals during the day, in a week, or throughout the month.
* Run incremental extracts if you need only the data that changed since your last extract.
* Schedule multiple independent extracts at convenient intervals.
* Monitor extracts and review logs.
* Export configured offerings and associated data stores.
* Manage refresh metadata and specify dates for incremental refresh comparison.

Bhaskar Konar · Answer

https://community.oracle.com/products/oracleanalytics/discussion/comment/69755#Comment_69755

Hi @Prabhjeet Kaur,

Please check with Oracle support for their expert opinion and if possible please update here; it'll be useful for the knowledge and future reference.

Thank you.

Prabhjeet Kaur · Answer

Thanks @Bhaskar Konar . I have gone through these links. But it says PVO's getting created using custom objects, but our requirement is to create custom PVO for seeded oracle table. But nowhere it's mentioned that its possible to create custom PVO for oracle standard tables.