Establishing Dimension Member Selection Rules

This topic discusses how to:

Define dimension member selection rules.
Define an advanced rule.
Preview dimension member IDs.

Pages Used to Establish Dimension Member Selection Rules

Page Name	Definition Name	Navigation	Usage
Dim Member Select (dimension member selection)	BC_KPI_FILTER	select Scorecards, then select Administration, then select Portfolio Objects, then select Dim Member Selection Rule, then select Dim Member Select Click the Create Selection Rule link or the View Selection Rule link on the Portfolio Definition - Dimension Member Selection page.	Create or modify a rule that specifies which dimension members to include in a portfolio.
Dim Member Select - Advanced Selection (dimension member selection - advanced selection)	BC_KPI_FILTER_ADV	select Scorecards, then select Administration, then select Portfolio Objects, then select Dim Member Selection Rule, then select Advanced Selection	Extend the selection rule by specifying criteria for fields that are outside of the dimension.
Dim Member Select - Dim Member Preview (Dimension member selection - dimension member preview)	BC_KPI_FILTER_VIEW	select Scorecards, then select Administration, then select Portfolio Objects, then select Dim Member Selection Rule, then select Dim Member Preview	Preview the list of dimension members that are retrieved by this selection rule.

Dim Member Select Page

Use the Dim Member Select (dimension member selection) page (BC_KPI_FILTER) to create or modify a rule that specifies which dimension members to include in a portfolio.

Navigation

select Scorecards, then select Administration, then select Portfolio Objects, then select Dim Member Selection Rule, then select Dim Member Select
Click the Create Selection Rule link or the View Selection Rule link on the Portfolio Definition - Dimension Member Selection page.

Image: Dim Member Select page

This example illustrates the fields and controls on the Dim Member Select page . You can find definitions for the fields and controls later on this page.

Dimension

Select the dimension for the selection rule.

Clear Selection

Click this link to clear the current selection criteria.

Dimension Selection

Insert rows as needed to compose the criteria used for the rule.

Open and Close

Select the number of opening or closing parentheses needed for the selection criteria.

Field Name

Select the field to use for the filter criteria.

Comparison Operator

Select the operator to use as selection criteria. Values are:

Equal To

Greater Than.

Greater Than or Equal To.

Less Than.

Less Than or Equal To.

Equal To.

is Like: Like the comparison value. Valid only for character type fields that have no associated lookup tables. The system programmatically appends a wildcard to the end of the lookup value that you enter.

is Not Like: Not like the comparison value. Valid only for character type fields that have no associated lookup tables. The system programmatically appends a wildcard to the end of the lookup value that you enter.

Not Equal To.

Value

Enter or select the comparison value.

And/Or

Select either AND or OR to relate one line to the next of the filter criteria.

Dim Member Select - Advanced Selection Page

Use the Dim Member Select - Advanced Selection (dimension member selection - advanced selection) page (BC_KPI_FILTER_ADV) to extend the selection rule by specifying criteria for fields that are outside of the dimension.

Navigation

select Scorecards, then select Administration, then select Portfolio Objects, then select Dim Member Selection Rule, then select Advanced Selection

Image: Dim Member Select - Advanced Selection page

This example illustrates the fields and controls on the Dim Member Select - Advanced Selection page. You can find definitions for the fields and controls later on this page.

To extend the selection rule to additional dimension fields, insert one or more Additional Selection sections and specify additional data and criteria to further qualify your selection. You can use KPI data or other data that can be associated with the dimension of this rule. For example, you could define an advanced rule to limit your projects to those that have a negative trend.

Clear Selection

Click to clear the current selection criteria.

Additional Selection

Record Type

Specify the type of record to use. Options are:

Associate with Dimension: Select to use records from dimension data for this filter.

KPI Data: Select to use KPI records for this filter.

Your selection controls which records appear in the selection list for the Additional Record field.

Additional Record

Select the record upon which to base your additional criteria.

Relationship to other criteria

Indicate how this criteria is used with respect to the other criteria, either And or Or.

Additional Search Fields

Insert rows to specify the criteria. These fields are described in the page description for the Dim Member Select page.

See Portfolio KPI Analysis Page.

Dim Member Select - Dim Member Preview Page

Use the Dim Member Select - Dim Member Preview (Dimension member selection - dimension member preview) page (BC_KPI_FILTER_VIEW) to preview the list of dimension members that are retrieved by this selection rule.

Navigation

select Scorecards, then select Administration, then select Portfolio Objects, then select Dim Member Selection Rule, then select Dim Member Preview

Preview Parameters

Enter the parameters for viewing the dimension members that this rule retrieves by completing the fields and clicking Show Results.

Dimension Members

This grid displays the dimension members that are retrieved by the rule for the specified parameters.