Is there a known bug in the OLAP cube data?

[Ramush]

Is the reports data on MS Project the same as the one I see in my OLAP cube?

 

[Reid McTaggart]

Not necessarily. There are some mistakes and bad practices that can cause a
difference. When you find a difference, it usually means that someone is not
using Project Professional correctly. Depending on your configuration, there
are several possible causes of data mismatches.

If you tell us more about what you are seeing, maybe we can help you more.

 

[Ramush]

Just to make sure, can yo uplease guide me on the right way to generate the
following report on MS Project 2003 and compare the numbers to the same
report generated by the OLAP cube on Project Web Access.

Report 1
A table showing the total number of ACTUAL working hours for several
resources that are relevant to a certain project.

Report 2
A table showing the total number of PLANNED working hours for several
resources that are relevant to a certain project.

When I generated the [ACTUAL] report in MS Project I saw the total hours
spent by a resource on all the projects he was assigned too. However, when I
used the OLAP cube to generate the same report I saw only data related to the
project I was interested in. However, I'm not sure I understand correctly the
meaning of the data I get in the reports on MS Project. Bascially, I'm
looking for the best way to compare apple to apple and check that the time
reported by my reources using PWA timesheet is correct.

 

[Reid McTaggart]

There is more than one way to get the reports you want. Here is one approach:

Choose the Resource Usage view.
Insert the Work and Actual Work fields if they are not already in the view.
Insert the Project field.
Group on Project.

The totals you want will be displayed in the left side of the view.



--
Reid McTaggart
EPM Architect
Microsoft

Just to make sure, can yo uplease guide me on the right way to generate the
following report on MS Project 2003 and compare the numbers to the same
report generated by the OLAP cube on Project Web Access.

Report 1
A table showing the total number of ACTUAL working hours for several
resources that are relevant to a certain project.

Report 2
A table showing the total number of PLANNED working hours for several
resources that are relevant to a certain project.

When I generated the [ACTUAL] report in MS Project I saw the total hours
spent by a resource on all the projects he was assigned too. However, when I
used the OLAP cube to generate the same report I saw only data related to the
project I was interested in. However, I'm not sure I understand correctly the
meaning of the data I get in the reports on MS Project. Bascially, I'm
looking for the best way to compare apple to apple and check that the time
reported by my reources using PWA timesheet is correct.

Not necessarily. There are some mistakes and bad practices that can cause a
difference. When you find a difference, it usually means that someone is not
using Project Professional correctly. Depending on your configuration, there
are several possible causes of data mismatches.

If you tell us more about what you are seeing, maybe we can help you more.