SSAS: Analysis Services Stored Procedure Project (ASSP) 1.1 release is out!

It's been a little while since we did the initial release of ASSP, but things have been bubbling along quietly in the background and today we pushed out another release which in addition to a few minor fixes includes the following new features.

  • ListFunctions - This is cool on a couple of fronts (and not just because it is one of mine :) )  Firstly it is practical because it will list all the available functions in all the .Net assemblies that have been registered either at the server or, if you pass in a database name, at the database level. Secondly it demonstrates how to reconstruct an assembly from the encoded "chunks" that you get back from AMO or a DISCOVER_XML_METADATA command.
  • Parallel - A couple of functions, a generate and a filter that can execute in parallel. And in certain circumstances they can out perform the standard functions, despite the fact that they open up separate connections to achieve this.
  • LinkMember - The built in LinkMember function often does not return the member you were expecting. The functions in this class work around a few of the limitations in the built-in functions.
  • ClusterNaming - A great one if you are using the data mining cluster algorithm. This function will automatically generate meaningful cluster names based on the profile of the data in each cluster.
  • Partition - Will automatically generate partitions based on a given set of members. Great for quickly testing various different partitioning strategies.
  • XmlaDiscover - Another one of mine. Running the standard discover commands let you find out a great deal about your SSAS server and databases, but the XML data is not really easy read or write SSRS reports against in it's raw form. These functions take the output of the XMLA discover commands and return them as .Net data tables, which can be viewed in SSMS and easily reported against with SSRS.
  • MemoryUsage - This is an amazing piece of work. It will take the output of the XMLA DISCOVER_MEMORYUSAGE command, creates a cube on the fly using AMO and then uses the "push" processing model to insert the data from the discover command into the cube. This is a fantastic sample, well work checking out.
  • DimensionHealthCheck - This function leverages off the work done in BIDSHelper, where this feature is interactive, to provide a stored procedure version so that you can check the "health" of your dimensions using an SSRS report.

Print | posted on Sunday, June 24, 2007 10:32 PM