SSAS: Using fake dimension and scopes for dynamic ranges

added by gpeipman
12/10/2010 6:30:34 PM

1 Kicks, 230 Views

In one of my BI projects I needed to find count of objects in income range. Usual solution with range dimension was useless because range where object belongs changes in time. These ranges depend on calculation that is done over incomes measure so I had really no option to use some classic solution. Thanks to SSAS forums I got my problem solved and here is the solution.