generate email to enterprise resources based on their actual work

[Nosh]

In my organization a problem is that reports are generated weekly and people have to be reminded if they have not filled in their actual hours for tasks in project server. One solution that the project server sdk gives is to generate a custom cube, but the problem is that the code is in vb while I can do the stuff only in C#, so please let me know if c# code for cube generation for adding the week dimension is avaliable or not.
What I am doing right now is that I look at protfolio analyzer and take the count of everyones hours of actual work. I have to manually export it to excel and then sort every months totals separately and then e-mail everyone regarding their totals.
Is there a way I can automate this process. I was thinking if somehow I could make a macro in excel which would export the data automatically in excel and then sort and mail people. But the problem is the pivot table connects to the project server cube instance of analysis server, would I be able to do it manually?
If something like this or anyother solution is possible please let me know I have to do this faily quickly.
Nosh

 

[Rod Gill]

Hi,

Try reading the MSP_VIEW tables in SQL Server directly. They are read only
views designed purely for reporting. They are updated every time a project
is published. There are time phased ones by day. Filter for your week and
sum and you have the answer. Of course all time sheet updates will need to
have been updated first for accurate data.

--
For VBA posts, please use the public.project.developer group.
For any version of Project use public.project
For any version of Project Server use public. project.server

Rod Gill
Project MVP
For Microsoft Project companion projects, best practices and Project VBA
development services
visit www.projectlearning.com/

In my organization a problem is that reports are generated weekly and

people have to be reminded if they have not filled in their actual hours for
tasks in project server. One solution that the project server sdk gives is
to generate a custom cube, but the problem is that the code is in vb while I
can do the stuff only in C#, so please let me know if c# code for cube
generation for adding the week dimension is avaliable or not.

What I am doing right now is that I look at protfolio analyzer and take

the count of everyones hours of actual work. I have to manually export it to
excel and then sort every months totals separately and then e-mail everyone
regarding their totals.

Is there a way I can automate this process. I was thinking if somehow I

could make a macro in excel which would export the data automatically in
excel and then sort and mail people. But the problem is the pivot table
connects to the project server cube instance of analysis server, would I be
able to do it manually?

If something like this or anyother solution is possible please let me know

I have to do this faily quickly.