Monthly Archives: July, 2007
Renaming an Analysis Services 2005 cube
There is a question on how to rename an Analysis Services 2005 cube since you cannot do that within SSMS (you can rename a database but you cannot a cube). … Continue reading
SSAS 2005 Error Codes and Messages
Thanks to Edward Melomed and Eric Jacobsen for these quick tips! In order to view the full list of error codes and messages for SQL Server Analysis Services 2005, … Continue reading
Analysis Services 2005 Trace Event Definitions
In the Best Practices whitepaper Analysis Services Processing Best Practices (http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/ssaspbpr.mspx), I had noted in the Troubleshooting Best Practices > Create a system-wide trace file section that you could create … Continue reading
Distinct Count Optimization for Analysis Services 2005
In reference to my blog on Distinct Count Optimization at http://denster.spaces.live.com/blog/cns!125D53A08EC75357!1156.entry, I would like to expand it slightly specifically for Analysis Services 2005. Based on customer visits and more extensive … Continue reading
