Search This Blog

Loading...

Sunday, February 28, 2010

Prompts

The different types of prompts allow you to create a prompt for nearly every part of a report. Remember that prompts can be used in many objects including reports, filters, metrics, and custom groups, but all prompts require user interaction when the report is executed,
Filter definition prompts allow the user to define the filtering criteria, based on the following objects:
Attributes in a hierarchy
Attribute forms
Attribute element lists
Metrics
• Object prompts allow the user to select which objects, such as attributes, metrics, custom groups, and so on, to include in a report. Object prompts can determine the definition of either the report template or the report filter.
• Value prompts allow the user to select a single value such as a date, a specific number, or a specific text string. The value chosen by the user is compared to metric or attributes element values, and thus determines the data viewed by the user. Value prompts are used in metric qualifications.
• Level prompts allow you to specify the level of calculation for a metric.

Filter definition prompts qualify on attribute elements and metrics in qualifications. Both filters and custom groups use qualifications, which are the actual conditions that must be met for data to be included. Examples include "Region = Northeast" or "Revenue > $1 million". Every filter contains at least one qualification, while qualifications are used to define custom group elements, which are the components that make up a custom group.
Use filter definition prompts in the qualifications of filters, conditional metrics, and custom group elements.

You can create the following types of filter definition prompts:
• Choose from all attributes in a hierarchy enables the user to qualify the report on any attribute or attribute element that belongs to the specified hierarchy.
A "Choose from all attributes in a hierarchy" prompt allows a user to select, during report execution, attributes and attribute elements from:

• A specific hierarchy
• all hierarchies in the project
• A set of hierarchies returned by a search object
This type of prompt is used in a qualification to restrict the set of attributes and elements available to a user when a report is executed. Both filters and custom groups use qualifications, which are the actual conditions that must be met. An example is "Attribute in the Time hierarchy". Every filter contains at least one qualification, while qualifications are used to define custom group elements, which are the components that make up a custom group.
Use "Choose from all attributes in a hierarchy" prompts in the qualifications of filters, conditional metrics, and custom group elements.
• Qualify on an attribute enables the user to qualify the report on the attribute forms or the attribute elements of the specified attribute.
A "Qualify on an attribute" prompt allows a user to qualify, during report execution, on an attribute form, such as ID, description, and so on. In other words, the user creates an attribute qualification for the report at run time, applying conditions or qualifications to an attribute form. For example, this type of prompt can filter the Month attribute so that the result set brings back only months beginning with the letter J. The "Qualify on an attribute" prompt can create a more focused prompt than a "Choose from all attributes in a hierarchy" prompt.
The prompt presents at least one attribute to the user. The user chooses an attribute by selecting either:
• A single attribute
• A search object that produces a list of attributes
This type of prompt is sometimes referred to as an attribute prompt and is used in qualifications. Both filters and custom groups use qualifications, which are the actual conditions that must be met. An example is "Year=2006". Every filter contains at least one qualification, while qualifications are used to define custom group elements, which are the components that make up a custom group.
Use "Qualify on an attribute" prompts in the qualifications of filters, conditional metrics, and custom group elements.
• Choose from an attribute element list enables the user to qualify the report on a list of attribute elements of the specified attribute.
A "Choose from an attribute element list" prompt allows a user to select, during report execution, which elements of the specified attribute to include in the report. The user picks the elements from a list, which is defined by one of the following methods:

• Selecting all the elements associated with an attribute (no restrictions)
• Selecting specific attribute elements
• Filtering the attribute elements
This type of prompt, also called simply an attribute element prompt, is used in qualifications to restrict the set of attribute elements available to a user when a report is executed. Both filters and custom groups use qualifications, which are the actual conditions that must be met. An example is "Elements of Month". Every filter contains at least one qualification, while qualifications are used to define custom group elements, which are the components that make up a custom group.
Use "Choose from an attribute element list" prompts in the qualifications of filters, conditional metrics, and custom group elements.
• Qualify on a metric enables the user to qualify the report on the specific metric.
A "Qualify on a metric" prompt allows a user to qualify, during report execution, on a specific metric. In other words, the user creates a metric qualification for the report at run time.
A metric qualification restricts the data returned for a report based on the value, rank, or rank percentage of a metric. The metric used in the qualification may or may not appear on the final report. For example, a store manager needs sales numbers for products whose current inventory levels fall below a certain level. However, the report would not have to display the inventory figures for those products.
Select one of the following methods to choose the metric or metrics to present to the user at run-time:
• A single metric
• A search object that produces a list of metrics
If you select a search object, multiple metrics may be presented to the user.
This type of prompt is sometimes referred to as a metric qualification prompt and is used in qualifications. Both filters and custom groups use qualifications, which are the actual conditions that must be met. An example is "Revenue > $1 million". Every filter contains at least one qualification, while qualifications are used to define custom group elements, which are the components that make up a custom group.
Use "Choose from an attribute element list" prompts in the qualifications of filters, conditional metrics, and custom group elements.

No comments:

Post a Comment