ASSP - Analysis Services Stored Procedure Project

The Analysis Services Stored Procedure project is a set of sample stored procedures for Analysis Services 2005, 2008, 2008 R2, and 2012. These samples have been written in C# and sample MDX queries are included that demonstrate the use of the procedures against the Adventure Works DW sample database. It was developed by a group of community volunteers with 2 main aims in mind:
  1. To provide a set of useful extensions to Analysis Services 2005 and higher.
  2. To provide a variety of example source code for people looking to write their own stored procedures.

The project currently contains the following samples:

Class Permissions Version Functions
AsymmetricSet S 1.0 AsymmetricSet
CellTimings S 1.0 TimeToCalculate
CubeInfo U 1.0 GetCubeLastProcessedDate
CubeInfo U 1.3 GetMeasureGroupLastProcessedDate
CubeInfo U 1.3.7 GetLastProcessedDateOverPartitions
EfficientToDate S 1.0 GetEfficientPeriodsToDateSet, GetMostGranularHierarchyCurrentMember
FindCurrentMembers S 1.0 FindCurrentMember, FindCurrentMemberVerbose, FindCurrentTuple
Multiplication S 1.0 Multiply
StringFilters S 1.0 RegExFilter, Like
ListFunctions U 1.1 ListFunctions
ListFunctions U 1.3.5 AssemblyVersion
SetOperations S 1.1 Order, ReverseSet, RandomSample, InverseHierarchility, AsymmetricDrillDown
SetOperations S 1.3 TopCountWithTies, BottomCountWithTies
Parallel S 1.1 Parallel
LinkMember S 1.1 HierarchyLinkMember, LevelLinkMember
ClusterNaming U 1.1 AutoNameClusters, DistinguishingCharacteristicsForClusters
Partition U 1.1 CreatePartitions
Partition U 1.3 CreateDistinctCountPartitions, CreateStringDistinctCountPartitions
XmlaDiscover U 1.1 Discover, ClearCache, Cancel, DiscoverXmlMetaData
XmlaDiscover U 1.2 DMV
XmlaDiscover U 1.3 DiscoverSingleValue, DiscoverXmlMetadataSingleValue, DMVSingleValue
XmlaDiscover U 1.3.7 ForEachMeasureGroup, ForEachPartition
MemoryUsage U 1.1 SnapshotMemoryUsageTotals
DimensionHealthCheck U 1.1 ListDimensionErrors, ListDimensionsWithErrors
StrToSet S 1.2 KeysStrToSet, CompositeKeysStrToSet
PartitionHealthCheck U 1.2 DiscoverPartitionSlices
FileSystemCache U 1.3 ClearFileSystemCache, GetFileSystemCacheBytes
FileSystemCache U 1.3.5 ClearAllCaches
SQLQuery U 1.3 ExecuteSQL
Drillthrough S 1.3 GetDefaultDrillthroughMDX, GetCustomDrillthroughMDX, CurrentCellAttributes
Drillthrough U 1.3 ExecuteDrillthroughAndFixColumns, GetMeasureGroupCalculatedMeasures
TraceEvent S 1.3.6 FireTraceEventAndReturnValue
Percentiles S 1.3.7 ValueAtPercentile, RangePoint
CurrentCommand U 1.3.7 CurrentCommandIsDiscover, GetCurrentCommand

Permissions: denotes the minimum required permissions level for the function in the class to work. If you deploy the assembly with a lower permission level than that required by a given function, that function will simply throw a security exception when you attempt to execute it, all the other functions will execute normally.
  • S - Safe
  • U - Unrestricted

Version: denotes the initial release version for the class.

For details on how to install the compiled release see the Installation Instructions

For a list of other resources and links see:

Last edited Nov 4 at 7:55 PM by dgosbell, version 45