Release Updates

With this release, we have enhanced the Employee roster by adding a new Currency column, which displays the currency associated with each employee's salary and compensation details. Additionally, the Currency label now shows as Position Budget Entity Currency to improve usability and visibility into compensation data.

The following image illustrates the Employee roster accessed from Structured Planning to open the Planning Control Panel.

The following image illustrates the Employee roster accessed from Maintenance > Workforce Planning Setup.

The Currency column is also available as a drop-down list in the Advanced Search window, allowing you to quickly narrow down employees by their associated currency. The currencies are displayed alphabetically, and a search option is provided for easier navigation. Click here to learn more about Advanced Search.

With this release, we have introduced the Usage Report feature for Substitution and Derived Variables in Cube Settings. This allows users to identify the usage of substitution variables for use cases like the deletion of old substitution variables. The report provides information on whether a variable is referenced or unused.

In Practice: Accessing the Usage Report feature for Substitution Variables

1. Navigate to Maintenance> Cube Settings > Substitution Variables.
2. Select the required substitution variable and click Usage Report.
   The Usage Report screen appears on the right pane.
   
3. Optionally, you can use the following functions:
   • The Export option to download the report.
   • The Filter option to filter usage by artifact type.
     

With this release, basic formatting options have been designed to enhance the presentation and readability of data in External Source Model (ESM) views. Users can now customize their ESM views with the following formatting options:

• Number Formats: Select from various formats such as currency, percentages, red brackets, and decimal places.
• Text Formatting: Utilize options for bold, italics, underline, font color, and background color.
• Header Row: Keep the header row visible while scrolling through large datasets.

These features allow users to highlight important information within specific columns, making it easier to interpret data. The formatting options are similar to those available in Excel, enhancing visual distinction and usability.

Previously, users had limited ability to customize the appearance of their data, which restricted the clarity and impact of their views. With the new formatting options,users can now take the default ESM view, customize as needed, and create copies to present data as they wish, enhancing the user experience and data presentation within External Source Model views. For more details on ESM Formatting, click here.

With this release, we have introduced the Amount Type field in the Verify Data screen, allowing users to choose from three options: Account Based, MTD (Month-to-Date), and YTD (Year-to-Date). The default selection is Account Based. Data in the Verify Data report will now adjust based on the selected amount type, providing enhanced flexibility for users in analyzing and validating data.

In Practice: To Run Verify Data Report

1. Navigate to Maintenance > Report Administration > Verify Data.
   
2. The Selection Criteria screen appears. Select Scenario and Time. These are mandatory fields. 
3. Optionally, select values for other segments like Account, Company, ICSegment, and Reporting.
   
4. Optionally, select Display (Code, Name, or Label) associated with the dimension parameters from the dropdown. 
5. Select an Amount Type (Account Based, YTD, or MTD) from the dropdown.
   
6. The data will be different for different amount types. By default, the Account Based option is selected as the Amount Type.
   1. Account Based - The data will be displayed based on account. For example, the below-selected account (Row 18) is of MTD type (Flow), so the data visible for Account Based and MTD Amount Type will be the same.
      
   2. YTD -The YTD value is always equal to the balance in the current period, as balance accounts show a point-in-time value.
      
   3. MTD - MTD is calculated as the difference between the current period's balance and the prior period's balance.
      
      To learn about Account Based, YTD, or MTD calculation, click here.
7. Click Run. Validate the data from the query results.