Wednesday Feb 06, 2013

Path too long when copying P6 Analytics Catalog

With a default installation of Oracle Business Intelligence and P6 Analytics 3.1, some object in the P6 Analytics 3.1 default catalog create errors because the path length is too long. Please consult the following Oracle Business Intelligence document, section 17.1.1.1 for Object Name Guidelines (http://docs.oracle.com/cd/E23943_01/bi.1111/e10541/prescatadmin.htm).

If you selected to take the default paths when installing Oracle Business Intelligence, then by default your catalog path with be /home/oracle/Middleware/instances/instance1/bifoundation/OracleBIPresentationServicesComponent/coreapplication_obips1/catalog

This path may cause errors when copying the P6Analytics catalog.

To workaround this issue, create a new folder in a shorter path location (e.g. \home\oracle\Middleware\catalog), copy the P6Analytics folder from the P6 Analytics 3.1 release media to the new folder, and change the path location in Enterprise Manager for your install of Oracle Business Intelligence to use the shorter path.

Additionally, if you installed Oracle Business Intelligence on Linux/UNIX, you can alternatively create a symbolic link, then reference the symbolic link in Oracle Business Intelligence for the catalog path. In Windows, map a drive to the catalog location, then reference the mapped drive in Oracle Business Intelligence for the catalog path.

Tuesday Feb 05, 2013

Information around the P6 Extended Schema

The following blog is around the P6 Extended schema and covers some general topics related to settings that affect the P6 Extended schema services. Because the P6 Extended schema is the data source for P6 Analytics understanding how it works and it's settings are important to having a successful P6 Analytics implementation. The Extended schema applies for all P6 Reporting Database versions 2.2 and higher and P6 Analytics 1.2 and higher. If the data is not in the Extended schema it will not end up in P6 Analytics.

What causes a project to get published?
  • Automatic publishing 
Projects are automatically published when a user right clicks on project in P6 and choose publish now. Next time the project service runs this project will
be added to the queue. Some operations could cause an internal update of fields on the project level that cause the same affect and force the project into the queue on the next project service run.
  • Crossing threshold '# of changes exceeded'
  • Crossing threshold 'time since last publication exceeds' and has had a change since last threshold period
Where are the threshold counts being tracked?

  • Based on the threshold settings when crossing a certain number of changes the project is added to the queue to be published.These changes are calculated from changes on activities in the project, wbs level for the project, resource assignments on the project, and relationships on the activities. Changes in these areas will be added up in an internal table in the PMDB until it crosses the threshold of changes or the threshold of time has been crossed for projects with changes. At either of those times the project is added to the queue for calculation.

What needs to occur for a new project to make it into P6 Analytics?
  • The project must be created, enable publication set. The project must be published. After project has been successfully published the Security global service must be run to calculate security on the project.  Naturally over the course of a day the global services are run and this process is taken care of, but if you need the new project immediately you must run this Security global service after publishing the project.  When you have confirmed all these processes have occurred run the StarETL.  At this point the project should be in the Star database and available for the P6 Analytics application in OBI.
About

Provide new information on P6 Analytics and Reporting Database.

Search

Categories
Archives
« February 2013 »
SunMonTueWedThuFriSat
     
1
2
3
4
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
  
       
Today