Some questions on identification of Slowly Changing Dimensions. When  
exactly do we determine if a dimension is classified as SCD?
For example, if I have a Customer Dimension table
Customer Key    Name       Country

The date i select from my report to pull data 'End Month Date'. I need to
calculate my 'TotalAmount' base on my 'End Month Date' and previous 'End
Month Date'. For example:
if i selected '20070831' and 'TotalAmount'= '100', base on my selected date

Just getting started with Analysis Services. In my first cube I have a table
of cases broken down by geographical area. I am looking at it in the browser
and I have regions along the top with sums in each column. But regions do
not show up if they have no cases. Is there any way ...