BI Publisher data does not match OAC data

SERGIO BARRETO

I created a report in BI Publisher, made the connection in FDI to BI Publisher, created a dataset using data augmentation, connected to Oracle Autonomous Data Warehouse to use the BI Publisher dataset, however, the data does not match in FDI. For example, the supplier AMAZON in BI Publisher registers 6 invoices but in FDI only 1 appears. Why? the SQL does not have any filter, when I created the dataset in FDI I did not include any condition, what is needed?

BI Publisher:

Dataset, workbook FDI:

Mallikarjuna Kuppauru-Oracle

Hi @SERGIO BARRETO

Its an able created for your DA job. check your DA job and find the table name and query the same on ADW database to see the loaded data .

Regards,

arjun

Sumanth V -Oracle

@SERGIO BARRETO - The extraction service stores rejected records in the Warehouse Refresh Statistics dashboard. You can view this dashboard to see which records were rejected and analyze why they were rejected.

Please refer the below document for detailed steps:

https://docs.oracle.com/en/cloud/saas/analytics/24r4/fawag/view-records-rejected-extraction.html

Kindly, validate this once and share your feedback!.

SERGIO BARRETO

Hi @Sumanth V -Oracle ´

but it does not say why, How do I know why they were rejected and how can I correct them?

Sumanth V -Oracle

@SERGIO BARRETO - Edit the workbook and add the below 2 columns it will show the detailed cause of rejection:

1. Reject Record Code
2. Reject Record Description

Example:

Hope this helps!

SERGIO BARRETO

@Sumanth V -Oracle thanks,

I got this message, I deleted all the data increments that I was not using, leaving only in dataset with the BI Publisher I use:

I click on reload, how long will the update take?

Sumanth V -Oracle

@SERGIO BARRETO - As the Details banner state, it will run in Full load mode in the next incremental scheduled run.

Alternatively, when you edit an augmentation, Oracle Fusion Data Intelligence submits a request to refresh the data immediately. During this time, you can't perform another edit action. You must ensure not to modify the definition of the data augmentation pipeline job while the job is in process. In case you need to modify the job definition while in process, then you must resubmit the data augmentation pipeline job.

You can use this option when needed to run immediately. Thanks!

SERGIO BARRETO

@Sumanth V -Oracle Hi,

The information between BI Publisher and OAC still does not match. I deleted all the data increments, re-created the report in BI Publisher, updated the connection in FDI administration, but still the information is not the same. What could be happening?

Ram-Oracle

@SERGIO BARRETO Could you please confirm the following

1)Username used to create bip report at otbi analytics/xmlpserver

2)Username used at faw bip datasource connection for the purpose of creating data augmentation.

please confirm if both usernames are matching.

SERGIO BARRETO

@Ram-Oracle Hi Ram,

BI Publisher

Connection FDI to BI Publisher

Ram-Oracle

@SERGIO BARRETO Please access otbi bip report and export it to csv and access fdi adw db and query bip augmented table (select * from <bip dataaugmented table>) and export it to excel at adw db and compare the data with respect to number of rows.

SERGIO BARRETO

@Ram-Oracle

did not manage to locate:: "query bip augmented table", is it in the FDI management console or a report in OAC?