Microsoft Business Intelligence

Linked Dimension: This dimension joins different fact tables from two or more cubes Conformed Dimension: This dimension joins multiple fac...

This occurs when a dimension references itself by a primary and a foreign-key relationship in the same dimension. Example: Dim_A -> Dim...

Sometimes we need to analyze our data based on the some specific value which are available only at fact table. In this case, the particular ...

Data modelling: Modelling data storage optimized for Transactional Processing is Data Modelling Dimensional modelling: Modelling data st...

1. Named Query is a SQL Statements and it act as a another table 2. It is formed by selecting rows and columns from single tables or relat...

In SQL Server Analysis Services (SSAS), Linked Dimension is a dimension which is existed in other analysis services DB. It may exist in sam...