Using wildcards and ranges in Management Reporter

When you enter either a natural segment value or a fully-qualified account into the Accounts dialog box, you can place a wildcard character, which is the question mark (?), in any position of a segment. Microsoft Office PerformancePoint 2007 Management Reporter pulls in all of the values for the defined positions without regard for the wildcard numbers. For example, if the row definition contains only natural segment values (assuming a four-character natural segment), entering 6??? in a row instructs Management Reporter to include all accounts whose natural segment value begins with a 6.

Note: Management Reporter replaces each question mark (?) with the entire range of possible values, including letters and special characters. For example, in the range from 12?0 through 12?4, Management Reporter replaces the question mark in 12?0 with the lowest value in the character set, and Management Reporter replaces the question mark in 12?4 with the highest value in the character set.

Note:  You only add ampersands (&) when you are automatically building row definitions by using the Insert Rows from... dialog box. For more information, see Structure.

Single-Segment or Single-Dimension Ranges

You can specify a range of segment values or dimension values. The benefit of specifying a range is that you do not need to update the row definition every time a new segment value or dimension value is added to the financial data.

For example, the range 6100:6900 pulls the values from 6100 through 6900 inclusively into the row amount.

When a range includes wildcard characters (?), Management Reporter does not evaluate the range on a character-by-character basis. Instead, Management Reporter determines the low and high ends of the range, and then includes all values between those ends, inclusive.

Multi-Segment or Multi-Dimension Ranges

When you enter a range by using fully-qualified accounts or combinations of multiple dimension values, the range comparison is accomplished on a segment-by-segment or dimension-by-dimension basis. (The range comparison cannot be accomplished on either a character-by-character basis or a partial segment basis.)

For example, the range 5000-1000-00:6000-2000-00 includes only the accounts that match each segment. In this scenario, the first segment must be in the range from 5000 through 6000, the second segment must be in the range from 1000 through 2000, and the last segment must be 00. (For example, the fully qualified account 5100-1100-01 would not be included in the report because the last segment is out of the specified range.)

If a segment value includes spaces, enclose that value in square brackets [ ]. The following values are valid for a four-character segment: [ 234], [123 ], [1 34]

Always enclose dimension values in square brackets [ ].

When a multi-segment or multi-dimension range includes wildcard characters (?), Management Reporter determines the low and high ends of the entire multi-segment or multi-dimension range, and then includes all values between those ends, inclusive.

Top of Page

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×