Monday Feb 24, 2014
If you are upgrading to P6 Reporting Database 3.1 or higher you'll want to allow for adequate time for the upgrade process. In this blog we will focus on upgrading the Star schema. The first major item to be aware of is that during the upgrade an ETL process is initiated. If you have a job scheduled to run your ETL process at a given time you'll want to make sure you allow enough time for the upgrade to finish or you may want to cancel the job until after the upgrade has completed. Having two ETL's running at the same time or overlapping at any point could be problematic for your STAR schema and the integrity of the data.
Generally running an upgrade will take longer than a traditional daily ETL. During the upgrade process a set of BCK (backup) tables are created. Backups are taken for all history (_history_f) and slowly changing dimension (_hd and _hf) tables. The schema is recreated and then the data is reinserted into the new tables. Also backed up is the ETL_CALCULATIONS table that contains the metadata calculations. After the backups are completed the ETL process is run to populate the remaining dimension and fact tables.
Before running an upgrade make sure to backup your STAR schema. You'll want to make sure this data, especially your history, is preserved incase of any kind of failure during the upgrade.
Wednesday Feb 19, 2014
By Jeffrey Mcdaniel-Oracle on Feb 19, 2014
With the P6 Extended Schema being the lifeline for data for the P6 Reporting Database and P6 Analytics, it is a good idea to get an understanding of how it works and some techniques you can use that can help make your usage of P6 Analytics easier and more efficient. I wanted to call your attention to a new white paper recently released that contains some advanced techniques and new information on the P6 Extended Schema.
Top Five Things You Need to Know about the P6 Extended Schema
Publishing too often
I Want to Build My Own Queue
Provide new information on Primavera Analytics and Data Warehouse
- Role Utilization (New to Analytics 16.1)
- How to Apply Row Level Security to New Tables
- How to add more than 50 Codes or UDFs to Primavera Analytics
- Logging in the Data Warehouse Configuration Web Application
- Upgrade Considerations When Using Multiple Data Sources
- History Options for Unifier Data
- Why is Oracle_Home Required? What Would Happen if it is Not Set?
- Top Questions to Answer Before Setting Up Primavera Analtyics
- Refreshing RPD Translation Changes Without Restarting OBI Services
- User Defined Field Fact History