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

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[edit]