Friday, July 20, 2007

Project Server Reporting DB - reporting against WSS data

Finally the end of the financial year is here and I have finally some time to attend to my blog again. It has been a couple of weeks.

Over the last couple of weeks I have started to use the Project Server Database extensively and I must say that I am very impressed. I really like what the Microsoft Project Server team has done. Any information regarding the Project schedule, resource schedule and time sheet I can report against and thanks to the Project Server 2007 SDK I have started to write some valuable Reporting Services reports.

You should also have a go at the report builder in SQL 2005. All you need to do is create a Model. The easiest way to do this is to create a model against a Project Server Reporting Database view. The rest is done more or less by SQL Server. Once you have created the model you can allow business users to create their own report. So far so good. THANK YOU MICROSOFT :)

BUT as soon as you want to report against WSS data you will find it most challenging. The Project Server Reporting DB does transfer Risk, Issue and Deliverable data from WSS to the PS Reporting DB, but only the fields that are pre-defined in the Project Workspaces. That is not very helpful at all. Most Organisations ( if not all) do change at least the Risk and Issue list to suite their business. Any new field do not move from WSS to the PS Reporting DB.

Also, if you delete a field from the "out of the box" template you will receive an event log error saying something like this" The PS Reporting DB cant find a field from the WSS site". That tells me that Microsoft have hard coded these fields. AUTSCH.

Furthermore if you create new lists in the Project Workspace, these will not move into the PS Reporting DB. That means any information maintained in Project Work spaces cannot be reported against UNLESS you have a Reporting Services to WSS wrapper. I think that is very sad. We are in the process of developing a wrapper that will allow us to report against the PS Reporting DB and WSS Workpace Data.

so be aware out there, Reporting against the Project Server DB is excellent and easy. Reporting against WSS data is painful.

6 comments:

Unknown said...

hi i am also working on reporting through project server. Since u are too working on it just wanted to ask you how are you connecting to the reporting DB. Actually i need to connect to the reporting DB and develop custom reports with its data. But when we try to access the DB from code it does not allow, we need to change the named pipes and all and add sa user to login...is there some other way to access it. Does project server gives us connection string to use through any webserv ice instead we write it ourselves...

Antin said...

I have just encountered this exact problem. I need to produce a report that includes custom Risk and Issue fields and as you mention they do not get transferred to the reporting database.

How would you suggest I get access to the custom fields? You mention developing a wrapper of some sort?

Anonymous said...

Can anyone recommend the top Network Management program for a small IT service company like mine? Does anyone use Kaseya.com or GFI.com? How do they compare to these guys I found recently: N-able N-central database monitoring
? What is your best take in cost vs performance among those three? I need a good advice please... Thanks in advance!

Anonymous said...

[url=http://www.ile-maurice.com/forum/members/wetter-vorhersage.html][b]wie ist das wetter heute[/b][/url]

[url=http://www.ile-maurice.com/forum/members/wetter-vorhersage.html][b]wetter heute[b][/url]

Anonymous said...

[url=http://www.ile-maurice.com/forum/members/wetter-vorhersage.html]dem wetter[/url]

[url=http://www.ile-maurice.com/forum/members/wetter-vorhersage.html]wetter 10 tage[/url]

Anonymous said...

Hi.

A bank is a financial institution that accepts deposits and channels those deposits into lending activities. Banks primarily provide financial services to customers while enriching investors. Government restrictions on financial activities by banks vary over time and location. Banks are important players in financial markets and offer services such as investment funds and loans. In some countries such as Germany, banks have historically owned major stakes in industrial corporations while in other countries such as the United States bank are prohibited from owning non-financial companies. In Japan, banks are usually the nexus of a cross-share holding entity known as the keiretsu. In France, bancassurance is prevalent, as most banks offer insurance services (and now real estate services) to their clients.

The level of government regulation of the banking industry varies widely, with countries such as Iceland, having relatively light regulation of the banking sector, and countries such as China having a wide variety of regulations but no systematic process that can be followed typical of a communist system.[url=http://projectcontrol.v3host.nl]CLICK HERE[/url]