The Framework Manager modeler can make the job of the report author easier by incorporating business information rules into the model. These business information rules can be as simple as renaming the columns in the imported tables to give them more intuitive names, or setting specific formatting for the imported columns. To assist the report authors, we can add standard prompts for type-in values, and standard filters, which can be reused in many different reports. We can also add calculations so that the report author does not need to add these calculations into their reports.
This is perhaps the simplest task we can perform, and is often overlooked, but is perhaps the most useful thing the modeler can do. In most imported relational databases, the column names will be in all capitals, perhaps with underlines separating the various elements of the column names. These column names do not make it obvious what the data in the column is used for....