OBIEE - Analytics - I Am wondering why the data is not complete ?

3130642

HI

I am very new with OBIEE . For the past few months we are setting up a new OBIEE (newly installed) and we have already loaded and executed the data .

I am just wondering why our graphs are incomplete.

These are my graph scenarios :for supply chain management

1.) I will input Q2 as my quarter parameter there's an output for tables and graphs.

2.) I will input Q1 as my quarter parameter there's no output for tables and graphs.

3.) I will input Product name there are no output on the tables and graphs.

For Financial - General ledger

There are no output for graphs or table

Truly will appreciate your help

Thanks a lot :

renee

Syedsalmancs110

Hi Renee,

Looks like you have BIAPPS setup, you can mention the version either BIAPPS 7.x or BIAPPS 11g?

If you are not getting data in your report for a specific quarter or product then you need to get report specific query and run the same on datawarehouse to verify where exactly data did not get loaded correctly during the ETL load, from your problem statement it looks like the issue is with Fact table data,

you need to back track the table from datawarehouse-->ETL taks(PLP/SIL/SDE).

Thanks and Regards,
Syed Hamd Salman

[Deleted User]

Hi Renee,

Check whether the data actually exists in the form you're expecting in the source tables of your database. OBI just shows what's there unless you are caching old / stale data.

3130642

Hi Syed

BIAPPS version is 11.1.1.10.1.

I am still figuring out how to back track the tables form datawarehouse.

Thanks

renee

[Deleted User]

Have you checked whether the data is actually in the physical tables of the warehouse?

Have you checked whether caching is on and you're just hitting stale entries?

Have you verified the actual SQL which is emitted against the sources?

etc.etc.etc.