Reporting Cost Center Data at Period-End

Objective

After completing this lesson, you will be able to report Cost Center Data at Period-End

Cost Center Review Booklet

The Cost Center Review Booklet allows overhead accountants to effortlessly display, analyze, and validate cost center data through predefined reports.

This figure gives an idea of the most important elements in the Cost Center Review Booklet: the Business Page Groups and the Side Panel.

The app displays information about actual and planned costs and groups several predefined report business pages under the Actuals and Plan/Actuals page groups. It offers transparency in cost center reporting tabled in a user-friendly interface.

Cost Center Review Booklet - Key Capabilities:

  • Create and Manage Views
  • Global Filters and Page Filters
  • Business Pages
  • Columns and Rows
  • Side Panel
  • Layout
  • Context Information
  • Export.

Key Capability: Create and Manage Views

The figure shows how to create a view, where to maintain it and where to select it within the Cost Center Review Booklet.

You can save and reload customized business pages, share them with others, or set them as default.

After you apply filters and structure the business pages with the rows, columns, and dimensions that you want, you can then save the pages as a view.

Saved views can then be selected to reload all the pages in the review booklet as you had saved them.

Depending on your authorizations, you may be able to save a view as Public so that other users can use it as well.

To save a view, choose the dropdown list of views and select Save As.

When you save the view, you can also selectSet as Default so that it appears by default every time you enter the app.

Key Capability: Global Filters and Page Filters

The figure explains where to find the Global Filter and the Page Filter in your Cost Center Review Booklet.

You can use global filters to apply to all business pages and underlying data providers, and page filters for specific pages. This allows you to retrieve desired data and display it in various ways, making it easier to analyze and compare information.

Global Filters apply to all business pages in the app and underlying data providers. You define them in the filter bar.

Page Filters only apply to a specific business page and underlying data provider.

Some variables for page filters are already derived based on your selection of global filters. You can display them in the Side Panel. In addition, you can apply page filters for specific dimensions in the report.

To apply Page Filters, you can use one of the following methods:

  • In the table, right-click a specific dimension (one of the table headers) and choose Filter Items.
  • In the Side Panel, choose Page Filters and Add to open the Select Dimension dialog.

Note

At any time, you can get an overview of which global and page filters are currently being used for a given page by checking the Context Information in the Side Panel.

Key Capability Business Pages

This figure shows which Business Page Groups and within one group which Business Pages are preinstalled in the Cost Center Review Booklet.

In review booklets, financial data is presented on predefined business pages, which are organized in business page groups. They are useful for easily accessing and reviewing financial statements, tables, comparisons, and charts and help to streamline financial analysis and decision-making processes.

Key Capability Columns and Rows

You can adjust the columns and rows in the report to display your data in various ways.

This figure shows all possible features that can be used by right-mouse click in the Row Header or Column Header of the Review Booklet Layout.

Columns

Right-click the following UI elements to use the available options:

  • A dimension to add, exchange, or remove a dimension
  • A dimension to change the display and sorting properties •A data cell to navigate to other apps.

Rows

Right-click a measure or structure to do the following:

  • Change the decimals or scaling settings •Change the filter settings
  • Add dimensions
  • Move and sort the measures
  • Navigate to other apps.

Note

You can select any cell in the grid to get a list of various actions to make, such as adjusting the structure of the grid or navigating to other apps. Depending on the content of the cell, you get a different list of options to select from. This allows you to flexibly display data, structure the pages, and navigate based on the context of the content in individual cells.

From your review booklet, you can navigate to other apps. This navigation is context-sensitive: The booklet settings (for example, the global filters and page filters) are automatically applied in the app that you navigate to.

Key Capability Side Panel: Page Filters & Formatting

The figure shows the settings of the Page Filters and Formatting Feature in the Side Panel.

The following options in the Side Panel on the right side of the screen are available:

  • Page Filters
  • Layout
  • Formatting
  • Context Information
  • Export.

Page Filters:

You can select the filters that have to be applied to the business pages.

Formatting

On theFormatting Panel, you can configure the appearance of numbers as well as conditional formatting rules.

The Panel is organized into two sections:

  • Number Format
  • Conditional Formatting.

Number Format:

First you decide for which measures you want to customize the formatting for your numbers. You can either do the customizing for all measures or for individual measures. Then you customize the scale and scale format, and choose the number of decimal places, and the sign.

Conditional Formatting :

If you want to highlight specific information, you can create Conditional Formatting rules. Conditional formatting covers several options, including thresholds and assigned colors. You can also save your conditional formatting as part of a private or public view.

Key Capability: Layout

This figure shows the possible settings using the Layout feature in the Side Panel.

Using the Layout feature in the Side Panel, Dimensions and Measures can be added to the table and you can decide whether they are displayed as columns or rows.

You can also create calculations based on the measures of your data source and add them to your table.

In the Measures section of the Available Objects list, click Add Calculation.

In the Create Calculation dialog, you create formulas by adding functions, operators and conditional operators listed in the left-hand-side panel or by typing in the formula directly in the editor.

The formula editor supports the following functions, operators and conditional operators:

  • Functions: IF, ISNULL, NOT, ABS, EXP, SQRT, GrandTotal, %GrandTotal, MOD, and POWER
  • Operators: +, -, *, /, and **
  • Conditional Operators: AND, OR, =, !=, <, <=, >, and >= .

You can use the newly created calculated measures in the table.

Key Capabilities: Context Information & Export

This figure gives an example of a Context Information and shows the possibilities you have when you want to export your Cost Center Review Booklet.

Context Information :

This is where you find out how the displayed data is selected, for example, the applied global filters and page filters.

Export:

You can export your data to a spreadsheet or PDF file.

The figure describes the additional analysis possible with AI-assisted Business Insights.

You can create an AI-generated analysis and summary of your data. Depending on your business role, you can use specific AI features if you want to quickly interpret and efficiently analyze the data in review booklets.

The figure above shows what the AI-assisted Business Insights feature looks like in the Cost Centers Review Booklet.

On the relevant page for which you want to have data analyzed, choose the Business Insights button on the side panel. You can then select different quick actions to analyze and summarize the data under different aspects.

Based on the data displayed, you can do the following:

  • Analyze table data.
  • Summarize table data.
  • The AI-generated summary is written in natural language.
  • Copy, export, and share results directly from the app.

Use the Cost Center Review Booklet for Period-End Reporting

Log in to track your progress & complete quizzes