OLAP

04/05/05

Below are links and resources for Olap and Data Warehousing that are quite beneficial for this type of work.

OLAP Links

Below are various links to online resources on Olap.

Microsoft SQL Server 2000 Analysis Services Performance Guide
An excellent compiled guide on improving the performance of Analysis Services 2000.

Analysis Services Specifications and Limits
Note: while 128 dimensions is the upper bound, may not want to put more than 20-25 dimensions per cube – depending on cardinality and size.

DSO Enumeration
Reference for the back-end manipulation of Olap objects via Decision Support Objects.

ADO MD
Reference for the middle-tier viewing of Olap data via ActiveX Data Objects: Multi-Dimensional objects.

Distinct Count Reference

Analyzing and Optimizing Performance

Monitoring Analysis Services Performance

Increase repository timeout

AS2k Shut Down Issue

Incremental Update Issue

Troubleshooting Olap I

Troubleshooting Olap II

OLAP Server Stops Responding When Data Files are Corrupted

Performance Problem Restoring Olap dB to a repository with many objects

Analysis Services 64-bit

Registry settings for Olap

Enable Olap to use 3Gb

Performance Tuning Olap

How to use ADOMD to return out of process cellset

How to chart MDX results with Office Web Components

MDX: How to obtain Current Day with a MDX query or Expression in SQL Server 2000 Analysis Services

MDX: How to determine the first and last member with data

MDX: How to Query for the 10 Best Customers and the Top 5 Products for Each Customer

Data Warehousing Links

Below are various links to online resources on Data Mining and Data Warehousing.

SQL Server Data Mining Programmability
SQL Server 2005 Programming of Data Mining objects.

Business Intelligence and Data Warehousing
SQL Server portal site with plenty of links on SQL Server, scalabilty and reliability, Analysis Services, and Data Mining.

DTS Looping, Importing, and Archiving
A great resource to explain how to perform loops with Data Transformation Services.

Umachandar's Home Page
Excellent resource of SQL tips and technical resources from an excellent SQL architect and developer.

SQL Server 2000 Resource Kit

SQL Server Update Statitics tips

How to overcome the 32Kb limit for SQL expressions

Microsoft BizTalk Accelerator

Path Analysis

Programming Links

Beginning C Tutorial

Visual C# Tutorial and Samples

Presentation and Papers

Below are presentations and papers for Olap, Data Warehousing, and Data Mining.

Enterprise OLAP 32-bit Analytics
This is a power point presentation based on my 2003 and 2004 slides at the PASS conference.

OLAP mdErr Error Codes
This is an Excel spreadsheet enumerating the types of errors from Analysis Services.

Troubleshooting Olap
This is a compilation of Olap issues seen in production with their resolutions.

Other References

Below are other good references to read up on Olap, Data Warehousing, and Data Mining.

Professional SQL Server 2000 Data Warehousing with Analysis Services, Wrox Press, ISBN: 1861005407

Olap Public Newsgroup
Microsoft.public.sqlserver.olap

Home | OLAP | Favorites | Gallery | Informatics

This site was last updated 04/04/05