EPM2007: Timesheet cube vs. EPM Timesheet cube?

[Clark Wilson]

Could someone please summarize in a sentence the scope differences between
the "Timesheet" cube and the "EPM Timesheet" cube? If there is documentation
of this somewhere, just point me there.

Clark Wilson

 

[Dale Howard [MVP]]

Clark --

Beyond the Dimensions and Total Fields that these two OLAP cubes share in
common, following are the differences:

-- Only the EPM Timesheet cube contains the Project List, Resource List, and
Task List dimensions.

-- Only the Timesheet cube contains the Timesheet Project List, Timesheet
Resource List, and Timesheet Task List dimensions.

In our company's "Implementing and Administering Microsoft Office Project
Server 2007" book, we discuss each of the 14 OLAP cubes and show you
examples of useful Data Analysis views you can create using each OLAP cube.
Beyond this, the book also includes several useful tools, including an Excel
workbook that presents a side by side comparison of the Dimensions and Total
Fields available in every OLAP cube, and an OLAP cube search tool (Excel
workbook) that allows you to search for a Total Field or Dimension and find
the cubes that contain it. You can purchase the book at:

https://projectserverbooks.com/shopexd.asp?id=213&bc=no

Hope this helps.

 

[Theo Verdel]

Dale,
I have read the book you have writen to find out the differences between the two cubes. In our company we have a mayor difference between EPM timesheet and Timesheet.
As I understand both cubes should have the same results for a particular project.
Please can you answer the following questions:
- for a specific project the actual work must be the same for all the tree cubes ?
- if there are differences what could be the probleem ?
- how could we solve the problem (for example: can you reengeneer the cubes)?
- which tree cubes should be the most accurate ?

Thank you very much for your respons.

 

[Paul Conroy]

The SDK details the schema for both cubes with along with an explanation of
their purpose.

 

[mike.mahoney]

The SDK details the schema for both cubes with along with an explanation of
their purpose.

--
Please rate this post if it has helped

http://theprojectserverguru.spaces.live.com






- Show quoted text -

All

I have been using PS2007 timesheets and DA views for a long time and
in a number of postings have flagged deficiencies (bugs) in Timesheet
Data Analysis views.

When a timesheet is created the default is to populate it with tasks
scheduled for that week. You can add time to the timesheet in the
following way:
• on a daily basis for pre-populated tasks.
• for pre-populated admin tasks
• You can use insert lines function to add unplanned tasks, summary
tasks, project (top level)
• You can add unverified tasks – an activity not associated with any
project or admin item

The Timesheet cube includes all this data

The EPM Timesheet cube only includes project task level data, i.e. it
excludes admin time, unverified time and summary level task time.

The MSP_Project_Timesheet cube is based on the EPM Timesheet cube and
adds the configured project, resource and task attributes as
dimensions, as well as additional data (costs, baselines etc).
Unfortunately it’s useless as the additional dimensions, though
visible have no numeric data associated with them. See example below.

Note also that all the timesheet excludes tasks which have not had
time booked to them. Comparing the total of the planned work column
with total of Actual Work Billable is therefore of very limited value.

You can see examples here:

http://sleekstone.spaces.live.com/blog/cns!ED36ABFDCD099E3B!149.entry

regards

Mike