...
Once we are configured, we'll need to determine what LIVE calculations we wish to warehouse. Like the House Report Warehouse before this, we'll do that by adding columns named after projection report calculations into the fact table.
A full list of calculations are provided in a script with the installation. We'll chose the ones we want to warehouse and execute those lines of code. we'll have to keep in mind that there are more calculations then there are number of columns supported by SQL, and that the more we add the longer it will take to calculate batches- so the columns we choose not to include are just as important to consider as the ones that we do!
...