Technical

OBIEE MUDE Repository Life Cycle

Posted by on July 4, 2010 at 6:00 pm
Share

The attempt today was to illustrate in a very simple diagram the metadata development process in a OBIEE multi-user development environment (MUDE).

Drop [oracle] database (and clean after yourself)

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

Clean database and control files after dropping database

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:

Abnormal termination of stage (cast those CLOBs!)

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

Abnormal termination of stage (cast those CLOBs!)

EPM Integration Updates

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

In order to move PeopleSoft HRMS9.0 data into EPM9.0 your team will need to deploy the ETL “Integration Update” for HRMS9.0 (HRMS=HCM). IU jobs need to be deployed to a separate project if you are running on linux.

Quickly run through Oracle Application Server advanced installation

Posted by on March 15, 2010 at 6:00 pm
Share

Quick instructions for OAS 64 bit installation on Linux

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….

Infrastructure Reference

Posted by on February 15, 2010 at 10:00 am
Share

Useful references on PeopleSoft and PeopleSoft EPM Warehouse Infrastructure Components

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

So I installed OBIEE, now what?

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

So I realized more than a week has gone since I finished installing OBIEE and while I’m going to the “Oracle BI Suite EE 10g R3: Build Repositories” class next week I still want to play around and get my questions started.