Structures for Fully-Qualified-Account-Based financial data sources in Management Reporter

When creating a reporting tree definition, you can use the same row definitions repeatedly, whether you are generating a departmental income statement or a consolidated summary income statement. Microsoft Office PerformancePoint 2007 Management Reporter offers this versatility by separating the responsibility segments of the account structure from the natural segment.

When the row definition defines only a portion of the account structure, the reporting tree definition defines the remainder of the account structure. Each child reporting unit in the reporting tree definition contains a structure that uses numbers and symbols to indicate how the account structure definition is separated between the row definition and the reporting tree definition. The structure determines the amount of detail information that should be drawn from the financial data.

A parent reporting unit usually summarizes the detail information that rolls up from the child reporting units and, therefore, does not include a structure.

For information about the symbols that are used in a structure, see Structure.

Show me an example

The following excerpt of a reporting tree definition shows the structure for the Sales-Denver reporting unit.

Entity

Unit Name

Unit Description

Structure

@ANY

SALES-DENVER

Sales Division-Denver

&&&&-1100-???

Management Reporter created this structure (&&&&-1100-???) when building the reporting tree definition, and now displays the mask in the Structure column for the Sales-Denver reporting unit.

Note:  The specific structure for the Sales-Denver reporting unit (&&&&-1100-???) was created by using the structure that was entered (&&&&-++++-???) into the Insert Reporting Units from Source System dialog box.

The first segment of the structure for the Sales-Denver reporting unit, (&&&&), is the natural segment and is depicted by four ampersands. These ampersands correspond to the four digits in the Link to Financial Data Source column as shown in the following excerpt of a row definition. The four ampersands (&&&&) in the structure for the Sales-Denver reporting unit relate to these four digits.

Description

Normal Balance

Link to Financial Data Source

Sales

C

(410?-4109)

The second segment of the Sales-Denver reporting unit mask, (1100),is defined in the reporting tree definition, and represents the location and the division, where the first character indicates the location (for example, 1 = Denver) and the second through fourth characters indicate the division (for example, 100 = Sales).

The third segment of the Sales-Denver reporting unit mask, (???), represents the department. This segment contains question marks that instruct Management Reporter to avoid building details into the reporting tree definition from the row definition. The ampersands (&) in the natural segment already point to financial data links in the row definition that will pull in detailed information from the segments that are listed in the Link to Financial Data Source column. If you do not use the question marks to restrict the row, the reporting tree pulls in the same data for every unit, which results in summary units that contain duplicate and incorrect totals.

Note:  If you use a fully-qualified account in the row definition, you might also need to use a reporting unit restriction in the same row to prevent pulling duplicate data for reporting units.

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!

×