Formatting Planning Maestro Reports

Follow
We're transitioning to a new User Interface, and are in the process of updating Help Hub content to match the new interface.

In Planning Maestro, you can run reports to analyze the data from your budgets for Operating Expenses, Revenue, Personnel, Drivers, and Adjustments.

This document shows you, a Planning Maestro user, how to format these reports, including:

Locating Reports

To run a report, open the Reports module, click on + New Report, and select a report.

Best_practice_icon.png Please Note: To open a report with preformatted settings, you can also select Shared Reports from the landing page.

Info.png Please Note: All settings described in this document apply to all Planning Maestro reports. The screenshots use a Cash Flow report as an example.

C1a.png

Running a Report

Your report opens.

C1c.png

(Optional) Click the Expand icon ( Expand_report.png ) in the middle to make this report full-screen.

C1d.png

Filtering Reports

Use the filters on this report to analyze your data.

C1e.png

To understand the amounts on this report better, move Dimensions from Filters to Rows.

C1f.png

Moving a Dimension to Rows creates a new column in the table that displays how each Dimension Member (GL Account, product, office, etc.) affects the total.

Refreshing Reports

After making any change to a report, click the Rerun Report button ( Rerun_report_-_highlighted.png ). Click this button every time you make changes to the report to refresh the page and implement those changes.

C1g.png

Info.png Please Note: The Rerun Report makes it easier for you to make multiple small changes to a report by loading all those changes at once, instead of pausing to load each small change.

The Dimension becomes a column in the table. All the Dimension’s Members and their values display in the table.

C1h.png

To expand the size of the columns so you can read the report more easily, hover your cursor over the column divisions.

C1i.png

To view line items related to one Dimension Member from a Dimension (such as one entity from your Entity Dimension), filter the Dimension when it is in the Filters section. Click on the arrow on the right side of the Dimension and select the correct Member.

C1j.png

Edit the report as needed.

Exporting to Excel

You can export this report to Excel by hovering over the Export/Import icon ( Export-import_icon.png ) and selecting Export Grid to Excel.

C1k.png

Using Hierarchies

You can use Dimension Hierarchies to organize your view in this report. Dimension Hierarchies are organized views of Dimension Members (for example, you can have a Hierarchy in your Office Dimension that arranges your offices by country, region, and city).

Step 1: You can use any Dimension’s Hierarchies to organize your view. To use a Dimension Hierarchy, move the Dimension from Filters to Rows.

C2a.png

Step 2: Click on the Dimension’s filter.

C2b.png

Example.png Example: You can select an Office Hierarchy to arrange your view by country, region and office, or a certain Account Number Hierarchy to focus on certain GL Accounts.

Step 3: A Select Subset popup appears. Select the Hierarchy you want to view.

A4c.png

Step 4: The reports page reopens. Click the Rerun report icon ( Rerun_report_-_highlighted.png ).

C2c.png

The Dimension Hierarchy appears in the table.

C2d.png

Example.png Example: The Offices by Region Hierarchy organizes the company’s offices into East Coast, South, Midwest, and West Coast regions.

Info.png Please Note: The way a Hierarchy displays Nodes (levels), Members, and Totals depends on how its Node Display Options are set up in the Data Modeler. See Managing Dimension Hierarchies.

Adjusting Account Number Display Settings

You can edit the display settings for your Account Numbers by selecting one of the following options:

  • Account Name Only – Display only the Account Name, such as S-5000
  • Account Description Only – Display only the Account Description, such as Office Supplies
  • Account Name and Description (default option) – Display both the Account Name and Description (for example, S-5000 – Office Supplies)

Example.png Example: Account Name Description (default display option):

R1k.png

See Editing Account Number Display Options in Reports to learn how to change these display settings.

Saving Your Report

Step 1: To save this report and all its settings, click the Save View As icon ( Save_view_as.png ).

C2j.png

Step 2: A Save View As popup appears. Enter the following information in the fields provided:

  • Scope – If you are an Administrator, you can make this view Private (so only you can see it) or Public (so other users can see it). Non-Administrators can only create Private views.
  • View Name – Give this view a name you can easily recognize.

C2f.png

Step 3: Click Save View.

C2g.png

  • A confirmation message appears.
  • The report view is saved.

C2h.png

To edit this view, make the necessary changes and click the Save icon ( Save_line_item.png ).

C2i.png

To save a new view, make the necessary changes, click the Save View As icon ( Save_view_as.png ), and name a new view.

Cde.png

0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.