Control the Data That Appears in a Tree Prompt

You can control what data appears in a tree prompt and how the data is structured to get the results that you want. To do this, you add various functions to the filter expression.

In addition, the operator that you chose in the Prompt Wizard dialog box controls what appears next to each prompt value. If the operator is in or not in, check boxes appear next to each prompt value. If the operator is equals (=), no check boxes appear.

Steps

1. Pause the pointer over the query explorer button  and click the query that is associated with the prompt.

2. In the Data Items pane, double-click the data item on which you are prompting.

3. In the Expression Definition box, type one of the following functions.

   Goal	Function
   Show the hierarchical structure of all members in the hierarchy. If this function is not used, all members are shown in a flat list.	rootmembers(data_item)
   Show the descendants of the data item in a hierarchical structure where x represents the level. For example, if you are prompting on the Year hierarchy and x=1, you will see 2004, 2005, and 2006 in the tree. If x=2, you will see 2004 Q1, 2004 Q2, and so on.	descendants(rootmembers(data_item, x)
   Show the children of a member. For example, 2004 Q1, 2004 Q2, 2004 Q3, and 2004 Q4 appear for the member 2004.	children(member)