SSAS: OLAP Design Best Practices for Analysis Services 2005

<< Interview with ZD Net | Home | Another Aussie SQL MVP >>

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/technet/prodtechnol/sql/bestpractice/olapdbpssas2005.mspx. 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 that Chris Webb blogged about here. But if you have the choice, it is probably better to learn these best practices before building your database rather than building it and then running the Analyzer to find any issues.

Share This Post:
Short Url: http://wblo.gs/SZL

Feedback

No comments posted yet.

News

About Me
I am a consultant, based in Melbourne Australia. I primarily work in the Business Intelligence area with SQL Server, although I also dabble in Content Management Server and .Net coding

Contact Me

MVP

Legal
Any and all code, software, examples, suggestions and anything else on this web site is available for you to use at your own risk. No warranty is expressed or implied.

Views and Opinions
The views and opinions expressed on this web site are not necessarily the views or opinions of my employer.

NetworkedBlogs

Blog:

Random Procrastination

Topics:

MDX, SQL Server, BI

Follow my blog

Twitter

darrengosbell @mtydeman sorry, was not on twitter last week. Yes, SSAS MD works well with snowflakes. The joins are resolved during dimension processing about 12 days ago

darrengosbell SSAS: Clearing the MDX Script for a session in SSMS http://t.co/jioE6bQO about 112 days ago

darrengosbell SSAS: Executing MDX Scope statements using SSMS http://t.co/Tpx9pfoz about 156 days ago

darrengosbell @MitchDenny thanks - I had a ball, #powerview is such a cool thing to demo about 248 days ago

darrengosbell @asantaballa @jenstirrup daxeditor is not me, that's an MS sample. I'm working on http://t.co/b1JsRLps at the moment about 305 days ago

darrengosbell @Technitrain I can see it too about 305 days ago

darrengosbell @jppp I hope you enjoy the 2012 release :) life's been pretty good - too busy, but still good. about 430 days ago

darrengosbell BIDS Helper 1.6 Beta Release (now with SQL 2012 support!) http://t.co/dSWkG7PI about 430 days ago

darrengosbell @Kjonge just showed that in post-ctp3 #denali #Dax in #ssas will have query plans as profiler events about 588 days ago

darrengosbell Really hard choice for this timeslot @Kjonge, @jenstirrup & @marcorus all have sessions at the same time. Lucky I ordered the DVDs #sqlpass about 588 days ago

Darren Gosbell [MVP] - Random Procrastination

Business Intelligence, SQL Server, .Net, Powershell and MDX Madness