- Slowly Changing Dimensions
- Slowly Changing Dimensions
- P6 Analytics now makes it possible to capture non-fact (dimension) data for historical purposes. Begin by navigating to the
- Project Health
- dashboard, which contains an example.
- On the Dashboards menu, click
- Project Health
- .
- Click the
- History
- tab.
- Click the
- scrollbar down arrow
- to display the
- Milestone Dates that Have Slipped
- analysis.
- In the
- Activity ID
- column, click
- FO50022
- to display a detail of the activity over time.
- Note that dates in the
- Planned Start
- column are slipping over time.
- Planned Start
- is a dimension.
- Click the
- scrollbar down arrow
- to display more of the table.
- Original Path
- 4. Project Health
- History
- scrollbar down arrow
- scrollbar down arrow
- Slowly Changing Dimensions
- P6 Analytics now supports the ability to capture non-fact, or dimensional, data for historical purposes, including project, resource, activity, and resource assignment dimensional data. For example, if an activity's planned start date has changed between the current capture and the previous day's capture, the old and new value would both be recorded in the activity history provided that this project is configured in P6 EPPM for activity-level history capture.
- To access this feature:
- To configure a P6 Analytics analysis that reflects changing dimensions, add the dimension column you wish to track along with a column that reflects the desired time increment.
- Legal Notices