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.
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.
Here is my first attempt at a Silverlight Streaming Screencast. My apologies for the really bad lip sync in the short Picture-in-Picture section. Either a slip by me in editing or a breakdown in the space-time continuum between my webcam and the microphone. Probably the former. I’ll look at some other encodings for making available as downloads – probably an H.264 large or small, and the original high quality wmv. Any special requests? If I get a small enough one I’ll make it an attachment – but don’t want to fill up your inboxes if you subscribe via Outlook.
***Update*** Hint - Double-click to go full screen - ESC to return to the small view. And if the video doesn't play inline then go to http://www.microsoft.com/showcase/en/US/details/32fe834d-e2f0-4d9a-859f-0f2d68ab7c90
For ease of use here are a couple of the URLs given at the end of the screencast.
Should have highlighted this one too. Another Codeplex solution.
Project Description The Project Server 2007 Log File Report Tool enables the import and the reporting of log file generated by your EPM & SharePoint farm. The Log File Report Tool will import log files (in an SQL database) from all servers in your farm with the ability to filter them by date. Once the import is complete you can easily search for specific log file messages using the following filtering criteria: Area, Category, Level, Process, Server as well as date and created reports.
Enjoy! And feedback please on formats you would like to see in the future.
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!
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.