Types of Dimension Tables in SSAS

Dimension Tables Types
Dimension table contains the master data information. A dimension table has a primary key column that uniquely identifies each dimension record. The dimension table is associated with a fact table using the primary key.

confirmed dimension — The value will be refered by more than one dimension table
junk dimension — Combined values of transaction
degenerate attribute — If a dimension data kept on a fact table for reference
Role Playing Dimension — Date dimension which act as a orderdate dimension and purchasedate dimension.

Types of Dimension Tables in SSAS was last modified: October 5th, 2017 by Justin Antony

Composite KeyColumn in SSAS Cube Dimention and Fact Mapping

Composite KeyColumn SSAS Cube Dimention Fact Mapping
If the Fact Table Needs to map with the Dimension table with more than one key column in SSAS Cube.

Choose the Dimension – > Select the key field – > Properties -> Key Columns -> Add all the required Key Columns

While mapping this Fact table information to the Dimension then these key columns will appear and you can map them with Regular mapping.

Composite KeyColumn in SSAS Cube Dimention and Fact Mapping was last modified: October 1st, 2017 by Justin Antony

Process SSAS Cubes pointing to incorrect database

Process SSAS Cubes pointing incorrect database

The cube database name is changed recently and deploy then it will have the old reference and it will fail. The resolution is to use the existing cube database and repoint it in the connection string. This way it will resolve any internal reference issue in the cube design.

 

Process SSAS Cubes pointing to incorrect database was last modified: October 1st, 2017 by Justin Antony