Defining the requirements for how to get information out of a system is critical and can consume IT resources. Adding to Case Complete functionality to help capturing the following would be great.
Business Rules
<< Encapsulates the SQL statement or business logic. This would be in pseodu SQL language and would allow the developer to think through the logic and requirements with the business user. >>
Data Model Snapshot
<< Snapshot of tables used for this report and linkages between them>>
Attributes
| Attribute Name
| Description
| Expressions
| Attribute Format
| Attribute Display
|
|
|
|
|
|
|
Facts
| Metric Name
| Description
| Metric Display
| Subtotals
|
|
|
|
|
|
Hierarchies
| Drill Hierarchy Name
| Drill Path
|
|
|
|
Report Filters
| Report Filter Name
| Description
|
|
|
|
Report Filters
| Prompt
| Description
|
| Month Prompt
| The month prompt allows a user to retrieve data in the report against a particular month (or months). The user can choose a minimum of 1 month and a maximum of 13 months. The months should be listed in descending order starting with current month. The maximum number of months available to choose from is 13.
|