Display Currency in Dynamic Reports

Display a currency value (such as EURO) aside from LC or CC (Local Currency or Common Currency) in a Dynamic report. Displaying the currency value in a Dynamic Report improves usability and report interpretation.

Prior to this release all currency in a Dynamic report displayed as CC (common currency), LC (local currency) or Interim Currency as shown in the image below.

The same report (shown above) can now be displayed in other currency values as well. The LC and CC is replaced with the actual currency value, the companies are AUD and Euro, and the currency related to each company is shown in the Reporting column.

Additionally, you can display a Reporting dimension in the header or footer of the Dynamic Report by name, code, or label. In the example below, the Reporting dimension is on the report header.

Click the Dimension Display icon.

Display the Reporting dimension in the header by code, name or label as shown below. With this enhancement, it is now easier to identify the currency of the report data.

This feature applies to Financial Reporting Areas. The currency value will be displayed when the Dynamic Report is generated using alternate hierarchies, attributes, attribute hierarchies, and substitution variables. The currency value is displayed for Common, Local, Interim and Reporting currencies.

You must select the Company dimension to appropriately display the local and interim currencies in a Dynamic report. Common currency is obtained from Maintenance > Admin > Configuration Tasks. The Reporting currency data is obtained from the Hierarchy Management screen/setup for the Reporting dimension. Common and Reporting currencies are independent of the Company dimension.

Default Members, Pick List, user point of view (POV) and Bursting/Page selections 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 as well as Dynamic Reports run through a Report Collection, Financial Package, and/or Mapped Reports.

When this feature is not enabled, the current behavior is retained and there are no changes to the Consolidated CC or LC (or any Reporting dimension member) labels displayed in the headers.

When this feature is enabled, report data is retrieved based on the Reporting dimension member selected in the report. However, the report header/footer and row/column headers always display the appropriate Currency property associated with the Reporting dimension member for a leaf member selected on the Company dimension.

In Practice: How to Create a Dynamic Report with Currency Displayed

1. Contact Planful Support to enable this feature if you are an existing customer (prior to the Summer18 release).

2. Navigate to Maintenance > Admin > Configuration Tasks and select the Define Currency Parameters task. This is where your common currency is defined. Enter the common currency code and name information and save.

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

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

5. Select the Company Dimension and Hierarchy. Use the Properties tab to select local and interim currency for each member. For example, for a French (based in France) company, select Euro as the local currency. Optionally select an Interim currency. For example, if you select GPB for Interim currency, you can report in GPB for the French company.

6. In the File Cabinet, click the Add icon to add a new Dynamic Report.

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

8. On the page, column or row, drag and drop the Company dimension. For example, drag and drop the Company dimension and select the French company. The currency displayed in the report for this company member will be EURO. Several examples are provided below.

   Examples

   Example 1: In the image below, the Reporting dimension is used on the page axis or header/footer section of the Dynamic Report.

   

   Example 2: The Reporting dimension is used on the row/column axis of the Dynamic Report. Notice that for Reporting dimension members with currency conversions from LC to CC, LC and CC are replaced with the appropriate currency value. In the image below, approved Initiatives (LC to CC) is displayed as approved Initiatives (CAD to USD) in the report headers.

   

   Example 3: This example shows how the currency displays when drilling down on a Reporting dimension.

   

   In all the above examples, currency Code/Name/Label is displayed based on the configuration applied to the Reporting dimension.

   Contact Planful Support to enable Code/Name/Label display configuration in your Dynamic Reports.

   

   You can change the Code/Name/Label display for the header/footer section using the Dimension Display screen.

   

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.