In Analysis Services 2000 there is a simple way to get DRILLTHROUGH from the CUBE. To set drillthrough it is enough to select “Drillthrough Options” from “Tools”. In Drillthrough Options check Enable drillthrough and Check the fact table columns below with you want to get in drillthrough result... [More]

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]