Sql Server Analysis Services Utils

  •        68

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...

http://ssasutils.codeplex.com/

Tags
Implementation
License
Platform

   




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.

Analysis Services Stored Procedure Project


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

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).

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.

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.

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: http://sig.biostr.washington.edu/projects/fm/AboutFM.html

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.

TSSASM


Using Transact SQL for browsing and managing Analysis Services 2005 Metadata

SQL Server Metadata Toolkit 2008


SQL Server Metadata Toolkit MSDN's SQL 2005 tool kit updated to 2008 for managing metadata in SQL Server Integration Services, Analysis Services and Reporting Services using built-in features including data lineage, business and technical metadata and impact analysis.

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.

Support Vector Machines Data Mining Plug-in in Analysis Services


The datamining Support Vector Machine (SVM) plug-in in MS SQL Server Analysis Services 2008. This plug-in is the SVM classification algorithm in addition to the shipped data mining algorithms with SQL Server.

SSAS AMO DB


SSAS AMO DB is a database version of AMO which helps to view the metadata stored in the SSAS cube. The Metadata will be loaded into a SQL Server database from the SSAS cube using AMO using SSIS package. From that database user can generate reports for the SSAS metadata. A da...

SQL Server Master Data Services Utilities


A set of useful add-ons for SQL Server Master Data Services, including utilities for generating an MDS model, loading the model, writing a custom UI for model data and integrating the model with SharePoint BCS.

SQL-Server-R-Services-Samples - Advanced analytics samples and templates using SQL Server R Services


In these examples, we will demonstrate how to develop and deploy end-to-end advanced analytics solutions with SQL Server 2016 R Services.Develop models in R IDE. SQL Server 2016 R services allows Data Scientists to develop solutions in an R IDE (such as RStudio, Visual Studio R Tools) with Open Source R or Microsoft R Server, using data residing in SQL Server, and computing done in-database.

ReportingServicesTools - Reporting Services Powershell Tools


This project contains PowerShell scripts that allows you to perform various operations with SQL Server Reporting Services. In order to use the scripts included in this project successfully, please download/clone the entire project as there are dependencies between the scripts.All of our scripts were written with the assumption that you will be executing them against SQL Server 2016 Reporting Services default instance (i.e. mssqlserver). However, we understand this may not be the case for you. So for each script, you will see that we have provided a way for you to specify the name and/or version of your SQL Server Reporting Services instance name. Sometimes the version of your SQL Server instance is also required. If you do not provide one, we will assume that you want to execute this against the default instance.

SQLCAT Community Projects and Code Samples


This project is a place for the SQL CAT team to share their expertise with the community and collaborate with other community members outside Microsoft who wish to contribute code samples to enable more productive use of the SQL Server platform for high-scale,enterprise customers

SQL Server Analysis Services Cube Status Web Part for SharePoint


The Cube Status project provides a SharePoint Web Part that connects to a SQL Server Analysis Services instance and shows the status of a specific cube

Index Analysis


Index Analysis allows DBAs and developers to analyze the indexes in a database to determine the use, characteristics, and statistics of the index. The project contains the query written in T-SQL and report that can be opened as a custom report in SSMS.