Articles

From SSAS-WIKI
Jump to: navigation, search
Articles

There are hundreds of free articles on the web about SSAS. Most articles are of very good quality. The goal of this page is to organize them into a single "book". Please help us keep this "book" up to date!

Contents

[edit] SSAS Cube Design and Administration

[edit] Getting Started / Tutorials

[edit] Proactive Caching

[edit] Cache Warming

[edit] Killing SSAS Sessions

[edit] Microsoft SQL Server Community Code Samples

[edit] XMLA script

[edit] PowerShell

[edit] Processing

[edit] .Net stored procedure

[edit] Partitions

[edit] Write Back

[edit] Aggregations

[edit] Metadata

[edit] DMV (Dynamic Management View)

[edit] Actions

[edit] Analysis Management Objects (AMO)

[edit] Captions of calculated members

[edit] Displaying OLAP Data

[edit] Deployment

[edit] Backup and Restore

[edit] Detach and Attach Database

[edit] Connection String to SSAS

[edit] Connecting from SSAS to Oracle, Excel

[edit] Connecting from SSAS to Teradata

[edit] Sorting dimensional members

[edit] Connecting to SSAS from: SSIS, T-SQL, Java, Informatica

[edit] HTTP Access

[edit] Measure Formatting

[edit] Conditional formatting

[edit] Many-to-Many Dimension

[edit] Dimensional Attributes

[edit] Dimension Duplicate records

[edit] Attribute Discretization

[edit] Attribute Relationships

[edit] Default Member

[edit] Unknown Member

[edit] KPI

[edit] Statistics

[edit] Hierarchy

[edit] Distinct Count

[edit] Drillthrough

[edit] Local Cube

[edit] Parent-Child Dimension

[edit] Analysis Services Protocol Specification

[edit] Profiler, SSAS Server Trace and Performance Counters

[edit] Performance

[edit] What's New in SSAS 2008

[edit] Time Intelligence Wizard & Time Utility Dimension

[edit] Date Dimension

[edit] Unrelated dimensions

[edit] Storage Modes

[edit] Implementations & Case Studies

[edit] Tips

[edit] Reference Dimension

[edit] Dimensional Modeling

[edit] Market Basket Analysis

[edit] Memory

[edit] Load Balancing

[edit] Analysis Services Synchronization

[edit] Locks

[edit] Cell Annotations

[edit] Design - Other

[edit] Security

[edit] Kerberos

[edit] Measure Security

[edit] Cell Security

[edit] Testing Security

[edit] Custom Security

[edit] Dimension Security

[edit] Other

[edit] MDX

[edit] About MDX

[edit] MDX Tutorial

[edit] MDX Dynamic Sets

[edit] MDX Case When

[edit] MDX Multi-Select

[edit] MDX Count

[edit] MDX BottomCount()

[edit] MDX TopCount()

[edit] MDX Rank

[edit] MDX Member Properties

[edit] MDX Named Sets

[edit] MDX NonEmpty

[edit] MDX Existing

[edit] MDX Last Non Empty

[edit] MDX ITEM() function

[edit] MDX SCOPE

[edit] MDX Puzzles

[edit] MDX ParallelPeriod()

[edit] Time Intelligence

[edit] MDX Semi Additive Measures

[edit] MDX performance

[edit] MDX Subcube

[edit] MDX Subselect

[edit] MDX Ratio

[edit] MDX NextAnalytics

[edit] MDX Date Calculations

[edit] MDX Current Date

[edit] MDX Missing Members Mode

[edit] MDX Functions

[edit] MDX - Other

[edit] SSRS

[edit] SSRS Getting Started

[edit] SSRS Performance

[edit] SSRS Parameters

[edit] SSRS Date Picker

[edit] SSRS Drillthough

[edit] SSRS Parent-Child

[edit] SSRS Charts

[edit] SSRS Bugs and Errors

[edit] SSRS Report Builder

[edit] SSRS Report Model

[edit] SSRS - Other

[edit] Excel

[edit] Excel 2007

[edit] Excel 2010

[edit] Excel VBA

[edit] Excel Services

[edit] PowerPivot and DAX

[edit] Excel Other

[edit] PerformancePoint

[edit] ProClarity

[edit] PerformancePoint Server 2007

[edit] PerformancePoint Services 2010

[edit] Performance Point - Time Intelligence

[edit] PerformancePoint Services - Dashboard Designer

[edit] PerformancePoint Services - Web Parts

[edit] Data Mining

[edit] DMX

[edit] Third party data mining algorithms

[edit] Data Mining - Other