The Date Dimension in Analysis Services

Data warehousing author and expert, Vincent Rainardi, brings us a new article that looks at one of the most frequently used dimensions in Analysis Services.

Attribute Member Values in Analysis Services

Learn how the appropriate use of attribute member Value can support the selection and delivery of enterprise data in a more focused and consumer-friendly manner. Join BI Architect Bill Pearson in a hands-on examination of the attribute member Value property and its underlying settings in Analysis Services.

Attribute Member Keys – Pt 1: Introduction and Simple Keys

Join Business Intelligence Architect Bill Pearson as he kicks off an exploration of Attribute Member Keys, a continuation of a body of articles surrounding significant components of the Analysis Services dimensional model. In this article we introduce Attribute Member Keys, focusing upon the simple keys and their properties.

How To Use the Analysis Services Execute DDL Task in SSIS 2005

We are looking to automate some tasks to be performed on our SQL Server Analysis Services Servers. Can you give us the details on how the Analysis Services Execute DDL Task can be used in a SQL Server Integration Services (SSIS) package?

SSAS Database Backup

Longtime SQL Server author Dinesh Asanka brings us a new article on backing up an Analysis Services database.

Intrinsic Member Properties: The MEMBER_KEY Property

Join BI Architect Bill Pearson in an introduction to the intrinsic MEMBER_KEY property. In hands-on exercises, we gain exposure to the use of the property in generating simple lists, as well as datasets to support report parameter picklists.

Many-to-Many Dimensions in Analysis Services 2005

See an example of using the Many-to-Many dimension in SQL Server 2005 Analysis Services to analyze sales data, and get ideas for other uses such as treating medical conditions, software testing, and more.

Slowly Changing Dimensions in SQL Server 2005

This article explores the options available in SQL Server 2005 for Slowly Changing Dimensions.

Analysis Services

Handling Data Integrity Issues in Analysis Services 2005

Learn about common data integrity issues, and see how Analysis Services 2005 gives you the tools to handle them.