Value Help List

Value help lists are reusable selections of master data values that are made available as entry lists for use while designing your model. You can use these to, for example, supply valid values to a formula or to populate controls such as drop-down lists. Value help lists are created with the help of a wizard that is accessed from the Entry List Manager when you click Add, and choose Value Help List.

You create a value help entry list in two steps provided by the wizard:

Select a data source
Review value help list

You can repeat these steps as many times as you wish while creating the list (for example, to create lists with values from different data services).

Structure

The main sections and controls of the two screens of the wizard are described in the following two tables:

Select a Data Source
Section	Control	Description
Available Services	Select system	Browse and search a selected system for a data service. See Find Data Services Task Panel, which describes similar functionality. Data services from three types of systems are supported: SAP BI systems XMLA systems JDBC systems
Available Services	Data service tree	Depending on the type of data service you have selected above, select the following kind of object in the data service tree: Characteristic (SAP BI system) Level (XMLA system) Table column (field) (JDBC system)
Description	Review the description, if available, of the object selected in the data service tree.

Review Value Help List
Section/Control	Field	Description
Search section	Look for	Browse data - retrieve and browse all master data values, without search restrictions Look for key - SAP BI systems only - Restrict the list of master data to be retrieved by searching in keys based on numeric operator values specified below. Look for text - SAP BI systems only - Restrict the list of master data to be retrieved by searching in text based on textual operator values specified below.
	Operator	If Look for key or Look for text is selected, choose an operator to apply: Keys (numeric operators): Equal To Not Equal To Between Not Between Less Than Equal To Greater Than Greater Than Equal To Less Than Contains Pattern Not Contains Pattern Text (textual operators): Equal To Contains Pattern
	Low	Enter a low or text value for the selected operator, if relevant.
	High	Enter a high value for the selected operator, if relevant.
	Find data used in cube only (SAP BI systems only)	If checked, search for values within the dimension table. If unchecked, all values of the selected characteristic that appear in the master data table are retrieved.
	Browse / Search	Browse when browse data is selected, otherwise Search. Retrieve the available master data values for the object selected on the previous screen. Up to the first 1000 values are retrieved. Search masks are applied (as above) if relevant, to reduce the size of the list.
Available Values	The list of values available for your list. Move individual selected values back and forth between lists with the arrows or clear them with the Clear button.
Selected Values	Values selected to appear in your list. Move individual selected values back and forth between lists with the arrows or clear them with the Clear button.

Example

See Creating a Value Help Entry List in the SAP NetWeaver Visual Composer Modeler's Guide.

Note Note

Entry list value help is also known as design-time value help. A second type of value help, a run-time value help, is also available in Visual Composer. With this, you create a button next to an input field that displays a dialog box of valid values during your model's runtime. See Value Help Configuration Wizard.

End of the note.