Analysis Services Dimensions

Learn the step by step process to enable localization support for SQL Server Analysis Services dimension attributes.

Why do I need to create attribute relationships in my SQL Server Analysis Services Cubes and how do I create them? What are some common data sets to create attribute relationships on in SSAS? How do you create attribute relationships in SQL Server Analy

What is the difference between the KeyColumn, the NameColumn, and the ValueColumn for a dimension attribute in SQL Server Analysis Services? How do they affect the data presented to the end user? When should you use the KeyColumn, the NameColumn, and th

SQL Server Analysis Services – SSAS – sorts dimension attributes alphabetically by default. The tip Change Sort Options on Dimension Attributes in SQL Server Analysis Services explains how you can change this sort order by adjusting the key columns and by

The source table or view for my cube requires some structural changes including data type and data lengths. How does this affect my SSAS Data Source View (DSV) and ultimately my cube?

By default, SQL Server Analysis Services will sort and display dimension attribute values in alphabetical order. When displaying the days of the week or the months of the year (as shown below), we often want to see the data in chronological order instead

What is discretization and how is it used in SQL Server Analysis Services? What are its advantage and disadvantages? In this tip we cover this topic and show the various options.

In the webinar I presented entitled Taking on your First SQL Server Business Intelligence Project, a couple of questions from the audience asked about defining and reusing dimensions, particularly the date dimension. These reusable dimensions are also kno

SQL Server introduced a great feature for improving the processing time and reducing storage requirements in the form of Role Playing Dimensions. Unfortunately one of the drawbacks is that those dimensions do not support custom attribute names for differe

SSAS includes Time, Account, and Dimension Business Intelligence Wizards. In this tip we cover what these functions do and how they could be used.

There is not much documentation about how to do a ProcessAdd for a dimension in SSAS (SQL Server Analysis Services). Doing a ProcessAdd for a partition is pretty easy, but there is not much documentation to do a ProcessAdd for a dimension. The SSAS docum

How can you copy dimensions from one SQL Server Analysis Services (SSAS) Project to another? Are there any options to do so? This tip is for SQL Server BI Professionals who need to copy dimensions from one SSAS project to another. I will outline three a

In a parent child dimension, when an attribute's usage type is set as Parent and browsed from a client tool, many designers as well as users may get confused base on the displayed results.

While browsing a cube, if you are using a dimension and fact that are not related, the result can be quite confusing as the results appear as repeating values across all columns and/or rows depending upon the query. The repeating values are sliced or non-

We are building an Analysis Services cube and trying to understand how to create a time dimension and take advantage of the built-in time intelligence features that provide many useful calculations such as period-to-date, period-over-period growth, etc.

Our business users want to report on some fact data aggregated by week. They define a week as beginning on Sunday and ending on Saturday without regard to the year. An example query would be how many employees were hired in each of the previous four wee