Create a Dimension using Dimension Wizard in SSAS

Recommended by 0 users

Dimension Wizard

–> This wizard is useful to add, remove dimensions and their relationships.

–> We can add dimensions to another dimension (or) measure group table.

Relationship Types:

1. No Relationship

2. Regular

3. Fact

4. Referenced

5. Many-to-Many

6. Data mining

No Relationship:

–> The dimension and measure group are not related.

–> The dimension available in the cube but at the times of analysis it doesn’t participate with it’s values.


Ex:  Removing the relationship between product dimensions and measure group table.


Deploy, Go To Browser and Analysis now the product dimension doesn’t participate in analysis.

Regular Relationship

–> Here dimension adds to a measure group table directly. (Generally represents ‘Star Schema’ structure)

–> When we are going to this, we should have proper key relationships between dimension & FACT.

Eg: Adding product dimension to the measure group table.


Measure Group:

Product ID –   –> CLICK –>

Select Relationship Type : Regular

Granularity Atribute : PRODUCT ID

Dimension Table : PRODUCT

Measure Group Table : TEXT_FACT

Dimensions Columns                                     Measure Group Columns

Product ID                                                                   Product ID


Deploy –> Go To Browser & analyse, now product table participates in the analysis.

Referenced Relationship

–> The dimension table is joined to an intermediate dimension table, which in trun, is joined to the font table.

–> It provides the ‘Snow Flake’ schema type of structure.

–> We require approximate column references between suitable to main tbale.


Eg: Connecting sub product dimension to a product dimension.

Sub Product ID  –  –> CLICK –>

Selection Relationship type : Reference

Reference Dimension : Product

Intermediate Dimension: RAW SUBPRODUCT

Reference Dimension Attribute : Product ID

Intermediate Dimension Attribute : Subproduct ID



Fact Relationship

–> The dimension is the fact table here.

–> Generally textual information represents dimension information and numeric information represents fact information in this table.

–> These types of cubes are called “Standalone Cubes”.


Many – To – Many Relationship

–> The dimension table is joined to an intermediate fact table. The intermediate fact table is joined, inurn, to an intermediate dimension table table to which the fact table is joined.


Data Mining Relationship

–> The target dimension is based on a mining model built from the source dimension.

The source dimension must also be included in the cube.


Enroll for Instructor Led Live MSBI Training


0 Responses on Create a Dimension using Dimension Wizard in SSAS"

Leave a Message

Your email address will not be published. Required fields are marked *

Copy Rights Reserved © Mindmajix.com All rights reserved. Disclaimer.
Course Adviser

Fill your details, course adviser will reach you.