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.
Procedure
-
Click the Queries icon
, and click the query that is associated with the prompt.
- In the Data Items pane, double-click
the data item on which you are prompting.
- 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 2010, 2011, and 2012 in
the tree. If x=2, you will see 2010 Q1, 2010 Q2, and so on.
|
descendants (rootmembers (data_item),
x)
|
Show the children of a member. For example,
2012 Q1, 2012 Q2, 2012 Q3, and 2012 Q4 appear for the member 2012.
|
children (member)
|