Working with Components
4. Click the Appearance view and set the following options:
4.2.11.2 To set up query prompt selector components
If your model includes a universe or BEx query with a prompt, you can add the query prompt selector component to your model to allow users to select parameters for the prompt at runtime.
Note:
You can also add query prompt selectors to your model by dragging the prompt from the "Query Browser"
to the canvas. Query prompt selectors that you add in this manner are configured according to the settings that you chose for the prompt in the "Add Query" dialog box.
1. Select the query prompt selector and open the "Properties" panel.
2. On the "Properties" panel, click the General view and set the following options:
Description Option
Select a prompt to set the label and the operator on the component, and the number and type of values that the user can choose at runtime.
If you want to change the settings for the prompt, you must edit the prompt from the
"Query Browser".
Note:
If you delete or edit a prompt or query, the Source Prompt list is updated to reflect your changes.
Source Prompt
Select the query prompt that the selected prompt value is sent to.
The Source Prompt that you selected is auto-matically selected in this table. If you have mul-tiple queries, you can select prompts from other queries to send the value to these prompts too.
For instance, you could configure a single query prompt selector to choose the date for two queries.
You cannot select more than one destination prompt for each query.
Destination Prompt(s)
To insert the captions of the selected prompt values in the spreadsheet, click the Cell Selector ( ) button and select a destination range in the spreadsheet. Select a single destination cell for prompts with single values, or a column for prompts that allow the user to select multiple values.
Insert Selected Items
Description Option
The "Refresh Queries" table lists the queries that have been defined for the model. Select the queries that the component refreshes.
Refresh Queries
Select this option to refresh the selected queries when the user selects a new prompt value.
Refresh When Selection Changes
Select this option to display a button that the user must click to refresh the selected queries.
Refresh On Button Click
Type the text to display on the button or click the Cell Selector ( ) to retrieve the label text from a cell in the embedded spreadsheet.
Button Label
3. Click the Behavior view and set the following options:
Description Option
Common tab
Select this option to add a search function to the component list that allows users to search for the prompt value.
Enable Search in List of Values
For a prompt with a hierarchical list of values, select this option to add a menu that allows users to customize how values are displayed.
Enable Display Menu
For a prompt with multiple selection and a hier-archical list of values, select this option to add buttons to each value in the list of values at runtime.
When users click the button for a parent value, a menu opens and allows them to select or de-select all children or descendants of the value.
This option is useful for choosing values from large sets of hierarchical data.
Enable Subset Selection Options
Description Option
For a prompt with a hierarchical list of values, specify how values appear in the list.
You must select Enable Display Menu to con-figure these settings. If you leave Enable Dis-play Menu selected, users can change these settings at runtime. If you deselect Enable Dis-play Menu, the "Default disDis-play mode" that you choose cannot be changed at runtime.
Select one of the following options for how each value is displayed:
• Display caption: only the caption is dis-played.
• Display unique name: only the unique name is displayed. Values may be more difficult to identify using the unique name.
• Display both caption and unique name:
the caption and the unique name are dis-played.
You can also select Display number of chil-dren to show the number of chilchil-dren for each value.
Default display mode
Select this option to treat empty selection values as having no value.
No Value
Select this option to treat empty selection values as empty strings.
Empty String
This option allows you to specify conditions that control when the component is visible in the model. For more information about using dynam-ic visibility, seeManaging the visibility of compo-nents.
Dynamic Visibility
Animations and Effects tab
Configure an animated entry effect for the ap-pearance of the component. This option is useful for components with dynamic visibility.
Select an entry effect from the Type list and specify how long the effect lasts in the Duration (seconds) box.
Entry Effect
4. Click the Appearance view and set the following options:
Description Option
Layout Tab
Configure how the list of values appears. Select Expanded to display an expanded list that al-ways stays open or Collapsed to display a drop-down list that can be opened or hidden by the user.
Display Options
For a hierarchical list of values, specify which levels in the hierarchy appear expanded when the model loads. Users can expand or collapse individual levels at runtime.
• Expand Level: to specify the number of levels to expand, select this option and type a number in the box.
• Expand All Levels: to expand all the levels in the list of values, select this option.
• Collapse All Levels: to collapse all levels in the list of models, select this option.
Hierarchy Levels
Text Tab
Select this option to display the prompt label that you configured in the "Edit Prompt" dialog box.
You can also format this text using the settings in the "Format Selected Text" area.
Prompt Text
Select this option to display the operator or se-lection method for the component.
You can also format this text using the settings in the "Format Selected Text" area.
Selection Type
To format the text for the prompt values, click Values and configure the settings in the "Format Selected Text" area.
Values
To format the text for the button that refreshes the query, click Apply Button Text and config-ure the settings in the "Format Selected Text"
area.
Apply Button Text
Description Option
Select this option to display text that identifies the search box. This text disappears when the user clicks the search box.
You can also format this text using the settings in the "Format Selected Text" area.
Search Box Label
To format the text that the user types in the search box, click Search Box Text and config-ure the settings in the "Format Selected Text"
area.
Search Box Text
To format the info text for the component, click Apply Button Text and configure the settings in the "Format Selected Text" area.
Selection Information Text
Color Tab
Set the color of the component background.
Background Color
Set the color of the text at the bottom of the component showing how many values in the list are selected.
Text Color
Set the color for the links at the bottom of the component to show the entire list of values or to show the selected values only.
Link Color
Choose the color for the following elements:
• Background Color: the color of the header background
• Prompt Text Color: the color of the text that you configured in the "Edit Prompt" dialog box.
• Selection Type Color: the color of the oper-ator or selection type text.
Header
Set the color of the values in the list, including the "Selected Members" list.
You can set the Default Color for when values are inactive, the Over Color for when the user mouses over a value, and the Selected Color for values that are selected.
Values
Description Option
Set the color of the background behind the val-ues in the list, including the "Selected Members"
list.
You can set the Default Color for when values are inactive, the Over Color for when the user mouses over a value, and the Selected Color for a value that selected.
Value Backgrounds
Set the color of the component buttons.
You can set different colors for the button backgrounds and for the color of the icons and text on the buttons. You can also set different colors for when the button is inactive (Default Color), for when the button is clicked (Pressed Color), and for when the button is disabled (Disabled Color).
Buttons
Set the Button Color and Arrow Color for the buttons that open drop-down lists.
Arrow Buttons
Set the Text Color for the text that the user types in the search box, and the Label Color for the label text in the search box.
Search Box
Set the color for parts of the bars that let users scroll through the list of values.
The settings that you can configure include Track Color, Thumb Color, Button Color, and Button Symbol Color.
Scroll Bar