Working with prompt hierarchies

Prompt hierarchies allow users to select one or more values from a flat or hierarchical list of options.

Prompt hierarchies are distinct QMF objects that are stored independent of a given query, allowing them to be used by multiple query objects. Prompt hierarchies draw their option list from a query, for example “select region from sales territories”. In addition, a prompt hierarchy can present a hierarchy of values, with unlimited levels of detail. For example, “select region, country from sales territories”. In this case, the list of options would be broken down by ‘Americas', ‘Europe' and ‘APAC', with USA, Canada and Mexico listed under ‘Americas' and so on. Users can then select values at both levels of the prompt, perhaps selecting ‘APAC' in its entirety and ‘Americas' but not selecting Mexico.