OLAP Views

G

Gary Johnson

Hello,

I need a view that presents information on a monthly basis but based on the
last Friday of each month - is this possible and if so how ?

Also I need to report on the number of man days of work done per resource
based on the following criteria :-

If less than 2 hours is done then ZERO man days are accounted for on that
day
If greater than 2 but less than 5.5 hours then that is HALF a man day
If its greater than 5.5 hours then its a FULL man day (even if they do 12
hours).

I need to be able to set up an OLAP view that gives me the above
information, and I have been struggling to do so.

Can anyone point me in the right direction please ?

Thanks

Gary
 
G

Gary L. Chefetz

Gary:

In order to accommodate this, I believe that you'd need to add a custom time
dimension to your cube. Not a simple task. Your other option is to query the
database directly.

--

Gary Chefetz [MVP]
http://www.msprojectexperts.com
"We wrote the book on Project Server"

*** Remember to look for line breaks in links posted to the news group, use
cut and paste for these.
 
Top