Oracle Analytics Publisher Idea Lab

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

Ability to create custom Datastore in BI Could Connector

164
Views
6
Comments
Rank 2 - Community Beginner

Organization Name

Chewy Inc

Description

BICC (BI Cloud Connector) is the only tool that can extract data from Oracle Fusion Cloud ERP with incremental refresh capabilities. It will be really great if Oracle can provide the ability for the user to create custom datastores with a query pertaining to their business needs.

Use Case and Business Need

The limitation with the current BI Publisher reports is that it doesn't provide an option to create the extracts with incremental refresh capability.

BICC (BI Cloud Connector) is the only tool that can extract data from Oracle Fusion Cloud ERP with incremental refresh capabilities. The ability for the user to create custom datastores with a query pertaining to their business needs will be greatly helpful for analyzing the data realtime and create custom visualizations over them.

Original Idea Number: d691e8b6a7

5
5 votes

Submitted · Last Updated

Welcome!

It looks like you're new here. Sign in or register to get started.

Comments

  • Rank 5 - Community Champion

    Ram,

    BICC extracts data to flat files, which you can upload to Oracle Analytic Cloud Service for analysis.  Once data is extracted to a data store, it is technically no longer 'real time'.  Can you say more about the 'business needs' for your use case?  What kinds of business analyses are you planning? How real time does the data need to be? who will use the data store?  how do you anticipate the data stores will grow in both the types of data and data volume?

    Ling

  • Ram, Are you asking for the capability to create custom BI View Objects (data stores) in BICC?

    Rohan

  • Rank 2 - Community Beginner

    That is right

  • Rank 2 - Community Beginner

    We would want to add a custom query as a PVO, so that I can schedule it with incremental refresh.

  • Rank 2 - Community Beginner

    Hey Oracle Team,

    Any updates on this ER? Is this going to be considered in any of the next releases?

    Thanks!

    Best Regards,

    Ram

  • Rank 1 - Community Starter

    This would be a great feature.

Welcome!

It looks like you're new here. Sign in or register to get started.