Displaying Currency in Dynamic Reports
  • 3 Minutes to read
  • Dark
    Light
  • PDF

Displaying Currency in Dynamic Reports

  • Dark
    Light
  • PDF

Article summary

In Dynamic Reports, you can display actual currency values (such as EURO, USD, or AUD) alongside Local Currency (LC), Common Currency (CC), and Interim Currency. This improves usability and makes reports easier to interpret.

Note:

  • The currency value is displayed for common, local, interim, and reporting currencies.

  • The currency value is displayed when the dynamic report is generated using: Alternate hierarchies, Attributes and attribute hierarchies, or Substitution variables.

  • Default Members, Pick List, user point of view (POV) and Bursting/Page configurations in a Report Collection and Financial Package reports are all honored for the Company dimension in order to display the appropriate currency in a dynamic report.

  • Currency display applies to exports and e-mail attachments. It also applies to dynamic reports run through a Report Collection, Financial Package, and/or Mapped Reports.

Prerequisites and Validations

The following lists of prerequisites and validations are applicable to display currency values in report:

  • To correctly display local and interim currencies, you must select the Company dimension in the report.

  • Common currency is sourced from the configuration in Maintenance > Administration > Configuration Tasks > Define Currency Parameters.

  • Reporting currency is sourced from the Hierarchy Management setup for the Reporting dimension.

  • Both common and reporting currencies are independent of the Company dimension.

Reporting Area Configuration

The Dimension Display icon in the Show/Hide Header & Footer configuration displays the Reporting dimension details. The display options for the Reporting dimension include: Name, Code, or Label.

How to Create a Dynamic Report with Currency Displayed?

  1. Navigate to Maintenance > Admin > Configuration Tasks, and then select the Define Currency Parameters task. This is where your common currency is defined. Enter the common currency details and save.

  2. Navigate to Maintenance > Hierarchy > Hierarchy Management. For Type, select Finance Hierarchies, for Dimension and Hierarchy, select the Reporting dimension.

  3. Click Show. This is where you will set up Reporting members.

  4. Select the Company Dimension and Hierarchy. Use the Properties tab to select Reporting Currency and Interim Currency for each member. For example, for a Mexican company (based in Mexico), select Mexican Pesos as the reporting currency. Optionally select an interim currency. For example, if you select USD as the interim currency, you can report in USD for the Mexican company.

  5. Navigate to Reports. In the File Cabinet, click the Add icon, and select Dynamic Report.

  6. The Reporting Area selection screen appears. Select the required reporting area.

  7. On the page, column or row, drag and drop the Company dimension. In the below example, the report displays data of the company STAL in both MXN and USD. In the report configuration, Consolidated (LC) and Consolidated (CC) members of the Reporting dimension are selected.
    Financial report view comparing Consolidated data in MXN (LC) and USD (CC), with “Reporting” filter and labels highlighted.

Best Practices / Tips

The information below applies to Local and Interim currencies only and does not apply to other Reporting dimension members; including Common and Reporting currencies.

  • If multiple members are selected from the Company dimension on the page axis and the Reporting dimension is included into the report header/footer section, the report displays the Reporting dimension member (e.g. Consolidated LC) selected on the page axis and does not replace with the appropriate currency value.

  • If at least one rollup member exists for the Company dimension on the page/row/column axis, currency value is not displayed.

  • Currency is not displayed if the Reporting dimension members are renamed in the hierarchy or they are used in Static Report Set line names and edited.

  • Currency is not displayed if the Reporting dimension members are used in Static Report Set line names where Single Dimension Multiple Members, Multiple Dimension Single Member and Advanced Rules are defined.

  • Currency is not displayed if the Reporting dimension members are used in a Dynamic Report Set where Advanced Rules are defined.

  • Currency is not displayed when each of the Company and Reporting dimensions are used on the row and column axis. For example, if Company is used on the row axis and the Reporting dimension is used on column axis (or vice versa).

  • Code/Name/Label display configuration is not available in Report Sets.

  • Limitations exist for Local and Interim currencies when Attributes or Attribute hierarchies are used in a report.


Was this article helpful?