Application Details in HFM Insights

When you click an application icon, a new tab opens, which displays additional detailed metrics for the application running on that server.

The tab title is <Application Name>@<ServerName>.

• Show - Filter for time periods to display. By default, data is displayed for the last 14 days.

• Refresh- Select Manual or Auto Refresh. The default value is Manual.

The Application page displays the following sections:

Application Summary

• Application icon, application name, and server name

• Status Overview, as shown on the main page

• Application Dimensions - Application Dimensions and total members in each dimension

• Restart - Restarts the XFMDatasource process

Statistics

The Statistics section displays detailed data statistics based on a selected Scenario and Year combination. You can choose when to manually update the statistics.

To update Statistics:

1. From the Statistics section, click the Data tab.
2. Click the Member Selector , select a Scenario and Year, and click OK.
3. Click the Execute button to run the process and return statistics on the selected Scenario and Year combination.

Note:

When you click the Execute button and update statistics, the button is disabled for a certain period of time while the process runs. The task runs in the background, and you can navigate to other parts of the application while it is running. When it is done, the button is re-enabled and the table is refreshed with the updated statistics. You can also click Refresh to see the updated values.

If there are no records in a particular table, the system does not display any statistics for that table.

Data tab

• Data (DCE and DCN total record count per Scenario/Year combination)

• Invalid records (invalid member ID), DCE and DCN only, Total count only (not per entity)

• Near Zero Value Records for all periods

• Near Zero Value Calculated Records for all periods

• PFlow History (per Scenario/Year)

• Input Data (if any period in the year is Input or Line Item Details)

Table Count tab

The Table Count tab displays record counts of the following Oracle Hyperion Financial Management system tables and the times they were last executed.

• Task Audit

• Data Audit

• System Messages (Error Log table)

• Rules Profile data

Performance Overview

The Performance section displays a chart based on the same KPI as on the main screen.

User

Frequent users - Bar graph displaying the top 10 users with the maximum number of sessions over a time period, based on the Task Audit data. By default, data is displayed for the last 14 days, but you can change the time period using the Show filter.

Session Details - Details of user sessions, including User name, Time Started, Time Ended, and Duration. You can sort any of the columns.

You can filter by User. In the User Search box, type a full or partial user name.

In the Duration Search box, to view only users logged in for a specific duration, enter a time value. For example, to view users logged in for 1 hour, enter 1h. You can use the percent sign (%) as a wildcard. For example, to view users with a duration less than one hour, in the Search box, enter %h.

Memory

The Memory section displays a graph of system memory parameters, based on System Messages data. It includes:

• Total Memory

• Used Memory

• NumCubesInRAM

• NumDataRecordsInRAM

• NumRecordsInLargestCube

• MinDataCacheSizeInMB

• MaxDataCacheSizeInMB

• MaxNumCubesInRAM

For details on memory parameters, see Available Configuration Settings.

Tasks

This section contains four tabs that display Task information.

Tasks View

The Tasks view displays the top 10 frequently executed tasks in the selected time span, based on Task Audit data. For example, you can quickly view the number of Logons, or Consolidations that occurred during the last two weeks.

• Metric - filter for frequency time metric:

  • Frequency - Count of tasks that occurred in the selected time span

  • Total Time - Total time taken by the tasks that occurred in the selected time span

  • Average Time - Average time taken by the tasks that occurred in the selected time span

• User - filter by User who performed the task. In the User Search box, type a full or partial user name, or use the percent sign (%) as a wildcard.

Users View

The Users View tab contains a bar chart showing the top 10 users who performed a particular task.

• Metric - filter for task times:

  • Frequency - Count of tasks performed by the users in the selected time span

  • Total Time - Total time taken by the tasks performed in the selected time span

  • Average Time - Average time taken by the tasks performed in the selected time span

• Tasks - filter by Task. By default, Consolidation is selected.

Months View

The Months View displays a bar chart showing a particular task on a monthly basis. You can compare task activity by month.

• Metric - filter for task times:

  • Frequency - Count of tasks performed for a selected month or months

  • Total Time - Total time taken by the tasks for the selected month or months

  • Average Time - Average time taken by the tasks for the selected month or months

• Tasks - filter by Task. By default, Consolidation is selected.

Task Details

This tab displays detailed information about each task, based on Task Audit data. It includes the User name, Activity name, Time Started, Time Ended, Duration, and Description. You can sort any of the columns.

You can filter by User, Activity, Duration, and Description.

Errors

The Errors section displays the top 10 frequent errors, based on System Messages data.

• Error Frequency - Displays the Error Code. You can hover over the error code to view its description.

• Error Details - Displays the Error Code, System Message Summary, Date and Time of the error for the selected application on the selected server for a particular span of time. You can sort on Error Code and Date-Time. You can filter by Error Code and System Message Summary.