SQLServerCentral.com Articles tagged Dimensions

Managing Slowly Changing Dimension with Slow Changing Transformation in SSIS

Tue, 07 May 2013 06:00:00 UT

The easiest ways to maintain and manage slowly changing dimensions is using Slowly Changing Dimension Transformation in the data flow task of SSIS packages.

MDX Guide for SQL Folks: Part III - Advanced Analysis

Thu, 14 Feb 2013 07:00:00 UT

Learn everything about MDX drawing only on your T-SQL knowledge in this series. Frank Banin continues talking about Calculated Members, Named Sets, and more in part III.

MDX Guide for SQL Folks: Part II - Hierarchies and Functions

Tue, 18 Dec 2012 07:00:00 UT

Learn everything about MDX by drawing only on your SQL knowledge.

MDX Guide for SQL Folks: Part I - Navigating The Cube

Thu, 01 Nov 2012 06:00:00 UT

Learn all you need to know about MDX, by drawing only on your current SQL knowledge.

Introduction to Dimension Security in SQL Server Analysis Services SSAS 2005

Tue, 15 Sep 2009 06:00:00 UT

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?

Script dimensions using Windows PowerShell and AMO

Fri, 01 May 2009 06:00:00 UT

Part 11 of our series on "Microsoft Windows PowerShell and SQL Server 2008 AMO" discusses how to generate a script for given dimension of the Analysis Service database to XMLA format file.

Process Dimensions in an Analysis Service database

Wed, 11 Mar 2009 06:00:00 UT

Continuing our series on our "Microsoft Windows PowerShell and SQL Server 2008 AMO," Part 8 covers how to process a dimension in an Analysis Service database using Windows PowerShell and SQL Server 2008 AMO.

Date Dimensions Part 2

Wed, 18 Feb 2009 07:00:00 UT

Continuing with his discussion of how to implement a date dimension in SQL Server Analysis services, expert warehousing expert Vincent Rainardi discusses how to use this dimension as a reference dimension as well as other advanced topics.

The Date Dimension in Analysis Services

Fri, 28 Nov 2008 07:00:00 UT

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.

MSSQL Analysis Services - Attribute Member Names

Fri, 24 Oct 2008 06:00:00 UT

Business Intelligence Architect Bill Pearson continues his exploration of Attribute Members, in another member of a subseries surrounding significant components of the Analysis Services dimensional model. In this article we examine the attribute member Name property, whose appropriate use is important to good model design and overall system performance.

Parent-child dimensions in SQL Server 2005

Fri, 10 Oct 2008 06:00:00 UT

Retrieving a hierarchy with recursive relationships can be difficult in SQL. Easily implement these relationships with a parent-child dimension using Analysis Services MDX.

Want faster, smaller backups you can rely on?
Use SQL Backup Pro for up to 95% compression, faster file transfer and integrated DBCC CHECKDB. Download a free trial now.

Attribute Member Keys – Pt 1: Introduction and Simple Keys

Fri, 12 Sep 2008 06:00:00 UT

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.

Many-to-Many Dimensions in Analysis Services 2005

Fri, 27 Jun 2008 06:00:00 UT

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.

Dimension Attributes: Introduction and Overview, Part III

Thu, 29 May 2008 06:00:00 UT

Join Business Intelligence Architect Bill Pearson as he continues his subseries surrounding components of the Analysis Services dimensional model. In this article we continue our introduction to dimension attributes, focusing upon the Misc group of attribute properties.