Configuring Financial Report Tables
After creating your financial statement or customized report, you must configure the components that comprise the tables displayed in it.
Table Menu
Use the Table Menu to open the table configuration modal. Once the table configuration modal is displayed, you can select the specific tab in the modal you want to land on through this menu, and you can switch between tabs by clicking each tab name.
Edit access is required to configure reports and statements. If your org does not have the following icons, you might not have the required access:
Table Configuration
This tab enables you to apply the following global settings to your report:
- Pivot Table. Select this option organize the data displayed in your report columns. For example, if you pivot on the “Company” dimension, a column is displayed for each company in your report.
- Table Name. Specify a name for the table displayed in your report.
- Dataset. Select the dataset you want to use as the source of data for your report. Click to change your selected dataset.
Editing the Dataset Used by the Table
Select the dataset containing the lenses you want to use as the source of data for your report or statement. Only lenses derived from this dataset are available for selection in the configuration options.
You can add or change the dataset used by the table by following these steps:
- From the Table Configuration tab, click next to Dataset to open the Edit Dataset modal.
- Click Edit.
- Use the search field to look for and select the dataset you want to assign to the report.
- Click Next to confirm your selection. This action returns to the Table Configuration tab for the table using the new dataset. Click Save to complete the process.
Editing the Financial Report Table Name
You can edit the name of your Financial Report Tables by following these steps:
- From the Table Configuration tab, enter a new name for your table by clicking in the appropriate field.
- Click Save to apply the name you entered to the table.
Lens Configuration
Lenses are the source of data for your statements and reports and are derived from Analytics Studio. In the Lens Configuration tab, click on the tool bar to add any of the following to your report:
- A lens derived from Analytics Studio, click
- A calculation row, click
- A blank row, click
The configuration options displayed under Measure Columns, Formatting, and Soft Dates cannot be accessed until you have completed your lens configuration setup.
You can toggle the order of the lenses in your report by selecting the row you want to move and clicking or on the toolbar.
You can remove all the lenses and calculations in the Lens Configuration tab by clicking Remove All. To remove a single lens or calculation click next to the row you want to remove.
You can repeat the label for a selected grouping in your report by clicking on a non-formula row and selecting . For more information on this feature see Formatting Reports.
The following filter logic operators applied to lenses in Analytics Studio are supported by Financial Report Builder: AND, OR, NOT, and parentheses. You can apply these operators these lenses in Analytics Studio to control the data displayed in Financial Report Builder.
You can display positive values derived from your selected lenses as negative values, and vice-versa, by selecting on the toolbar on the Lens Configuration tab. This setting applies to individual lenses only. To reverse signs globally in your report, use the Reverse Sign setting in Formatting Measure Column Numbers.
To configure a lens perform the following steps:
- Enter a Section name under which the data derived from your lens is displayed in your report's table by clicking in the appropriate field.
- Enter an Alias for your lens by clicking in the appropriate field. The alias you specify for your selected lens enables you to perform calculations using values derived from a unique row of data in your lens.
- Select your lens from Analytics Studio by clicking in the appropriate field. If you have applied a query limit for your selected lens in Analytics Studio, then this limit is applied to the data displayed in your report. You can click to open, review, and edit your selected lens in Analytics Studio, or create a new lens for use if required.
- Click in the Lens Configuration tab toolbar if you want to display the rows derived from the selected lens. Otherwise, leave the field deselected, in which case only derived values are displayed. In either case, the data is available for use in a formula.
- [Optional] Click Add Calculation to create a formula row to apply a calculation to the data contained in your lens. For more information on supported formulas, see Adding Calculations to Reports.
Configuring Dimension Columns
The Dimension Columns comprise the columns into which your report is ordered. You can pivot the data displayed in these columns.
To configure dimension columns perform the following steps:
- Click to add a dimension column to your report.
- Select your dimension from Analytics Studio by clicking in the appropriate field. You can toggle the order of the lenses in your report using or .
- [Optional] Enter a custom label to display in the table by clicking in the appropriate field.
- [Optional] Select Pivot Table in the Table Configuration tab. This organizes the data displayed in your report columns. For example, if you pivot on the "Company" dimension, your report displays a column for each company. See Pivoting Report Data for more information.
Configuring Measure Columns
The Measure Columns tab contains the columns into which your report is ordered. These columns are contained in two tables. You can apply a range of formatting options to control the appearance of the columns in both these tables.
- Measure Columns. This is a non-editable list of all the measure columns contained in your report.
- Measure Calculation Columns. This enables you to pivot and apply calculations to the data displayed in your report.
To configure measure columns perform the following steps:
- Click to add a measure column to your report.
- Enter a name for your measure column by clicking in the appropriate field.
- Enter an alias for your column by clicking in the appropriate field. This is required to perform calculations using values derived from a unique row of data in your lens.
- [Optional] Enter a calculation to apply to your measure column data by clicking in the appropriate field in the Measure Calculation column. This opens the Formula Builder window. You can enter your own calculation using a measure derived from an Analytics Studio lens, or using the alias of another measure column. For example,
measureColumn(sum_ValueDual_1)
ormeasureColumn(A)
. Alternatively, click to search for a predefined calculation. See Adding Calculations to Reports for more information on adding calculations to your measure columns. - [Optional] Select the appropriate option for the calculation precedence using . The options displayed determine which calculation is performed if a row calculation and a column calculation occupy the same cell.
Available options are:- Apply Column Formulas to Rows
- Apply Row Formulas to Columns
- Don't Apply Column Formulas to Rows.
- Apply Column Formulas to Rows
- [Optional] Use the Show checkbox to toggle between hiding and showing a specific measure column. By default, the checkbox is selected.
- [Optional] Specify which calculation takes precedence if a row calculation and a column calculation inhabit the same cell. Available options are Row, Column, and None.
- [Optional] Click to suppress row calculations for selected measure columns.
Formatting Measure Column Numbers
If required, you can apply a range of formatting options to control the presentation of numbers in your report.
To do this, perform the following steps:
In the Measure Columns or Measure Calculation Columns table, click an entry in the Number Format Column. The following formatting options are available:
Option |
Description |
---|---|
Number Scaling |
|
Decimal Precision |
|
Currency Symbol |
|
Configuring Soft Dates
You can select the soft dates you want to apply to your report or statement.
To configure soft dates perform the following steps:
- Select whether to activate soft dates in your report using the Soft Dates toggle.
- Select whether to show any soft date rows with a value of zero in your report using the Show Empty Rows toggle.
- Select a dimension such as Financial Period Start date to begin configuring your soft dates We recommend that you do not specify a date dimension elsewhere in your report configuration options or selected lenses, otherwise your data might not display as expected.
- Select your time period type. Available options are "Week" or "Month".
- Select the start of your selected time period type. If you select Month, you can select the month on which you want to start. If you select Week, you cannot specify a start for this time period type.
- [Optional] Select a current period date override. You can add a date to override your current period date selection. Your selected time and period type are then adjusted relative to this date. For example, if you selected February 17, 2021 after selecting "Monthly" and "February", this would then ensure that February 17 is defined as your current day. The months in your report would then be calculated relative to this selection, with March 17, 2021 calculated as the start of your second month.
- [Optional] Click Add Period Format to select one or more periods, or aggregations of periods, such as "Current Quarter". You can toggle the order of your selected period formats in your report using or .
- [Optional] Enter a custom label to change the period formats displayed in your report. For example, you might select "Last period (cumulative)" as a period format, but want to display this as "Opening" in your report.
Configuring Subtotals
Subtotal columns are optional columns that, when enabled, allow you to add a subtotal for each dimension value split within that dimension. For example, if the dimension being subtotaled is "Trial balance 2" and it contains values of "Current assets", "Fixed assets", and "Other assets", then a subtotal is generated for each of these categories. Dimensions appearing in the right hand column are those set on either the lens, the dimension column, or in the soft date column. This dynamic list reflects the dimensions in your table when viewing your report. If no subtotal columns appear in this tab, try modifying or adding dimension columns or soft dates to your table. By default, subtotals are added to the table at the bottom of the category being subtotaled.
To configure subtotals perform the following steps:
- Select the Subtotal checkbox for the columns you want to add subtotals to.
- [Optional] Enter a custom label to display in the table by clicking in the appropriate field.
- [Optional] Select Show Above to override the subtotals default behavior and display the data in the first row for each category.
Formatting
You can control the appearance of the data displayed in your reports using the options displayed in the formatting toolbar. For more information, see Formatting Reports.