Fact Driven

The P6 Analytics product is driven by Facts. When you are looking at a subject area, take Primavera - Activity for example. You can add from the Project Dimension Project Id and Project Name. This will list out all projects in the w_project_d dimension table. In your Analysis if you add a Fact - such as actual cost - this will join the Project Dimension to the Activity Spread Fact table. When making this join a fact record must exist or you will get No result set found returned. You would have this situation if the project you are looking for either has no activities or does not have any spread records.

In P6 Analytics versions 1.2 and higher this could occur if the project has not been published in the Extended schema. If you know there are activities that should contain spread data the best place to begin evaluating would be the extended schema. In the P6 application go to the Projects section and add columns for enable publication (make sure it is checked) and last published (make sure this date is populated and recent). You can right click on the project in P6 and choose publish now. Check back in a few minutes and see if the last published date has been updated. More more information on the Extended schema check out the P6 Extended Schema white paper.

Comments:

Post a Comment:
  • HTML Syntax: NOT allowed
About

Provide new information on P6 Analytics and Reporting Database.

Search

Categories
Archives
« July 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
  
       
Today