When you are planning your BI reporting environment and are ready to start designing your reports you must ensure that you identify the required user interaction.
- Will the users execute the report interactively?
- Will there be drill through requests from one report to another?
- Will the report be burst to multiple users and how will the output be delivered
- (Cognos connection, email, etc.)?
- Prompt information:
- What prompts are to be presented to the user?
- What format will the prompts take and which values will be valid user selections?
- Will there be cascades between prompts?
- Which prompts are required and which are optional?
- Which prompts will allow multiple values to be selected? Have you identified the appropriate filter expressions which will allow for multiple values to be selected?
- An expression such as [Data Item] = ?Prompt? will only allow for a single value to be selected.
- Are there requirements for more complicated prompting expressions that will require prompt macros?
