Analysis Services Stored Procedure Project

  •        0

A set of stored procedures for Microsoft SQL Server Analysis Services.



Related Projects

Microsoft SQL Server Community Samples: Analysis Services

This project contains SQL Server Analysis Services samples contributed by Microsoft outside of the regular release cycle, MVPs, and other members of the community.

Sql Server Analysis Services Utils

SQL Server Analysis Services Utilities. The initial code just contains a form to get your dimensions and paritions and process them (although it is not async - something that would be cool to add though!). Figured it would be good to start a project to get any and all SSAS AMO...

BIDS Helper

A Visual Studio add-in with features that extend and enhance business intelligence development functionality in SQL Server 2005, 2008, and 2008 R2 BI Development Studio (BIDS) and SQL Server 2012 SQL Server Data Tools (SSDT).

Analysis Services Parent-Child Dimension Naturalizer

Parent/Child dimensions, wherein each member references the ID of its parent member rather than being specified on a specific level of a hierarchy, are often a cause for poor performance in Analysis Services databases. One way of dealing with this is to convert a poorly perfor...

Drilltrough and filtering on SSAS-cubes in SSRS

We will describe a technique to create Reporting services (SSRS) reports that use Analysis services (SSAS) cubes as data sources, have a very intuitive interface and take full advantage of SSAS performance optimization features.

SSAS Query Log Decoder & Analyzer

The Crisp description for the project will be "CUBE FOR CUBE". This is an end-to-end BI solution for analyzing the Query log created by SSAS Server. The Query Log data is loaded into a dimensional model and a cube is built on top of it for analysis of cube usage.

SSAS Entity Framework Provider community FAQ and online support documentation

This project is for SSAS Entity Framework Provider community FAQ and other community online support documentation (see Documentation tab > FAQ). SSAS Entity Framework Provider enables you to use LINQ and Microsoft ADO.NET Entity Framework to query SQL Server Analysis Servic...

Analysis Services Helper - SSMS Addin

The Analysis Services Helper is an add-in for SQL Server Management Studio that helps users with repetitive tasks involved with Analysis Services such as processing and deployment. It's developed in C# .Net 2.0, and tested with SSMS 2008 R2.

Build-Mobile-App-with-Chat - The tutorial uses several Azure services to power a real-time chat infrastructure that is readymade for analytics

Real-time chat is engrained into our expectations of everyday business communication. Applying sentiment analysis to the chat messages as the flow between users can help unlock actionable insights that would otherwise be require a human monitoring all chat conversations.The Sentiment Analysis for Real-Time Chat Tutorial demonstrates the application of Microsoft Cognitive Services sentiment analysis as chat messages flow between web-based clients, enabling immediate visualization of sentiment in the chat clients and in Power BI dashboards that update in real time.

ASSP - Anti-Spam SMTP Proxy

ASSP is a SMTP proxy which sits between SMTP server and the MTA. It filers the spam and delivers the legtimate mails to the MTA. Its feature include Bayesian analysis, Sender Policy Framework) validation and blocking, Realtime Blackhole Listing, URL Black Listing, Multi-level attachment blocking, LDAP support, Backscatter Detection, SNMP support and lot more.

OLAP PivotTable Extensions

An Excel 2007, Excel 2010, and Excel 2013 add-in which extends the functionality of PivotTables on Analysis Services cubes.

FMA Human Body- Analysis Services 2008 Cube

The Foundational Model of Anatomy ontology (FMA) is OPEN SOURCE and available for use. This Project is a conversion to a MSAS 2008 cube. It is intended to be used for quick study by Med Students. Link for project:


Using Transact SQL for browsing and managing Analysis Services 2005 Metadata

SSAS Profiler Trace Collector with Scheduling Facility

AS Profiler Scheduler is a tool that will enable Scheduling of SQL AS Tracing using predefined Profiler Templates. For tracking different issues there are different templates.


Vulcan is a Business Intelligence Framework built on top of Sql Server Integration Services and Sql Server Analysis Services for quickly creating BI solutions.

OpenI: OLAP Data Visualization Plugin

OpenI plugin for Pentaho CE provides a simple and clean user interface to visualize data in OLAP cubes. It supports both direct Mondrian and xmla based connections like Microsoft SQL Server Analysis Services (SSAS), plus provides add-on features like Explore Cube Data, custom SQL for drillthrough data, publishing drillthrough data to external web services etc.


Utility for processing multiple Analysis Services (SSAS) databases in parallel.

MDX Parser,Builder,DOM and OLAP visual controls with Writeback for Silverlight

It is component library for OLAP, .NET & Silverlight (C#). * MDX DOM, Parser, Generator, Query Designer * Description of supported MDX Syntax * Dynamic Pivot Grid - Pivot Table with Writeback * OLAP metadata choice controls See also:

SSAS Operations Templates

SSAS Operations Templates includes SSIS packages, scripts and code samples for automating maintenance of SSAS in a production environment. Includes operations such as backup the current state of cube designs in production, scripting paritition creation, etc.