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:
- Define attribute relationships as ‘Rigid’ where appropriate
- Create hierarchies in non-parent child dimensions
- Avoid visible attribute hierarchies for attributes used as levels in user-defined hierarchies
- The database has no Time dimension. Consider creating one
- Do not ignore duplicate key errors. Change the KeyDuplicate property of the error configuration so that it is not set to IgnoreError
- 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/