Configuring Reports and Statements

Use these components to customize and configure your Financial Reports and Statements.

Filters

The sidebar on a financial statement or customized report provides you with a selection of filters to customize your report view. You can hide this sidebar to maximize the space available in the page by clicking Side chevron.. You can also refine the data the report displays by creating and configuring filters.

To create and configure your filters perform the following steps:

  1. Click Lightning cog icon..
  2. Specify a display name for your filter.
  3. Select the field type for the filter you want to create. The available types are: Dimension, Measure, Soft Date, and Date.
  4. Select your required lens. The grouping you have specified for this lens in Analytics Studio is displayed in the field section below.
  5. In the section corresponding to the field type, select the fields you want to filter by.
  6. Specify filter logic operators. Available options are the following:
    • For Dimension type fields: Contains, Equals, Not Equals, Is Null, Is Not Null.
    • For Measure type fields: Equals, Not Equals, Between, Greater Than, Greater Than Or Equal To, Less Than, Less Than Or Equal To, Is Null, Is Not Null.
    • For Date type fields: Between, Greater Than Or Equal To, Less Than Or Equal To, Is Null, Is Not Null.
  7. [Optional] Select the Default Selection for the filter that matches your filter logic. This option is disabled for "Is Null" and "Is Not Null" operators.
    8. Note: You can select one or more values using the "Equals" and "Not Equals" operators, also the "Contains" operator enables you to specify a single text value. For example, if you specify the text "Merlin" using the "Contains" operator, the filter returns records such as "Merlin Auto Spain", "Merlin Inc", and "Merlin Enterprises".
  8. Click Save to create the filter.

After a filter is created you can modify it, to do so click Edit icon. to open your selected filter in Analytics Studio. Once you have finished modifying your filter refresh the web browser page for the report to update it.

For example, after configuring your Report Component, you can create a Company Name drop-down filter in the sidebar to refine the data displayed by the report to show only information related to your selected companies.

You can create up to five filters for reports created using the Financial Reports tab. You can add more filters by editing the Lightning page layout for your report. For more information on editing the page layout, see Configuring Financial Report Builder.

Tip:

You can view details of all filters applied to your report or statement by clicking Filters Set. Your report displays an initial preview of the current period date override selected for your report or statement, if applied, and the total number of Analytics or Financial Report Builder filters you have added. If you click Filters Set this opens a Table Filters modal window with further details of Analytics, Financial Report Builder, and Financial Report Builder Drill Filters. You cannot edit the information displayed in this modal window, but you can expand each filter display container to enable easier viewing by dragging the corner Drag to resize the window..

Financial Report Table

The Financial Report table displays your financial report, you can further configure this table to customize it to your specific needs using the following features.

Editing the Financial Report Table Name

You can edit the name of your Financial Report Tables by following these steps:

  1. From the Financial Report Table Configuration, click Edit Table Name to open its respective modal.
  2. In the Edit Table Name modal, enter a name for your table in the available field.
  3. Click Save to apply the name you entered to the table.

Report Component Configuration

After creating your financial statement or customized report, you must configure the components that comprise the tables displayed in it.

The following components are available for configuration:

Pivoting Report Data

You can select Pivot to pivot the data displayed in your table columns. Pivoting organizes the data displayed for a selected dimension according to your reporting requirements. The ordering of columns in a report or statement means that the column with the dimension you want to pivot must be placed at the end of your list of configured columns. In your report or statement, this pivoted data is displayed on the right side of the table. You can only pivot by one dimension at a time in your report or statement.

Note:

Pivoting applied to your lenses in Analytics Studio is not applied to the data displayed in your report columns. You can only pivot your data in your report by selecting Pivot in the Dimension Columns tab.

Pivoting Time Period Type Lenses

If you apply pivoting to more than one time period type lens, where these lenses have different periods with null values, then the columns displayed in your report will not be presented in chronological order. To resolve this issue, see Pivoting Time Period Type Lenses.

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.

Note:

If you change your dataset after configuring the options in Lens Configuration, Measure Columns, Soft Dates, and Formatting, then your selected configuration is deleted.

In the Lens Configuration tab, Click Add Lens to add a lens derived from Analytics Studio or a formula row FX icon. to your report.

Warning:

Financial Report Builder does not support lenses created from multiple datasets.

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 Upward chevron. or Downward chevron.. 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 Reverse Sign in 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.

Note:

When selecting a lens with an AggregateFlex query, your lens must contain measures, or measures and dimensions.

To configure a lens perform the following steps:

  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 Format brush. 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.

To configure dimension columns perform the following steps:

  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 Upward chevron. or Downward chevron..
  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.
Tip: You can select dates as part of your dimensions, in addition to the full date you also have available partial dates. If the full date did not contain information for the selected partial date then zeroes are displayed. For example, you can select Financial Period End Date to display the full date "2020-12-31" in a dimension column. Alternatively, you can select Financial Period End Date (Year) to display only the year "2020" in the column.

