Skip Headers
Oracle® Business Intelligence Enterprise Edition Help
11g Release 1 (11.1.1)
  Go To Table Of Contents
Contents


Select Values dialog

Use this dialog to search for and select one or more values from a list of available values, for example:

Using this search function, you can limit the list of available values (for example, find all those values that start with the letter D) so that you can more easily find the value or values that you want.

This dialog is also displayed as:


Choose Members dialog
Edit Hierarchy Selection Step dialog
Edit Member Step dialog
Edit Select Existing Groups and Calculated Items
Member Selection Dialog
New Hierarchy Selection Step dialog
New Member Step dialog
New Select Members dialog
New Select Existing Groups and Calculated Items
Search Members dialog

Components


Note:

Not all components are available in each version of this dialog.


Relationship

Available only when working with a member step that is based on a hierarchy.

Use this box to select the type of relationship with which to create the member step for the hierarchical column. You can select a family relationship, a specific hierarchy level (for level-based hierarchies only), or a level relationship (for level-based hierarchies only). For parent-child hierarchies, the only option available is family relationship.

Action

Not available when working with multiple values for pinning KPI dimensions.

Use this box to select the type of action to create. You can select to add the selected members to the selection, keep only the selected members and remove all others, or remove the selected members from the selection. For groups and calculated items, the only action available is Add.

When working with a member step that is based on a hierarchy, use the box beside the Action box to specify a hierarchy level (for level-based hierarchies only) or a family relationship.

For a family relationship, you can select one of the following options:

When you edit the first step in a list, the choices for actions are Start with All Members, Start with Selected Members, and Start with Groups or Calculated Items.

Search

Use this button to show or hide the Search area that is displayed within the Available List area. See "Components of Search Area."

Available List

Use this area to:

Items that you have selected are displayed with a green check mark beside them.

Selected List

Use this area to view the values that you have selected from the Available List area and moved to the Selected List area.

Include selected members

Use this box to specify whether to include the selected member in addition to all the members of the family relationship (such as Children of) that you specify.

For example, specifying Keep Only and Children of 2011 and also selecting this box, returns: 2011, 2011 Q1, 2011 Q2, 2011 Q3, and 2011 Q4.

Edit

Use this button to display the "Edit dialog," where you can refine the values with which you are working.

This button is not available when you select members for selection steps or when working with multiple values for pinning KPI dimensions.

Override with

Use this box to specify that an analysis prompt, a dashboard prompt, or a variable can override the member step.

If you select a variable type (Presentation Variable, Session Variable, or Repository Variable) then enter the name of the variable in the field. For example, suppose that you have a column called EMPLOYEE_ID. You can specify USER as the session variable with which to override the value of that column. When a user logs in, the column value is set to his login name. For more information on variables, see "Using Variables."


Note:

For hierarchical columns, session and repository variables that you use to override a member step must contain valid JSON syntax rather than SQL syntax in their initialization strings. For more information see "Initialization Strings Used in Variables to Override Selection Steps" in Metadata Repository Builder's Guide for Oracle Business Intelligence Enterprise Edition.


In a list of steps for a column, specify that only one step in the list be able to be overridden by a prompt or variable.

For more information on prompting, see Chapter 6, "Prompting in Dashboards and Analyses."

Notes

Components of Search Area

Use this area to initiate a search for values or members and view the results of the search.

Name

Use these fields to specify text data on which to search. In the Name box, select the appropriate option such as Starts, Contains, Ends, or Is Like (pattern match). Enter the string for which you must search.

Between and

Not available for member search. Use this field to specify a range of numeric or date and time data for which to search.

Children of

Available only when searching for hierarchical members. Use this field to specify the node in whose sub-tree you want to start searching for members. For example, suppose that you have a geography hierarchy with All Countries as the root node and 50 countries below that. You want to search for all cities that start with the letter "A" in the country called USA. Use the Children of field to specify USA.

Select Member to display the Select Member dialog.

Select a Specific Member to Search Within

Available only when searching for hierarchical members. Click this button to display the Select Member dialog in which you specify the member whose children you want to search.

At Level

Available only when searching for members of level-based hierarchies. Use this field to select the level below which you want to search for members. The default of <Any> specifies to search for members below any level. For parent-child hierarchies, no levels exist, so this setting is always <Any>. Certain levels are disabled because they are at or above the level you selected, which does not constitute a valid search.

Limited Values or Constrained

Use this button to limit the values by any other filters that are associated with the analysis.

All Values or Unconstrained

Use this button to list all values, without limiting the values by any other filters that that are associated with the analysis.

Match Case

Use this box to provide case-sensitivity for the members when working with multiple values for KPI dimension pinnings.

Search

Use this button to initiate the search and display the search results. When you search for members, the columns of the subject area are searched.

Notes

If the available list of values for a prompt or write back column is based on a SQL statement, then you cannot search for values.

Related Topics


"New Prompt dialog"