1. Just to clarify a datamart is collection of dimension tables that related
to a particular fact table within the data warehouse? I understand that the
same dimension table can be used more than once e.g. the Time dimension.
2. I would like to use Analysis Services with Reporting ...