To configure measure columns perform the following steps:

  1. Click Add Column to add a measure column to your report.
  2. Enter a name for your measure column.
  3. Enter an alias for your column. This is required to perform calculations using values derived from a unique row of data in your lens.
  4. [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 Add icon. 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.
  5. [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.
  6. [Optional] Use the Show checkbox to toggle between hiding and showing a specific measure column. By default, the checkbox is selected.

To configure soft dates perform the following steps:

  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 Upward chevron. or Downward chevron..
    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.

The Current Period Date Override filter enables you to override the default date used by the report. This setting is used in conjunction with soft dates. If soft dates are not configured on your reports the override filter can't be used. When both the soft date in the table configuration and the current period date override filter are enabled, selections in the override filter have precedence.

To configure an override date perform the following steps:

  1. Enable the Current Period Date Override in your report using the respective checkbox in the page layout.
  2. In the report's filter panel, Current Period Date component displays by default today's date.
  3. Use the component date picker to select the override date. This filter should be used in conjunction with the Soft Dates filter to display the data according to your needs.
Note: This filter doesn't automatically update results displayed in drill tables. If you want to modify the date override in a drill table you must close the table and implement your desired changes from the report screen. For example, in a report you can select an override date, this filters the data displayed according to your selection. If you then drill into any measures your override selection is passed down into the drill table, however, if you then decide to modify your date override filter this change is not automatically updated in your drill table, you must close the drill table and reopen it from the report for the change to take effect.

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

  • 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.
  • Ignore Warnings. Available options are: Yes or No. This selection allows you to ignore any warning messages presented on the display table. The ignored messages are not shown in the table view and this selection persists after you close a report and reopen it.
  • 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 all negative numbers as positive numbers in your report, and vice versa. To reverse the signs on an individual lens, use the Reverse Sign option available in the Lens Configuration tab.

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.
Note:

You cannot drill SAQL lenses. This is because Financial Report Builder cannot determine the underlying dimensions their output fields relate to.

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 Drill menu. 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 Video tooltip icon. . 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.
  1. Navigate to the Lens Configuration tab.
  2. 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.
  3. [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 Drill menu. | Remove Drill to remove your drill.
    • Tip:

    If the data shown in your different drill levels does not display as expected, this might be due to filters applied to your selected lenses in Analytics Studio. For more information, see Drilling on Lenses with Filters Applied.

    Exporting Reports and Statements

    After you have configured your report or statement, you can download it in CSV or PDF format. To do this, perform the following steps:

    1. Click Export from your report.
    2. [Optional] Specify a title for your report.
    3. [Optional] Select whether you want to include filters in your downloaded report. Note that only filters that alter the data displayed in your report can be included in your download file.
    4. Specify your file download format. Available options are CSV and PDF.
    5. Specify the report details you want to include in your file download. Available options are:
      1. Data with Filters. This is a complete report.
      2. Data with Period Override. This is a report with data tables, data table titles, and a current period override, if applied.
      3. Data Tables Only. This is a report containing data existing tables only, and no additional information.
    6. [PDF only] Select Portrait or Landscape as the orientation for your downloaded report.
    7. [PDF only] Select your paper size. Available options are Letter, A4, and Legal.
    8. [Optional, PDF only] Select whether to add a logo image to your exported file.
    9. [Optional, PDF only] Select whether to add row identifiers to your exported file.
    10. [Optional, PDF only] Select your logo image from the drop-down menu.
    11. Click Download.

    Adding or Editing Logo Images

    A default FinancialForce logo is provided by default in the Winter 2022 release of Financial Report Builder. This default logo is added using a custom setting. Any subsequent logos are added or deleted using the standard Salesforce functionality described below.

    To enable the default FinancialForce logo for use, see Enabling the Default Report Logo Image.

    To add or edit a logo image to replace the default FinancialForce logo image, perform the following steps:

    1. From the App Launcher, navigate to Files.
    2. Upload or delete your logo image as required.
    Warning:

    The size of your logo image must not exceed 3 MB. Uploaded logo images that exceed this size are not available for selection in the logo picker.

    Emailing your Report

    If you want, you can email a copy of your report in your specified file format to one or more Salesforce users.

    1. Complete the following email fields:
      1. Recipients. This is a mandatory field.
      2. Subject.
      3. Body.
    2. Click Download. You will receive a confirmation message notifying you that your report has been emailed successfully.

    Export Restrictions

    When exporting your reports and statements the following restrictions apply.

    File Export Restrictions

    Format

    Restriction
    PDF Non-Latin characters are not currently supported in exported reports and statements.

    If the number of columns contained in your report exceeds the limit of the page layout, these columns are spread out across multiple pages. This can lead to columns associated with each other for reporting purposes being disassociated in the exported report. To avoid this problem, we recommend you select the Add Row Identifiers to Exported File option. This inserts a row index number for each row of your report.
    CSV To avoid errors, we recommend you do not try to export unconfigured reports using this file format.