Hi Folks,
After a long gap , I am now working on SSAS cube - its creation, calculations and then building Power BI reports from it. So here are my learnings during this process
1. To create a cube
https://www.sqlshack.com/build-cube-scratch-using-sql-server-analysis-services-ssas/
2. Dimension Relationships
a. Regular Dimension Relationship
A regular dimension relationship between a cube dimension and a measure group exists when the key column for the dimension is joined directly to the fact table. This direct relationship is based on a primary key-foreign key relationship in the underlying relational database, but might also be based on a logical relationship that is defined in the data source view.
b. Reference Dimension Relationships
A reference dimension relationship between a cube dimension and a measure group exists when the key column for the dimension is joined indirectly to the fact table through a key in another dimension table, as shown in the following illustration.
c. Fact Dimension Relationships
Fact dimensions, frequently referred to as degenerate dimensions, are standard dimensions that are constructed from attribute columns in fact tables instead of from attribute columns in dimension tables.
d. Many to Many Dimension Relationships
In most dimensions, each fact joins to one and only one dimension member, and a single dimension member can be associated with multiple facts. In relational database terminology, this is referred to as a one-to-many relationship. However, it is frequently useful to join a single fact to multiple dimension members.
After a long gap , I am now working on SSAS cube - its creation, calculations and then building Power BI reports from it. So here are my learnings during this process
1. To create a cube
https://www.sqlshack.com/build-cube-scratch-using-sql-server-analysis-services-ssas/
2. Dimension Relationships
a. Regular Dimension Relationship
A regular dimension relationship between a cube dimension and a measure group exists when the key column for the dimension is joined directly to the fact table. This direct relationship is based on a primary key-foreign key relationship in the underlying relational database, but might also be based on a logical relationship that is defined in the data source view.
b. Reference Dimension Relationships
A reference dimension relationship between a cube dimension and a measure group exists when the key column for the dimension is joined indirectly to the fact table through a key in another dimension table, as shown in the following illustration.
c. Fact Dimension Relationships
Fact dimensions, frequently referred to as degenerate dimensions, are standard dimensions that are constructed from attribute columns in fact tables instead of from attribute columns in dimension tables.
d. Many to Many Dimension Relationships
In most dimensions, each fact joins to one and only one dimension member, and a single dimension member can be associated with multiple facts. In relational database terminology, this is referred to as a one-to-many relationship. However, it is frequently useful to join a single fact to multiple dimension members.
No comments:
Post a Comment