Browse by Tags

• Analysis Services
• metadata
• powershell
• transaction

• SSAS: Are my Aggregations processed?

  You have designed Aggregations for your cube, but how do you know that they are currently processed? Hopefully you have your processing routines setup in production so that your indexes are always kept processed. But maybe you are working in a development Read More... Posted Tuesday, December 02, 2008 9:17 PM from Darren Gosbell [MVP] - Random Procrastination | (Comments Off) Filed under: powershell, Analysis Services, XMLA

• 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

• 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

• SSAS: Acquiring Locks using XML/A from SSMS

  I put the following code sample together in response to this question on the Analysis Services forum . If you read Books Online, you might think that running the following statement in SSMS would work : < Lock xmlns = " http://schemas.microsoft.com/analysisservices/2003/engine Read More... Posted Sunday, January 13, 2008 10:28 PM from Darren Gosbell [MVP] - Random Procrastination | (Comments Off) Filed under: Analysis Services, transaction, XMLA