Post

1 follower Follow
1
Avatar

Add Ability to define business report requirements

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.
|

Shawn D. McDonald

Please sign in to leave a comment.

1 comment

0
Avatar

Hi Shawn, 

Thanks for the suggestion! We will certainly take it under consideration.

Have you considered using some of the existing functionality within CaseComplete to accomplish your goals? For instance, you could create a new requirement type "Fact," then use various custom fields to include your metrics information. For your data model, consider using fields that are attached to dictionary entries - these allow you to specify their type and any constraints they may have. For SQL statements, consider using a multi-line custom field on requirements.

Permanently deleted user 0 votes
Comment actions Permalink