BICC : Ability to combine two data stores to give single file output — Oracle Analytics

Oracle Transactional Business Intelligence Idea Lab

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

BICC : Ability to combine two data stores to give single file output

61
Views
3
Comments

Description

Hello,

Business Use Case: We use the BICC exports to send to EBS staging tables so that the data can be used for reporting purposes. Earlier we used file exports from OEC and they use to manually import.

Problem: At this stage, we send multiple files for example : For Accounts, there are two data store outputs are required to be sent.

Fix we are looking: We need a functionality where we can perform joining conditions and combine two data stores into single data store and take its output as single file.

Use Case and Business Need

Hello,

Business Use Case: We use the BICC exports to send to EBS staging tables so that the data can be used for reporting purposes. Earlier we used file exports from OEC and they use to manually import.

Problem: At this stage, we send multiple files for example : For Accounts, there are two data store outputs are required to be sent.

Fix we are looking: We need a functionality where we can perform joining conditions and combine two data stores into single data store and take its output as single file.

More details

Hello,

Business Use Case: We use the BICC exports to send to EBS staging tables so that the data can be used for reporting purposes. Earlier we used file exports from OEC and they use to manually import.

Problem: At this stage, we send multiple files for example : For Accounts, there are two data store outputs are required to be sent.

Fix we are looking: We need a functionality where we can perform joining conditions and combine two data stores into single data store and take its output as single file.

Original Idea Number: 7178d00e63

7
7 votes

Submitted · Last Updated

Comments