Using Advanced Reporting Functionality in Cost Center Reporting

From the Side Panel using the Formatting functionalities, 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.

From the Side Panel using the Layout functionalities, 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.

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.

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

The Cost Center Review Booklet app and the selected page filters can be saved as a custom tile on a selected business page by the user.

Exception reporting allows you to color code report cells based on rules you specify. For example, in the figure for the measure Difference in %, an exception was created which gives at a glance the information whether the difference between actuals and plan is acceptable or not.

With the help of the Navigate To button, you can select a data cell to jump to more detailed reports. For example, you use the Display Line Items in General Ledger app to check the FI line items that make up a value. The system will display all relevant line items, and you can click the document numbers to drill down to the source document.

To download a PDF version of your report output, follow the following steps:

1. Select the Export button.
2. Select Export As….
3. Enter the file settings.
4. Enter the PDF settings.
5. Choose Export.

The PDF is automatically downloaded to your downloads folder.

Save as Tile saves your report settings in a tile and includes in the page of your choice in the SAP Fiori Launchpad.

Steps to be executed:

1. Select the Application.
2. Once the filter elements are completed, click on Go to execute the report.
3. Save the report as a tile.
4. Complete the title and other settings for the custom tile.

You can open this custom tile, for example, at period end closing without any setting changes, which allows you to start data analysis immediately.