Project Server 2007: Can’t find your WSS data in the OLAP cube?

This was a recent support issue with great work from Kate and Shazeb in getting to the resolution.  Getting either of them to take credit was a harder job – so they get to share.

The scenario is – you create a project plan, publish and create a workspace, then go to that workspace and add some issues (my new collective term for a group of issues is “a box”) and we add some risks (a threat of risks?). All good so far, so we build a cube and look for the data.  The SDK says it should be there (look in the OLAP Cube Schema document).  Nothing!  What happened!

Looking in the queue gives us some clues.  When data goes into the reporting database the this is driven by a reporting job – and we don’t see any of these when we add issues or risks to a workspace.  But we do see a number of reporting jobs running when we publish a project – including a Reporting (WSS Sync).  Go back an publish the project again, either from Professional – or use PWA and go to Project Center, select the project then Action, Edit Properties, Save and Publish will do the trick.  Build the cube again and your box of issues and threat of risks will be available in the cube.

You could do some automation to force a publish after making changes to WSS workspaces – but may be more efficient to come up with a procedure to re-publish current plans before a cube build if you really need to see this information.

I’ve also decided that when it makes sense I will post blogs in text and audio format – so this is my first dual format blog.