Warnings in SSAS Cubes

In this article, I’m going to list out some of the most common warnings we encounter while developing SSAS Cubes and the reason for those warnings. As you are aware, SSAS cubes are developed using the SQL Server Data Tools (SSDT) for Analysis Services (Visual Studio), all the examples will be taken from Visual Studio 2017 only.

The warnings that I’m going to explain in this article are listed as follows:

  1. Define attribute relationships as ‘Rigid’ where appropriate
  2. Create hierarchies in non-parent child dimensions
  3. Avoid visible attribute hierarchies for attributes used as levels in user-defined hierarchies
  4. The database has no Time dimension. Consider creating one
  5. Do not ignore duplicate key errors. Change the KeyDuplicate property of the error configuration so that it is not set to IgnoreError
  6. Attribute relationships do not exist between one or more levels of this hierarchy. This may result in decreased query performance

To read further, please find the original content on https://www.sqlshack.com/warnings-in-ssas-cubes/

Published by Aveek

Aveek has been working as an Analytics Engineer for the past couple of years now. His main areas of interests is SQL Server, SSIS, and SSAS.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s