Configuration Settings: Liquidity Forecast

This document contains configuration information for the Liquidity Forecast app.

SAP Jam Integration

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

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: Liquidity Forecast

KPI ID: sap.hba.ecc.cashmgr.analyzeliquidityforecast

KPI Description: With this app, you can forecast the liquidity trend for future days.

Goal Type: Maximizing

Data Source

Parameter	Entry
SAP HANA View	(Not applicable)
OData Service	/sap/hba/r/sappl604/odata/fin/kpi.xsodata
Entity Set	CashLiquidityForecastQueryResults
Value Measure	BalanceAmountInDisplayCrcy_E
Semantic Object/Action	<`empty`>

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

Evaluation: Forecast in 30 days

Evaluation ID:sap.hba.ecc.cashmgr.analyzeliquidityforecast.LiquidityForecast30days

Evaluation Description: With this app, you can forecast the liquidity trend for future days.

Data Source

Parameter	Value
OData Service	/sap/hba/r/sappl604/odata/fin/kpi.xsodata
Entity Set	CashLiquidityForecastQueryResults
Value Measure	BalanceAmountInDisplayCrcy_E
Semantic Object/Action	<`empty`>
Scaling Factor	Auto

Targets, Thresholds, and Trend

This table shows some example values.

Parameter	Value
Goal Type	Maximizing
Value Type	Fixed Value
Critical	200
Warning	400
Target	<`empty`>
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

Input Parameter	Operator	Example Value	Explanation
V_SAPClient	Equal to	002	Enter the client that you use in your SAP ERP system. An entry in this field is required.
P_TargetCurrency	Equal to	USD	Choose a currency in which the currency amounts should be displayed. Ensure that exchange rates for this currency exist in your SAP ERP system. An entry in this field is required.
P_ExchangeRateType	Equal to	M	Choose an exchange rate type that is used to convert the currency into the display currency. The current date is used as the date for the currency conversion. An entry in this field is required.
P_CashManagementGrouping	Equal to	CF2	Choose the cash management grouping. An entry in this field is required.
P_ToOffsetDays	Equal to	30	Enter the to offset days. An entry in this field is required.
P_FromOffsetDays	Equal to	0	Enter the from offset days. An entry in this field is required.

Drill-Down: By Date

View ID: sap.hba.ecc.cashmgr.analyzeliquidityforecast.LiquidityForecast30days.one

View Title: Forecast by Date

Measures and Dimensions:

Parameter	Value
Dimension	Date
Measure	Net Cash Flow
KPI Measure	Balance

Visualization Type:

Columns and Lines
Manual Colors

Limit Data Records: 200

Drill-Down: By Liquidity Item

View ID: sap.hba.ecc.cashmgr.analyzeliquidityforecast.LiquidityForecast30days.one

View Title: Forecast by Date

Measures and Dimensions:

Parameter	Value
Dimension	Liquidity Structure
KPI Measure	Balance

Visualization Type:

Column
Single Axis
Absolute Values
Default Colors

Limit Data Records: 200

Tile

Title: Liquidity Forecast

Subtitle: Today

Parameter	Value
Tile Format	Numeric Tile
Navigation	Generic Drill-Down

More Information

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

For SAP NetWeaver 7.31:
http://help.sap.com/nw-uiaddon Application Help SAPUI5 Application Frameworks
For SAP NetWeaver 7.4:
http://help.sap.com/nw74 Application Help UI Technologies in SAP NetWeaver UI Development Toolkit for HTML5 (SAPUI5) SAPUI5 Application Frameworks