ASSP - Analysis Services Stored Procedure Project
The Analysis Services Stored Procedure project is a set of sample stored procedures for Analysis Services 2005 and 2008. 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:
- To provide a set of useful extensions to Analysis Services 2005 and 2008.
- 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 |
| EfficientToDate | S | 1.0 | GetEfficientPeriodsToDateSet, GetMostGranularHierarchyCurrentMember |
| FindCurrentMembers | S | 1.0 | FindCurrentMember, FindCurrentMemberVerbose, FindCurrentType |
| Multiplication | S | 1.0 | Multiply |
| StringFilters | S | 1.0 | RegExFilter, Like |
| ListFunctions | U | 1.1 | ListFunctions |
| 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 |
| 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 |
| SQLQuery | U | 1.3 | ExecuteSQL |
| Drillthrough | S | 1.3 | GetDefaultDrillthroughMDX, GetCustomDrillthroughMDX, CurrentCellAttributes |
| Drillthrough | U | 1.3 | ExecuteDrillthroughAndFixColumns, GetMeasureGroupCalculatedMeasures |
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 InstructionsFor a list of other resources and links see: