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.