Analysis Services (SSAS)

Article

I have seen the tip Dynamically Control Data Filtering in SQL Server Reporting Services Reports which showed how to leverage a SQL Server database table to filter sales data based on the user running the report. I have a similar requirement to implement dynamic filtering except my data is in a SQL Server Analysis Services (SSAS) cube and the users query the data with a variety of different tools. How can I implement dynamic security in my case?

2009-09-15

2,770 reads

SQL Server Analysis Services ( SSAS ) - Introduction

by Additional Articles

SQL Server Performance

Analysis Services (SSAS)

Article

Microsoft SQL Server 2005 Analysis Services (SSAS) delivers both online analytical processing (OLAP) and data mining functionality for business intelligence applications. This article thoroughly explores the architecture of SSAS and how it can be implemented.

2009-08-28

3,915 reads

Simple Doughnut Chart for Analysis Services Data

by Additional Articles

Database Journal

Analysis Services (SSAS)

Article

Architect Bill Pearson leads the hands-on creation of a simple doughnut chart based upon an Analysis Services data source.

2009-08-07

3,212 reads

SQL Server 2008 Analysis Services Performance Guide

by Additional Articles

Microsoft MSDN

Analysis Services (SSAS)

Article

Because Microsoft SQL Server Analysis Services query and processing performance tuning is a fairly broad subject, this white paper organizes performance tuning techniques into the following three segments.

2009-08-04

2,866 reads

Creating and managing Analysis Services partitions

by Additional Articles

SearchSQLServer

Analysis Services (SSAS)

Article

S partitions from the ground up, with advice on binding, merging, and selecting partition data.

2009-07-30

2,636 reads

Storage Modes in SSAS (MOLAP, ROLAP and HOLAP)

by Additional Articles

SQL Server Performance

Analysis Services (SSAS)

Article

There are three standard storage modes (MOLAP, ROLAP and HOLAP) in OLAP applications which affect the performance of OLAP queries and cube processing, storage requirements and also determine storage locations.

2009-07-29

2,524 reads

Exploded Pie Chart for Analysis Services Data

by Additional Articles

Database Journal

Analysis Services (SSAS)

Article

MSAS Architect Bill Pearson leads the hands-on creation of an exploded pie chart based upon an Analysis Service data source.

2009-07-16

2,446 reads

How To Enable User-Defined Hierarchies in SQL Server Analysis Services (SSAS)

by Additional Articles

MSSQLTips.com

Analysis Services (SSAS)

Article

I have a requirement to provide users with the capability to define their own reporting hierarchies for sales data. For instance they had a report which broke down sales by the four regional VPs then by office. Later they created regions, assigned VPs to each region, then assigned offices to each VP. Now they want to be able to create a number of other scenarios and choose which one when they run a report. Can you provide some suggestions on how to do this?

2009-07-10

3,043 reads

Stacked Bar Chart for Analysis Services Data

by Additional Articles

Database Journal

Analysis Services (SSAS)

Article

Put the stacked bar chart to work in your own business environment. BI Architect Bill Pearson continues his hands-on introduction to Reporting Services charts based upon Analysis Services data sources.

2009-06-05

2,178 reads

Overview of the Analysis Services Development and Management Environments

by Additional Articles

TDAN

Analysis Services (SSAS)

Article

SQL Server 2005 introduces a rich set of tools supporting the development and management of Business Intelligence applications. This includes applications using Analysis Services (OLAP and Data Mining), as well as Reporting Services and Data Transformation Services (DTS).

2009-05-22

2,254 reads

Analysis Services (SSAS)

Introduction to Dimension Security in SQL Server Analysis Services SSAS 2005

SQL Server Analysis Services ( SSAS ) - Introduction

Simple Doughnut Chart for Analysis Services Data

SQL Server 2008 Analysis Services Performance Guide

Creating and managing Analysis Services partitions

Storage Modes in SSAS (MOLAP, ROLAP and HOLAP)

Exploded Pie Chart for Analysis Services Data

How To Enable User-Defined Hierarchies in SQL Server Analysis Services (SSAS)

Stacked Bar Chart for Analysis Services Data

Overview of the Analysis Services Development and Management Environments

Blogs

Advice I Like: Experience and Aptitude

Plan Time for Self-Development

BK’s Bookshelf: Never Split the Difference

Forums

Insiders Selling Data

Join 2 tables

Impact of Not Including Foreign Keys in an SQL Archive Database

Question of the Day

Quiesce