User`s guide

Note:
You do not need to do this when viewing the report in SAP BusinessObjects Business Intelligence
platform. In SAP BusinessObjects Business Intelligence platform the pick list is dynamic.
Creating default values list for hierarchy node variable
To create a list of default values for the hierarchy node variable
Note:
This procedure is based on the query you created in Building a report off a BW query with a hierarchy
variable and a hierarchy node variable.
1.
In the Field Explorer, expand Parameter Fields, and right-click [HNV01].
The parameter, [HNV01], in CR represents the hierarchy node variable you created for this query.
2.
Click Edit.
The Edit Parameter dialog box opens.
3.
Ensure that the List of Values field is set to Static.
4.
From the Value Field list, select Material MemberUniqueName.
The attributes appear with their technical names in this list.
5.
From the Description Field list, select Material, which is the Member Caption field.
The attributes appear with their technical names in this list.
6.
Click Actions and then click Append all database values.
The Value and Description lists are populated with values from the BW system.
7.
In the Values Options area, set the Prompt Text to the message you would like users to receive in
the parameter prompt.
8.
Ensure that Allow custom values and Allow multiple values are set to False.
9.
Click OK.
Now when you refresh the report and are presented with the parameter prompt, you are able to pick
the parameter value from a list of values.
Note:
If your variable is optional, ensure that the Set to Null check box is clear when you select a parameter
value. The Set to Null check box overrides any value you select from the list of default parameter values.
This check box is not always cleared when you select a parameter value.
Creating list of default values for hierarchy variable
Note:
This procedure is based on the query you created in Building a report off a BW query with a hierarchy
variable and a hierarchy node variable.
2012-03-14587
Integrating Business Applications with Crystal Reports