Archive for June, 2010

Drop [oracle] database (and clean after yourself)

June 30, 2010
Share

Clean database and control files after dropping database

Tags: , , ,
Posted in Oracle Database, Tips | No Comments »

PeopleSoft EPM Dimension NULL records

June 11, 2010
Share

How to handle cases where configuration tables like PS_GVT_POI_TBL or other feature sets that don’t apply to your company are not being implemented. In many cases complete dimensions will be empty and look-ups in fact jobs will fail.

Tags: ,
Posted in PeopleSoft EPM, PeopleSoft EPM Functional | No Comments »

PeopleSoft Enterprise Performance Management Warehouse Schema Naming Standards

June 2, 2010
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:

Tags: , , , , , , ,
Posted in Featured, Fusion Intelligence, Oracle Database, PeopleSoft EPM | No Comments »