Data Warehouse – Dimensional Model

This is the first in my series of ‘Basics’ articles, introducing the simple concepts needed for creating a reporting system. In this post I will be outlining the format of the data warehouse. Continue reading “Data Warehouse – Dimensional Model”

Exporting Excel Formulas

Sometimes, a customer will request for an SSRS excel export to contain some formulas rather than literal values. Usually this is when they require a ‘workbook’ rather than a normal report. i.e. they can make changes to detailed values and see what the calculated results are, rather than a read-only high-level information summary. Continue reading “Exporting Excel Formulas”