System Settings → Report Templates → Custom Reports → Viewing Legacy Dimension Data
The Task Plan view has baselines that are nearly identical to how baselines are used in Microsoft Project. Because of this change in functionality, Project Portfolio Management was required to stop using dimensions to store baseline data.
Old dimension data has been preserved and report queries can still be run against them. You can download a sample report called Tasks By Investment (Legacy Data) that shows you how to compare your old dimension data to the new baseline data.
In order to use this report, you must add it to your list of custom reports found in the Report Templates tab in the System Settings module.
Download: Tasks by Investment (Legacy Data)
Query execution failed for data set: [name of dataset] There was a problem executing the stored procedure. Attribute name [name of attribute] is not a valid name in the type system.
The following changes will need to be made to the report queries:
|Old Field||New Field / Comments|
No longer tied to dimensions; now fixed to eleven baseline values. Previous dimensions, such as Target, Baseline, or Task Baseline are now Baseline1, Baseline2, Baseline3, and so on. Where [Dimension] is the name of the old dimension, tsk_BaselineWork, tskBaseline1Work, tskBaseline2Work, and so on, represent the names of the new baselines.
Keep in mind that old dimensioned data is not synchronized with data that is found in the Task Plan view. As you add new baselines, existing reports that contain old dimensioned data and old queries for retrieving dimensioned data will not work. You will need to update your queries for the new table structures and reports in order to synchronize it with the new baseline data found in the Task Plan view.
SELECT * FROM dbo.PES_ProjectTaskDimension_Obsolete
SELECT * FROM dbo.PES_ProjectAssignmentDimension_Obsolete
SELECT * FROM dbo.PES_WorkItemTaskDimension_Obsolete
SELECT * FROM dbo.PES_WorkItemAssignmentDim_Obsolete
SELECT dim_UID FROM dbo.PES_Dimension WHERE dim_IsBaseline = 1 SELECT obj_ProjectUID, obj_Name, pt.obj_UID, tsk_Start, tsk_Finish, pt_baseline.tsd_Start AS baseline_Start, pt_baseline.tsd_Finish AS baseline_Finish FROM dbo.PES_ProjectTask pt
JOIN dbo.PES_ProjectTaskDimension_Obsolete pt_baseline ON pt_baseline.obj_VersionIndependentUID = pt.obj_VersionIndependentUID AND pt_baseline.dim_UID = 5 WHERE pt.prv_Published = 1 ORDER BY obj_ProjectUID
Descriptions for the fields that are available in this report can be found in the following table.
The status of a cost, or the status of the amount of money that is spent to produce something of value.
Variance is the difference between two data points, such as the difference between the amount of planned work and the amount of actual work. Users can choose to show or hide the variance between the dimensions chosen. If the purpose of the report is planning more than operational tracking, some users may choose not to display the variance. Unless an investment is tracking actuals, there may not be any meaningful basis for variance analysis. Filter options: Hide, and Show.
The date on which a task is scheduled to finish.
The date by which work on a task (or a task plan) actually finished.
The amount of money that is spent to produce something of value.
|Labor Cost (Actual)||
The cost of labor for a task in a task plan.
The current status of a project.
The date on which a task is scheduled to start.
The date on which work on a task (or a task plan) actually started.
The name of the task.
The total amount of work that has been scheduled for a task.
The amount of work that has been completed, to-date, by all resources who have been assigned to a task (or a task plan).
Before you can use the Tasks by Investment (Legacy Data) report, you must first upload it into your system.
Copyright © 2003–2011 Serena Software, Inc. All rights reserved.