Sometimes project requires that you join fact entities, causing the records redundancy. Let’s see an example “Entity1ID” is a key value for Entity1 and “Entity2ID” is a key value for Entity2. In this case Entity1 and Entity2 ale related as many to many. T... [More]

Almost all BI projects consider Time a dimension. It may have different granularity such as year, quarter, month, week or day. While there should be only one Time dimension in all related projected we can give it a different meaning like Create Date, Sell Date etc. Members of the Time dimens... [More]