Configuring Reports and Statements

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 that follow.

In the Lens Configuration tab, Click Add Lens to add a lens derived from Analytics Studio or a formula row to your report. The configuration options displayed under Measure Columns, Formatting, and Soft Dates cannot be accessed until you have completed this step. You can toggle the order of the lenses in your report using or .

1. Enter a Section Name under which the data derived from your lens is displayed in your report.
2. Enter an Alias for your lens. 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.
3. Select your lens from Analytics Studio. 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 and review your selected lens in Analytics Studio.
4. Select Visible if you want to display the rows derived from the selected lens. Otherwise, leave the field deselected. In either case, the data is available for use in a formula.
5. [Optional] Select Highlight if you want to highlight the rows derived from the selected lens. Otherwise, leave the field deselected.
6. [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.

1. Click Add Column to add a dimension column to your report.
2. Select your dimension from Analytics Studio. You can toggle the order of the lenses in your report using or .
3. [Optional] Select Pivot. 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.

Click Add Column to add a measure column to your report.

1. Enter a name for your measure column.
2. Enter an alias for your column. This is required to perform calculations using values derived from a unique row of data in your lens.
3. [Optional] Enter a calculation to apply to your measure column data. 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) or measureColumn(A). Alternatively, click to select a predefined calculation using the drop-down list of options. See Adding Calculations to Reports for more information on adding calculations to your measure columns.
   
   Note: The range of predefined calculations available when configuring measure columns with Pivot Table selected might be reduced, due to an enhancement to improve the performance of Financial Report Builder. Following this enhancement, the number of rows read when your selected report is open for configuration is restricted to 25.
4. [Optional] Select the Apply Row Calculation checkbox if you want to selectively apply row calculations to your measure columns. If the checkbox is not selected, calculations are not performed at the intersections between a row calculation and a column calculation.
5. [Optional] Use the Show checkbox to toggle between hiding and showing a specific measure column. By default, the checkbox is selected.

1. Select whether to activate soft dates in your report using the Soft Dates toggle.
2. 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.
   
3. Select your time period type. Available options are "Week" or "Month".
   
4. 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.
   
   Note: This is to avoid errors due to the handling of dates in Analytics. For example, a week intended to be grouped as week one of 2020 might be interpreted by Analytics as week 53 of 2019. A 53-week year can occur under circumstances such as a leap year. These normally begin on a Wednesday or Thursday. If you have a year that lasts 52 weeks and one day, this would normally be considered a 52 week year. The extra day would fall into the last week, or the first week of the following year. However, Analytics treats any date past the fifty-second week as belonging in week 53.
5. [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.
6. [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 .
   
   Note: If you add two period or period groupings with identical labels, the latter overwrites the former if you apply pivoting to your report table. For example, if you add two instances of "Current Year", covering rolling periods, and rolling periods cumulative, the second would overwrite the first if you apply pivoting.
1. [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.
   
   Note: If you have applied custom labels to your Period Formats, these labels are displayed in the report if you select the Pivot Table checkbox in the Soft Dates tab.

You can format the presentation of your report after you have created it by clicking .

• Table Height. Available options are: Small, Medium, and Fit Content.
• Column Density. Available options are: Compact, which has less space between table elements, and Comfy, which has more space between table elements.
• Columns Locked. Available options are: Yes or No. This selection locks the data in the columns in place so you can see all your groupings when scrolling around the table. This only applies to the dimension and date columns. Measure columns are not affected by this selection.
• Show Grid. Adds borders to rows in your report. Available options are All, Only Totals and Subtotal rows, and None.
• Decimal Precision. Available options are: No decimal places, One decimal place, and Two decimal places.
• Number Scaling. Available options are: No scaling, Thousands, and Millions.
• You can choose to display negative values in black or red, and whether to prefix these values with a minus, or enclose them in parentheses.
• Select Reverse Sign to display negative numbers as positive numbers in your report, and vice versa.

The following types of drill are available in Financial Report Builder:

• Drilling at multiple levels to your report or statement, to obtain a deeper view of your data.
• Drilling through to view details of documents in their source app, such as Accounting. If your selected lens contains name or ID fields, then these are automatically drillable to their source app, and are blue and hyperlinked. To make a non-drillable field in your selected dataset drillable, see Drilling to Source Documents.

Applying Drilling

When you configure drilling in Financial Report Builder you create a hierarchy of drill levels between different tables. Configuration entails mapping fields from one table to another.

Filters added to your source lenses in Analytics Studio determine the data displayed in your drill tables. We recommend you review any filters you have applied to your source lenses if your data does not display as expected in your report.

To apply drilling in your report or statement:

1. Click to open the Drill Menu.
2. Click Add Drill Mapping.
3. Select the dataset for your drill.
4. The Drill Configuration tab now displays. You can view an explanatory video by clicking . You must complete field mapping between the following table datasets:

• Source Table Dataset: the high-level source table you are drilling from.
• Target Table Dataset: the lower-level source table you are drilling to.
  
  Note: If your source dataset is the same dataset used in your financial report or statement, then your source and target table datasets are automatically populated. You can specify a different dataset if required. If your target table dataset differs from your source table dataset , you must manually correlate your source and target fields. For example, if your source field is Company Name, you must then select the field equivalent to Company Name in your target table dataset.

5. Navigate to the Lens Configuration tab.
6. Select the lens in Analytics Studio that contains the data you want to drill to from your source table. Section, Alias, and Lens fields are automatically populated if you have selected a preconfigured report such as Balance Sheet, Income Statement, or Trial Balance. For example, Trial Balance uses the DrillLens from Analytics Studio that contains transaction data from the Financial Transactions dataset.
7. [Optional] Click Add Drill Column to add further drilling to your financial report or statement, by repeating steps 2-3. If you have added filters to your source data table, such as Company or Dimension, you must also create mappings for these fields between your source and target tables. By default, your first filter is automatically mapped, but you must manually create mappings between any additional filter components.

After your drilling is applied you can identify a drillable cell in a Financial Report Builder table if your cursor changes from an arrow to a hand when you hover over it and the data in the cell is underlined. Data is underlined in red or black, depending on the color you have selected to differentiate between positive and negative numbers in your report. A breadcrumb is displayed on top of the table to help you navigate between drill levels and back to the source table.

Removing Drilling

Return to your report and click | Remove Drill to remove your drill.