Browse by Tags

• .NET
• Adventure Works
• ASSP
• bids
• BIDS Helper
• cache
• create cache
• cube
• Development & Programming
• Discover
• dmv
• Manageability & Serviceability
• Manageability &amp
• mdx
• memory
• metadata
• performance
• Performance and Scalability
• powershell
• PowerSSAS
• process
• query performance
• Reliability and Availability
• Sample Install
• server
• Serviceability
• SQL Analysis Service
• SQL Server
• SQL Server 2005
• SQL Server 2008
• transaction
• XMLA

• Error 2738 while trying to install Adventure Works BI sample on Vista

  When trying to install the Adventure Works 2008 sample database on my new SQL Server 2008 instance I very quickly got a message box about the installation failing with an error of 2738. For some reason this sounded familiar and sure enough a quick search Read More... Posted Wednesday, August 20, 2008 4:08 PM from Darren Gosbell [MVP] - Random Procrastination | (Comments Off) Filed under: Analysis Services, SQL Server, Adventure Works, Sample Install

• BIDS Helper 1.3 Released (now with support for SQL 2008)

  I am pleased to announce that the BIDS Helper team have just released v1.3 which is our first release with support for SQL Server 2008. With these release we have also improved our international support. All of the features in BIDS Helper still only display Read More... Posted Saturday, August 16, 2008 9:51 PM from Darren Gosbell [MVP] - Random Procrastination | (Comments Off) Filed under: Analysis Services, SQL Server, SQL Server 2008, SQL Server 2005, BIDS Helper

• VS.NET 2008 SP1 is available

  The download for VS.NET 2008 SP1 is available now: http://msdn.microsoft.com/en-au/vstudio/cc533448.aspx . This should fix the issue with running BIDS for SQL Server 2008 and VS.NET 2008 . I'm downloading just downloaded it - it's tiny at about 500Kb, Read More... Posted Tuesday, August 12, 2008 8:03 AM from Darren Gosbell [MVP] - Random Procrastination | (Comments Off) Filed under: Analysis Services, SQL Server

• SQL Server 2008 has been released, but some BI developers will need to wait...

  For those of use with MSDN or Technet subscriptions, SQL Server 2008 is available for download now and you have probably heard this from multiple sources already. (is there an echo in here?) But for anyone that wants to work with the BI tools and who Read More... Posted Friday, August 08, 2008 7:08 AM from Darren Gosbell [MVP] - Random Procrastination | (Comments Off) Filed under: Analysis Services, SQL Server, SQL Server 2008, bids

• SSAS: Scripting out a Process command

  I had a comment recently on one of my older posts (which was about processing a cube with XMLA ) asking how I scripted out the process command from SQL Server Management Studio. It is much easier to explain this with pictures than with words alone, hence Read More... Posted Sunday, July 27, 2008 9:49 PM from Darren Gosbell [MVP] - Random Procrastination | (Comments Off) Filed under: Analysis Services

• MDX ratio of "current parent" issue

  Every now and then on the SSAS MSDN forum , the issue of doing a generic "ratio to parent" calculation comes up. Unfortunately there are a number of problems with the premise of giving users a generic "ratio to parent" measure. The first is that the concept Read More... Posted Saturday, July 26, 2008 10:18 AM from Darren Gosbell [MVP] - Random Procrastination | (Comments Off) Filed under: Analysis Services, mdx

• A Rose by any other name - MDX Formatting

  A little while ago Jamie posted about how he formats SQL code which happens to be quite similar to the way I do it. But this then lead me to think about the equivalent formatting for MDX. So if I get MDX like the following: with member measures.ptd as Read More... Posted Sunday, June 15, 2008 10:52 PM from Darren Gosbell [MVP] - Random Procrastination | (Comments Off) Filed under: Analysis Services, mdx

• SSAS: Reporting on Metadata

  I had a comment recently on one of my older posts that I did about XMLA which asked about listing cubes in a database and whether the cube is processed and it's size. I have posted about a number of different ways of doing this over the last few years, Read More... Posted Tuesday, May 06, 2008 10:08 AM from Darren Gosbell [MVP] - Random Procrastination | (Comments Off) Filed under: powershell, Analysis Services, metadata, XMLA

• powerSSAS: Listing Role information

  After my last post on how to list the aggregations for a given attribute using Powershell and PowerSSAS , miltruenos commented, asked if it was possible to do a similar script to show roles and allowed/denied sets, so here is just such a script. add-PSSnapin Read More... Posted Thursday, May 01, 2008 10:29 PM from Darren Gosbell [MVP] - Random Procrastination | (Comments Off) Filed under: powershell, Analysis Services

• powerSSAS: Getting Aggregations for a particular Attribute

  If you have ever manually edited aggregation designs, you may have wondered what aggregation currently exist for a particular attribute. Well the following powerSSAS script will give you just that. (you could do this with straight PowerShell, but powerSSAS Read More... Posted Sunday, April 27, 2008 10:46 PM from Darren Gosbell [MVP] - Random Procrastination | (Comments Off) Filed under: powershell, Analysis Services

• Using PowerShell to update the case of Attribute names

  I had a question recently about how to quickly convert all the attributes in a given database from UPPER CASE to Title Case. Now you could certainly write a C# or VB.Net based program, but I feel that a script is the way to go for a once off requirement Read More... Posted Sunday, March 16, 2008 11:01 PM from Darren Gosbell [MVP] - Random Procrastination | (Comments Off) Filed under: powershell, Analysis Services, .NET

• Analysis Services Team Update posting on the MSDN forum

  I just spotted an interesting post on the Analysis Services forum . It was titled "Analysis Services Team Update" and was posted by Ariel Netz, Group Program Manager for Analysis Services. He starts off with .. "I could never understand people’s fascination Read More... Posted Wednesday, March 12, 2008 8:03 PM from Darren Gosbell [MVP] - Random Procrastination | (Comments Off) Filed under: Analysis Services

• SSAS 2008 - small DMV improvement

  I was just checking the DMVs in SSAS 2008 CTP6 to see if they had changed between CPT5 & 6. Particularly in regard to the list of limitations that Vidas posted . As far as I can tell the only thing that appears to have changed is that "SELECT DISTINCT" Read More... Posted Friday, February 22, 2008 8:21 AM from Darren Gosbell [MVP] - Random Procrastination | (Comments Off) Filed under: Analysis Services, dmv

• Building a better DMV

  Following along on my recent theme of exploring the metadata rowsets and the new Dynamic Management Views (DMV) in SSAS 2008. I have added a new DMV function to the Analysis Services Stored Procedure project ( www.codeplex.com/ASStoredProcedures ) which Read More... Posted Wednesday, January 30, 2008 9:45 PM from Darren Gosbell [MVP] - Random Procrastination | (Comments Off) Filed under: Analysis Services, dmv, mdx, ASSP, Discover

• SSAS: Acquiring Locks using XML/A from SSMS - Part 2

  Mosha commented on my last post on this topic that there was another simpler way of doing the same thing from SSMS. And that is to execute the following commands from an MDX window. First run ... < BeginTransaction xmlns ="http://schemas.microsoft.com/analysisservices/2003/engine" Read More... Posted Thursday, January 24, 2008 3:07 AM from Darren Gosbell [MVP] - Random Procrastination | (Comments Off) Filed under: Analysis Services, XMLA