Skip to main content
insightsoftware Docs insightsoftware Docs
{%article.title%}
Published:
Was this article helpful?
0 out of 0 found this helpful

Referenced dimension setup

Overview

It is possible in Analysis Services to reference a dimension through another dimension. This way you can avoid creating a snowflake dimension or having to add the attributes to the data warehouse table as lookups.

Process

  1. Add the dimension you want to reference to the cube dimensions In this example we want to reference the Countries dimension to the Sales fact table through the Customers dimension

    Notice the added dimension is labeled 'Shell Dimension'. This is because no relationship to the fact table has been set up yet.'
  2. Set up reference to fact table through the Customers dimension

    We are referencing the Countries dimension to the fact table factSales through the Customers dimension on the dimension level Country in both dimensions

    ALWAYS tick Materialize .  Otherwise, the referenced dimension will be materialized on query time. This will have a huge negative impact on queries if the dimensions are large.

  3. The dimension will now be shown 'Referenced dimension' and no longer 'Shell dimension' because the dimension now has a relation to the fact table.

Published:

Referenced dimension setup

Overview

It is possible in Analysis Services to reference a dimension through another dimension. This way you can avoid creating a snowflake dimension or having to add the attributes to the data warehouse table as lookups.

Process

  1. Add the dimension you want to reference to the cube dimensions In this example we want to reference the Countries dimension to the Sales fact table through the Customers dimension

    Notice the added dimension is labeled 'Shell Dimension'. This is because no relationship to the fact table has been set up yet.'
  2. Set up reference to fact table through the Customers dimension

    We are referencing the Countries dimension to the fact table factSales through the Customers dimension on the dimension level Country in both dimensions

    ALWAYS tick Materialize .  Otherwise, the referenced dimension will be materialized on query time. This will have a huge negative impact on queries if the dimensions are large.

  3. The dimension will now be shown 'Referenced dimension' and no longer 'Shell dimension' because the dimension now has a relation to the fact table.

For an optimal Community experience, Please view on Desktop