Fusion Intelligence

Informatica being replaced by ODI in Oracle BI Apps 7.9.5.2

Posted by on August 1, 2013 at 6:00 pm
Share

In a long anticipated move among both Fusion Intelligence and Oracle BI Apps customers, Oracle has released the first versions of its packaged business intelligence solution that replaces the third party tools of previous versions (IBM DataStage or Informatica Power Center) with Oracle Data Integrator as the back end ETL tool. You can find detailed […]

Configuring WebLogic Automated Startup Credentials

Posted by on May 26, 2011 at 2:00 pm
Share

After reading this post you should be able to configure the boot.properties file to provide the WebLogic server with startup credentials, a necessary step when configuring the server for automated startup …The WebLogic server does not start automatically, it is prompting for a user name and password    WebLogic not reading boot.properties file

Linux Environment variables to simplify your life – OBIEE 11g System Administrator Edition

Posted by on April 19, 2011 at 7:18 pm
Share

As I spend a lot of time switching between a very well defined set of directories in the Oracle Middleware home for OBIEE 11g I have been developing a list of variables that I like to use in my scripts and configure in the servers that I most commonly work with. They have proven to […]

OBIEE Repository Reporting

Posted by on December 25, 2010 at 6:00 pm
Share

Extracting lists of OBI repository objects

PeopleSoft Enterprise Performance Management Warehouse Schema Naming Standards

Posted by on June 2, 2010 at 6:00 pm
Share

The nicest thing about PeopleSoft after the whole PIA Metadata-driven interface and its impact on data quality is how meticulous PeopleSoft engineers are about documentation and sticking to naming standards, here’s a simplified diagram of the wharehouse architecture and the naming standard for objects in each section of the schema:

Leverage PeopleSoft EPM Data Lineage Spreadsheets

Posted by on February 28, 2010 at 6:00 pm
Share

Not having to do all the leg work necessary to arrive at table-level data lineage in the PeopleSoft EPM Warehouse is a great testimony to good documentation and a great culture back there at big PS….

Don’t go too fast about rolling out your EPM 9.0 OWS jobs if your source system is HCM 9.0

Posted by on January 10, 2010 at 6:00 pm
Share

Peoplesoft EPM ETL Configuration