Financial Report Run
When you select Financial Report Run (25.16.20) from the menu, the following screen opens:
Report Master Code
Enter the report master code for the report. You can select the code from the lookup. This field is mandatory. The report master determines the layout of the report, such as columns, indents, and style.
Cube Name
Enter the report cube where the report data is stored. You can select the cube name from the lookup. This field is mandatory. The report cube determines where the report amounts are retrieved from and determines the presentation currency and the report calendar.
COA Type
Specify a dimension to explode analysis codes in the report. This field is optional. An exploded analysis code displays each of its components in a separate line. You can specify the dimensions for which the explosion applies. For example, the analysis code SALES is defined for a range of GL accounts. If you do not specify a COA type when running the report, the report displays the value amount of the GL accounts included in SALES. If you specify Entity as the COA type, the report displays the subtotals for each entity of SALES on a separate line.
The report cube must include the dimension. If the data for the dimension is not collected in the cube, the report cannot display details. Dimensions, such as GL account, sub-account, cost center, project, SAF, daybook, entity, layer, and intercompany, are always available in a cube.
Filter Analysis Code
Specify a report analysis code. The code must be type A. The selection of the Filter Report Analysis code is applied to the whole report tree. This field is optional.
Budget
When you run a report that includes a budget column, specify the FRW budget structure to use for the budget data.
From Year
Specify the first year for which to run the report.
To Year
Specify the last year for which to run the report.
From Period
Specify the first period for which to run the report.
To Period
Specify the last period for which to run the report.
To indicate the time range of the report, specify at least one year and period in the From Year/Period or To Year/Period fields. If you only enter the From Year/Period or To Year/Period, the end of the range is automatically set to the same year and period.
To save the report run settings as a report variant, on the header, click the Save As field. Specify a name for your report filter. The next time you run the report, to find your filter in the drop-down list, on the header click the Open button. Click the variant you want to use. The filter fields are filled automatically with the previously saved settings.
To run the report, on the header, click the Run button. The Viewer tab displays the report result.
To print the report, click the Print button. You can also export the report to different formats such as PDF and Excel. Click the drop-down list next to the Run button, select the format you want to export to, and click Run. The report is displayed in the selected format. To export the result to a file, click the Save button.
