Table of Contents
Best Pratices
Vigilens Reporting is the ideal tool for operational reporting. In this context, everything should be done so that the end user quickly has the information he needs, only the information he needs.
Limit processing time
The processing time must be short:
- Less than 25 seconds is ideal
- 100 seconds is a big maximum before the user moves on
To minimize response times:
- Use the key fields for joins.
- Use standard joins. #TBC
- Allow wildcards (“*”) of the interactive selection parameters only if required.
- Set a maximum duration of execution if there is a risk of significant duration.
If the extraction absolutely requires a duration incompatible with interactivity, use the scheduled execution.
Readability
The mass of data returned must be easy to grasp:
- 5 to 10 columns are recommended.
- 50 columns are a big maximum.
- 10 to 25 lines are the ideal number.
- 100 lines is a maximum.
To minimize the number of data displayed:
- Favor interactive data selections using parameters.
- Use the grouping functions.
- Use the linked queries: from the most synthetic to the most detailed vision (“drill down”).