BI HR Analytic with PeopleSoft 90
I am trying to configure BI HR Analytic with vanilla PeopleSoft 90 and I am struggling with ETL load. I've installed 10g, OBIEE, BI HR Analytic app, Informatica 8.6., and DAC running on Windows XP.
I was able to run most of the Informatica workflows via DAC. After having the Catalog populated for Oracle Analytics Usage and Oracle Data Warehouse in Administration Tool, OBIEE is now showing “No Results” for Dashboard and Report, instead of “SQL Error” (see screenshots).
So far, ETL has been able to create all the physical tables and dimensional table and data, except the employee level data.
Source database is running on 10g R2 and target database is running on 10g R2 as well, and ODBC is working correctly. It would be much appreciated if you can provide me with some tips that I should be looking.
Thanks in advance for your help.
Edited by: gregory.lee@accenture.com on Feb 7, 2010 1:18 PM