Magenic Technologies Community Blog

Browse by Tags

• Analysis Services (SSAS) Processing and Aggregations

  I get a lot of questions about this and see quite a few postings about Analysis Services processing in the MSDN forums. So you created an SSAS database solution and have deployed it to a production environment. Now the data has accumulated and you need Read More... Posted Wednesday, October 28, 2009 7:10 PM from Dan English's BI Blog | 0 Comments Filed under: Analysis Services

• Gemini CTP2 Install Experience and Overview

  It took me a while, but I tracked down the online links and filled out the survey to get access to the CTP2 release of Gemini known as ‘SQL Server 2008 R2 August CTP and “Gemini” Add-in’. I also signed up for the CTP3 Gemini Preview. Here are the screenshots Read More... Posted Saturday, August 29, 2009 10:59 AM from Dan English's BI Blog | 0 Comments Filed under: Analysis Services

• Windows Server 2008 Kerberos Bug Patch – resolves SSAS connection issues

  Yesterday I was notified by a colleague that Microsoft had released the patch to fix the AES Kerberos issues that had been discovered earlier this year - Windows Server 2008 Kerberos Bug – Transport Connection Issues with SSAS data . I had not been notified Read More... Posted Tuesday, July 21, 2009 6:11 AM from Dan English's BI Blog | 0 Comments Filed under: Analysis Services

• Slicing Analysis Services (SSAS) Partitions and more

  Just wanted to touch base on a couple of items with partitions referencing the ever popular Adventure Works 2008 sample Analysis Service project available to download from CodePlex here – SQL Server 2008 SR1 downloads – it appears that they have bundled Read More... Posted Friday, May 15, 2009 10:48 AM from Dan's space | 0 Comments Filed under: Analysis Services

• Large Dimension Processing issue - File system error

  A couple of weeks back I experienced an issue with a some what large dimension. The dimension had around 15.5MM rows and it continued to error while processing the key attribute within the dimension in Analysis Services (SSAS) 2008. I don’t believe this Read More... Posted Monday, May 11, 2009 1:21 PM from Dan's space | 0 Comments Filed under: Analysis Services

• Collecting Performance Data for SSAS 2008 – available on CodePlex

  I saw some of this demoed this past year at the MS BI Conference and it appears that it has now been released on CodePlex Check out the posting on the SQLCat team A Solution for Collecting Analysis Services Performance Data From Many Sources For Performance Read More... Posted Saturday, February 07, 2009 8:14 AM from Dan English's BI Blog | 0 Comments Filed under: Analysis Services

• SSAS Deployment Wizard Retaining Permissions

  Had a great question last week at the MNPASS SQL Server User Group in regards to using the Analysis Services Deployment Wizard and I just wanted to post the follow-up. I have read about the wizard, but actually have never used it (but you need to know Read More... Posted Sunday, July 20, 2008 8:37 AM from Dan English's BI Blog | 0 Comments Filed under: Analysis Services

• SSAS MDX Round = Banker's Rounding

  A couple of weeks ago I was working on a project where I had to implement some Ranking calculations within an Analysis Service (SSAS) cube. I went ahead and added in the calculations and then the client came back to me and stated that there was some additional Read More... Posted Saturday, April 19, 2008 8:10 AM from Dan English's BI Blog | 0 Comments Filed under: Analysis Services