Selecting Values

Selectable objects

Depending on your current context when you access the Selector dialog box, you can select:

• Values for one or more dimensions

• Dimension values associated with one or more financial data items

• Dimension values associated with one or more hierarchies

Moving values to the Selected box

When you work in the Selector dialog box, you place the values that you want to work with into the Selected box.

In the following illustration, three values for the Product dimension have been placed in the Selected box.

Methods for selecting values

In the Selector dialog box you can manually select values. You can also access a set of selection tools that enable you to do the following:

• Select all values of a dimension

• Select values that match an attribute that you specify

• Select values based on their hierarchical relationship

• Select values that match characters that you specify

• Select values that meet specific numerical exception criteria that you specify

• Select values that meet specific variable exception criteria that you specify

• Select values within a top and bottom range that you specify

• Select values and then name and save that selection for future use

Selecting hierarchical values

If the dimension for which you are selecting values is part of one or more hierarchies and you want to display the values as they relate to a hierarchy, you must select the hierarchy from the Hierarchy box before selecting values. Selecting a hierarchy enables you to drill through levels of data in reports and worksheets.

Maximum amount of selectable values

When selecting values to include in a document, you cannot select more than 5000 values for an across or down edge.

Sorting selected values

You can sort the values that you have selected. Depending on the dimension for which you are selecting values, the following sort options are available:

• Alphabet -- Sorts values in alphabetical order. You can choose A to Z or Z to A.

• Database -- Sorts values according to the order in which they are stored in the database. You can choose standard or reverse.

• Data Value -- Sorts values according to their numeric value. You can choose high to low or low to high.

• Drag and drop -- Enables you to manually arrange values in any order.

• Hierarchy -- For a dimension that is organized by a hierarchy, sorts values according to their order in the hierarchy. You can choose top to bottom or bottom to top.

Related information

For more information about selecting data, search for the following topics in the Financial Analyzer Help system:

"Selecting All Values of a Dimension"

"Selecting Values by Matching Characters"

"Selecting Top and Bottom Values"

"Selecting Values by Attribute"

"Selecting Values by Specifying Numerical Exception Criteria"

"Selecting Values by Specifying Variable Exception Criteria"

"Selecting Values Manually"

"Sorting Selected Values"

"Sorting Selected Values According to Their Order in the Database"

"Sorting Selected Values Alphabetically"

"Sorting Selected Values Manually"

"Sorting Selected Values Numerically by Data Value"