Home  >  Blog  >   MSBI  > 

Create a Dimension using Dimension Wizard in SSAS

Dimensions in SSAS are collections of characteristics defined by columns from tables or views in a data source view. We have explored the numerous relationships that dimension wizard makes use of.

Rating: 5
  1. Share:
MSBI Articles

Dimension Wizard

–> This wizard is used 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 in its values.
 Fact- Dimension
Ex:  Removing the relationship between product dimensions and measure group table.
 Measure Groups
Deploy, Go To Browser, and Analysis now the product dimension doesn’t participate in the analysis.

Checkout SSAS Interview Questions

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.

 MindMajix YouTube Channel

Measure Group:

Product ID –   –> CLICK –>
Select Relationship Type: Regular
Granularity Attribute: PRODUCT ID
Dimension Table: PRODUCT
Measure Group Table: TEXT_FACT

Dimensions Columns                                     Measure Group Columns
Product ID                                                                   Product ID
Deploy –> Go To Browser & analyze, now product table participates in the analysis.

Enhance your IT skills and proficiency by taking up the SSAS Training.

Referenced Relationship

–> The dimension table is joined to an intermediate dimension table, which in turn, is joined to the font table.
–> It provides the ‘Snow Flake’ schema type of structure.
–> We require approximate column references suitable to the main table.
 Referenced Relationship
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”.
 Fact Relationship

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 to which the fact table is joined.
 Many – To – Many Relationship

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.
 Source dimension must also be included in the cube

Explore SSAS Sample Resumes! Download & Edit, Get Noticed by Top Employers!Download Now!

List of Related Microsoft Certification Courses:

 SSIS  Power BI
 SSRS  SQL Server
 SharePoint  BizTalk Server
 Team Foundation Server  BizTalk Server Administrator



Join our newsletter

Stay updated with our newsletter, packed with Tutorials, Interview Questions, How-to's, Tips & Tricks, Latest Trends & Updates, and more ➤ Straight to your inbox!

Course Schedule
MSBI TrainingMar 28 to Apr 12
MSBI TrainingApr 01 to Apr 16
MSBI TrainingApr 04 to Apr 19
MSBI TrainingApr 08 to Apr 23
Last updated: 26 March 2023
About Author
Remy Sharp
Rajesh Shetty

Technical Content Writer

Recommended Courses

1 /15