Structure in Management Reporter

Structure is the segmentation definition that defines the logical positioning and lengths for the account and related segments.

Microsoft Office PerformancePoint 2007 Management Reporter row definitions and reporting tree definitions support the use of special characters as a way to identify multiple segment values or dimension values without naming each item individually. The following table describes the characters that are supported for specifying segment and dimension values:

Character

Function for Row Definitions

Function for Reporting Tree Definitions

Ampersand (&)

In the Structure row of the Insert Rows from... dialog box, identifies the segment or dimension from which to bring values into the row definition. These values become the basis of the rows in the generated report.

Ampersands are typically used for the natural segment or the Account dimension.

For a fully-qualified-account-based system, identifies the segment that is specified in the row definition. (This function is the same in both the structure area of the Insert Reporting Units from Source System dialog box and the Structure column of a reporting tree definition.)

For a dimension-based system, no function.

Number sign (#)

In the Structure row of the Insert Rows from... dialog box, identifies the segments or dimensions to ignore when bringing values into the row definition.

Number signs are typically used for the responsibility segments or dimensions.

No function.

Plus sign (+)

No function.

In the structure area of the Insert Reporting Units from... dialog box, identifies the segments or dimensions from which to bring values into the row definition. These values become the reporting units in the reporting tree.

Digits (0-9)

In the Range rows of the Insert Rows from... dialog box, identify the first and last segment or dimension values to bring into the row definition.

In the Link to Financial Data Source column of a row definition, identify the segment or dimension values to include in the report for each row.

In the From Account and To Account columns of the Insert Reporting Units from... dialog box, identify the first and last segment or dimension values to bring into the reporting tree definition.

In the Structure column of a reporting tree definition, identify the segment or dimension value to include in the reporting unit for each row.

See also the descriptions for letters and for the question mark and asterisk characters.

Letters (a-z, A-Z)

For a fully-qualified-account-based system, no function.

For a dimension-based system, functions in the same ways as digits.

Question mark (?)

A placeholder for a single character in a segment or dimension value. For example, the value 22?? indicates that Management Reporter should insert into the generated report the total financial amount for all segment or dimension values in the range from 2200 through 2299.

Asterisk (*)

For a fully-qualified-account-based system, no function.

For a dimension-based system, a placeholder for one or more characters in a dimension value. For example, for a color dimension, the value GR* indicates that Management Reporter should insert into the generated report the combined financial amount for the GREEN and GRAY dimension values.

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!

×