5. User's prompt creation.

This screen is used to prompt questions for the used. In this way, each time that the cube will be created, you can use the the answer and get a different search criteria each time. For example, you can be interested in data from last month or only a section's data.

The options that this screen have are:

• Add : Use this button to create a new question. This question will be prompted the moment the database query is created. The Add prompts dialog will appear.
• Edit : Choose a question from the list and press this button to change its properties. The Add prompts dialog will appear.
• Remove: Select a question from the list to remove it. You must be careful of not removing a question that is used in a search criteria defined in the followin section  Search criteria creation .
• U: It moves one level up this question. This question will be asked before its questions below.
• D: Moves the prompt one level down.

In the defined prompt's list, the following fields appear:

• Name : Unique ID of the prompt. It is used to distinguish a question from the others.
• Question : This is the question that will be asked to the user.
• Type: Data type of answer. This can be  Char,  Date or Number . For the moment the question's answer is not validated against type, so you must be careful with your answers.
• Default value : This is the default answer used when asking the question. Use single quotes ' to enclose your answer for values of type Char .

The Next button will take you to section 6. Search criteria creation.

The Back button will take you to section 4. Identify relations between tables in the query.