March 2007 Entries

SSAS: OLAP Design Best Practices for Analysis Services 2005 - Technet Article
The following announcement was made recently on the Analysis Services forum. A collection of best practices on the design of OLAP objects in Analysis Services 2005 is now available at http://www.microsoft.com/te... These tips were gathered from the product team and our parners in order to help people create better OLAP databases. It looks like a lot of these Best Practices have been incorporated into the SQL Server Best Practices Analyzer tool ......

Posted On Monday, March 26, 2007 10:35 PM | Comments (0)

Interview with ZD Net
The interview with ZD Net that I mentioned a couple of weeks ago was published today. You can see the full article here http://www.zdnet.com.au/mic... It will be interesting to see what questions I get as the interview was based around the topic of "Business Intelligence for the CIO" - so I don't expect to get any trick MDX questions :) ......

Posted On Monday, March 26, 2007 10:22 PM | Comments (0)

Fully Certified!
I just checked on the PRometric and Pearson Vue sites and both of the new Microsoft BI Certifications are now fully available for you to sit. I don't normally browse through the exam lists on these site :) but I got the confirmation email that I had passed the beta of the Technical Specialist (70-445) exam a few weeks ago and the one for the IT Professional exam (70-446) arrived over the weekend. This was my clue that the beta process had been completed and the exams had been released ......

Posted On Tuesday, March 20, 2007 6:23 AM | Comments (3)

SQL Server MVP Series on ZD Net
Myself and a couple of the other Australian SQL Server MVPs (Greg and Greg) are participating in a series on ZD-Net Australia. http://www.zdnet.com.au/mic... My "interview" is coming up on March 26th, it's titled "Business Intelligence for the CIO" I will be curious to see what sort of questions I get ......

Posted On Wednesday, March 14, 2007 11:25 AM | Comments (0)

SSAS: Custom Reports in SP2
Chris Webb blogged about the new Custom Reports feature that was added to SSMS in SP2 here http://cwebbbi.spaces.live.... while SP2 was still in CTP. These reports work great for the relational engine. However, while there are a number of standard reports that have been added for various SSAS objects, if you go to add your own custom reports you will find the following: Notice how the "Custom Reports..." option is greyed out? Apparently Custom reports are only supported ......

Posted On Monday, March 5, 2007 8:43 PM | Comments (5)

SSAS: Getting the xmlaWarningCollection from a Process operation
There was a question recently on the Analysis Services forum asking how to get a list of the Warnings from a Process() method in AMO. There is an overload to the Process methods which includes an xmlaWarning collection, so this should be a pretty easy thing to do - right? Wrong! It's not as easy as it first appears. After inserting an invalid record into the fact table of a test cube, I was able to process the cube using the Business Intelligence Development Studio (BIDS) and see the relevant warnings, ......

Posted On Sunday, March 4, 2007 7:39 PM | Comments (0)