Management Reporter supports flexible reporting so it is easy to make changes as your business structure changes. Reporting tree definitions can be combined with column definitions and report definitions to create a building block group that can be used by multiple companies. For more information about building block groups, see Building block groups .

Management Reporter for Microsoft Dynamics ERP displays each reporting tree definition in a graphical view for visualising the parent/child hierarchy, and in a worksheet view that shows the specific information for each reporting unit. The graphical view and the worksheet view are connected. When you select a reporting unit in one view, it is also selected in the other view.

You can build cross-dimensional hierarchies based on the dimensional relationships within your financial data. When you create 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.

The dimensions that are defined in the row definition can be combined with dimensions in the reporting tree definition to provide highly flexible views of your organisation's performance.

Reporting tree definition columns

The reporting tree definition contains the following columns:

Reporting Tree Column

Description

Company

The company name for the reporting unit. The @ANYvalue, which is typically assigned only to the summary level, enables the reporting tree to be used for all companies. All child branches have a company assigned to them.

Unit Name

The code that identifies this reporting unit in the graphical reporting tree. For ease of use, establish a unique coding system that is consistent and is easily understood by users.

Unit Description

The reporting unit title appears in the report header or footer if you enter UnitDescas a code on the Headers and Footerstab of the report definition. The title appears in the report row description if you enter UnitDescin the Descriptioncell of the row definition.

Dimensions

Every detail reporting unit row must have a dimension in this column.

You can also place a dimension in a summary unit row, for example, for expenses directly related to that unit. If you enter a dimension in a summary unit row, accounts that are used in parent units should not be used in child units to avoid duplicated amounts.

For more information, see Add dimensions in a row definition .

Row Definitions

The name of the row definition for the reporting unit. The same row definition is used for each unit of the reporting tree. When you generate a report, this row definition is used for each reporting unit.

The row definition can include multiple financial dimensions links.

If you specify row definitions in the reporting tree, select the Use row definition from reporting treecheck box on the Reporttab of the report definition.

Row link

The row link to use for the reporting unit. Row links are defined for the row definition to identify the financial dimensions to link to.

External link

The row link to use for this reporting unit. Row links are defined for the row definition to identify the Excel spreadsheet file or the Management Reporter report to link to.

External file

The file path to the Excel spreadsheet or Management Reporter worksheet to pull data from. For more information, see Identify an Excel file in a reporting tree .

XBRL Dimension

Defines XBRL dimensions and labels. For more information about the XBRL Dimensions dialogue box, see Link to XBRL taxonomies . Dimensions that are not defined in the reporting tree definition must be defined in the column definition.

Page Options

Controls whether the detail for the reporting unit is suppressed from viewing or printing.

Rollup %

The percentage of the reporting unit that is to be allocated to its parent unit. The percentage that you enter in this column applies to each row of the row definition before the value in the row is added to the parent report. For example, if a child unit is to be divided evenly between two departments, the amounts in each row would be multiplied by 50 percent before being added to the department report.

One reporting unit cannot have two parent units. To allocate the amounts from a reporting unit to two parent units, create another reporting unit with the same dimension to roll up the additional 50 percent.

Type whole percentages without a decimal point. For example, .25equals .25%allocation to the parent, and 25equals 25%allocation to the parent. To use a percentage that is less than one percent, use the Allow Rollup <1%option in the report definition. This option is on the Additional Optionstab in the Report Settingsdialogue box. Access this dialogue box from the Otherbutton on the Settingstab of the report definition.

Unit Security

Restrictions on which users and groups can access the information for the reporting unit.

For more information, see Restrict access to a reporting unit .

Additional Text

Text that is included in the report. For more information, see Additional text for reporting unit .

Create a reporting tree definition

Open an existing reporting tree definition

  1. In Report Designer, click Reporting Tree Definitionsin the navigation pane.

  2. Double-click a name in the reporting tree list to open it. For a description of the columns and the information that is required, see Reporting tree definition columns .

See Also