Show TOC

 Configuration Settings: Financial Close History

 

This document contains configuration information for the Financial Close History app.

SAP Jam Integration

For information on how to configure SAP Jam, see http://help.sap.com/sapjamInformation published on SAP site.

SAP Smart Business Modeler

Before you can use this app, you need to configure it using the SAP Smart Business Modeler.

Note Note

To configure the app, please make copies of the KPI, evaluations, and drill-down configurations provided by SAP, and make your changes in these copies. Also, create your own tiles.

Please do not change the original versions provided by SAP, since new support packages and releases would overwrite your changes.

End of the note.

The KPI has been preconfigured as follows.

KPI: Financial Close History

KPI ID: sap.hba.fcm.HistoricalClosingTask

KPI Description: Financial close history

Goal Type: Minimizing

Data Source

Parameter

Entry

SAP HANA View

(Not applicable)

OData Service

/sap/hba/r/fcc/odata/kpi.xsodata

Entity Set

HistoricalClosingTaskQueryResults

Value Measure

ActualDurationInHours

Semantic Object/Action

<empty>

The following templates for evaluations, drill-downs, and tiles are provided.

Evaluation: Duration in Hours

Evaluation ID: sap.hba.fcm.HistoricalClosingTask.DurationinHours

Evaluation Description: Duration in hours

Data Source

Parameter

Value

OData Service

/sap/hba/r/fcc/odata/kpi.xsodata

Entity Set

HistoricalClosingTaskQueryResults

Value Measure

ActualDurationInHours

Semantic Object/Action

<empty>

Scaling Factor

Auto
Targets, Thresholds, and Trend

Parameter

Value

Goal Type

Minimizing

Value Type

Fixed Value

Critical

Warning

Target

Trend

(Not applicable)
Input Parameters and Filters

The following tables show the input parameters, filters, and some preconfigured example values. Use your own values where required, according to the data in your backend system.

Input Parameters

Parameter

Operator

Example Value

Explanation

P_NumberOfLastPeriods

Equal to

12

Define a time range for the historical data to be displayed by specifying the number of previous posting periods to be considered.

Filters

Filter

Operator

Example Value

Explanation

ClosingTemplateName

Equal to

IDESS

Enter the name of the financial close template that you defined in SAP Financial Closing cockpit Add-On.

SAPClient

Equal to

001

Ensure that SAPClient has been added as a filter.

Enter the client that you use in your SAP ERP system.

An entry in this field is required.
Drill-Down: Duration in Hours

View ID: sap.hba.fcm.HistoricalClosingTask.DurationinHours.DurationinHours

View Title: Duration in Hours

Measures and Dimensions:

Parameter

Value

Dimension

Fiscal Year and Closing Period

KPI Measure

Actual Duration in Hours

Visualization Type:

  • Line

  • Default Colors

Limit Data Records: 200

Drill-Down: Number of Tasks

View ID: sap.hba.fcm.HistoricalClosingTask.DurationinHours.NumberofTasks

View Title: Number of Tasks

Measures and Dimensions:

Parameter

Value

Dimension

Fiscal Year and Closing Period

Measure

Total Tasks

KPI Measure

Actual Duration in Hours

Visualization Type:

  • Column

  • Single Axis

  • Absolute Values

  • Default Colors

Limit Data Records: 200

Drill-Down: Top 5 Tasks with Largest Deviation

View ID: sap.hba.fcm.HistoricalClosingTask.DurationinHours.Top5TaskswithLongestDeviation

View Title: Top 5 Tasks with Largest Deviation

Measures and Dimensions:

Parameter

Value

Dimensions

  • Task Description

  • Task ID

KPI Measure

Actual Duration in Hours

Measures

  • Deviation

  • Planned Duration in Hours

Visualization Type:

  • Table

  • Default Colors

Limit Data Records: 5

Drill-Down: Top 5 Tasks with Longest Duration

View ID: sap.hba.fcm.HistoricalClosingTask.DurationinHours.Top5TaskswithLongestDuration

View Title: Top 5 Tasks with Longest Duration

Measures and Dimensions:

Parameter

Value

Dimensions

  • Task Description

  • Task ID

KPI Measure

Actual Duration in Hours

Measures

  • Deviation

  • Planned Duration in Hours

Visualization Type:

  • Table

  • Default Colors

Limit Data Records: 5

Drill-Down: Posting Period

View ID: sap.hba.fcm.HistoricalClosingTask.DurationinHours.PostingPeriod

View Title: Posting Period

Measures and Dimensions:

Parameter

Value

Dimension

Fiscal Year and Closing Period

KPI Measure

Actual Duration in Hours

Measures

  • Delay of Completion in Hours

  • Planned Duration in Hours

Visualization Type:

  • Bar

  • Single Axis

  • Absolute Values

  • Default Colors

Limit Data Records: 200

Tile

Title: Financial Close History

Subtitle: Duration in Hours

Parameter

Value

Tile Format

Comparison Tile

Navigation

Generic Drill-Down

Semantic Object

ActualDurationInHours

Action

analyzeSBKPIDetails

More Information

For information on evaluations, drill-downs, and tiles, see SAP Smart Business on SAP Help Portal:

  • For SAP NetWeaver 7.31:

    Start of the navigation path http://help.sap.com/nw-uiaddonInformation published on SAP site Next navigation step Application Help Next navigation step SAPUI5 Application Frameworks End of the navigation path

  • For SAP NetWeaver 7.4:

    Start of the navigation path http://help.sap.com/nw74Information published on SAP site Next navigation step Application Help Next navigation step UI Technologies in SAP NetWeaver Next navigation step UI Development Toolkit for HTML5 (SAPUI5) Next navigation step SAPUI5 Application Frameworks End of the navigation path