This blog post was inspired by a question from Greg – and thought this might be the best way to answer. The podcast is just the commentary – so if things are not clear please view the screencast to see what I was talking about! The demo shows restoring a content database backed up from another farm on another domain – then adding to a web application and getting access to the content.
Double-click to go full screen, or this new SilverLight 2 Black Glass template I am using has extra controls. I’ll repost a stream that doesn’t auto start too… Sorry. Done!\
Switching to a different video host. Might switch again - not too keen on the adverts... sorry. But some useful links to other Project videos!
Mike Plumley from our UA team has done a great job in producing some walkthrough screencasts of a Project Server 2007 farm installation and also configuration of OLAP. These follow TechNet articles but show you all the steps involved. They are available for download as wmv files.
If anyone would prefer to stream these then let me know and we can get some links for you.
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.
This podcast is a talkthrough of the process of building a cube. I forgot to mention firewalls which can also block access to SQL/Analysis Services - so see the TechNet artilces for details. For other blog postings on this topic go to http://blogs.msdn.com/brismith/archive/tags/Analysis+Services/default.aspx.
As promised in my previous blog, here are a couple of different formats for download. The first is the original wmv used in the Silverlight streaming version, and the second is the same but formatted for the Zune (or any other handheld that shows wmv). I did try H.264 format, but it seemed to bloat the size and give me 110MB Mp4 for the original and 50MB for the “small”. Hopefully if you need these formats you can convert from what I have posted, using Expression Encoder yourselves.