Financial Analytics Data Reference

The Financial Analytics app uses a recipe and a dataflow to pull in data from your Salesforce org into your Financial Analytics app. For more information about recipes and dataflows, see the Salesforce Help.

The Financial Analytics recipe generates the following datasets:

• Currencies
• Financial Accounts
• Financial Periods

Warning:

We recommend that you never modify the Financial Analytics recipe. This might cause dashboards, lenses, and other recipes to stop working. In addition, any changes that you make to a recipe are lost when you upgrade or reconfigure the app.

Depending on how your app is configured, the Financial Analytics dataflow generates the following datasets:

• Billing Contracts
• Billing Documents
• Financial Balances
• Financial Matching
• Financial Transactions
• Recognition Transactions
• Revenue Waterfall
• Supply Chain Management Core

Warning:

Modifying the Financial Analytics dataflow might result in the loss of functionality. Contact your system administrator before using the data manager tool in Analytics.

Currencies

If your Salesforce org is configured to support multiple currencies, the Financial Analytics recipe also generates the Currencies dataset. This dataset pulls in the currencies configured in your org.

Financial Accounts

The Financial Accounts flow includes fields held on the Account object in Salesforce.

Financial Balances

The Financial Balances flow includes fields from the Reporting Balances, Transaction, Transaction Line, objects in Accounting and Tag object in Planning.

Financial Matching

The Financial Matching flow includes fields from the Cash Matching, Transaction and Transaction Line objects in Accounting.

Financial Periods

The Financial Periods flow includes fields from the Period object in Accounting.

Financial Transactions

The Financial Transactions flow includes fields from the Transaction and Transaction Line objects in Accounting.

Recognition Transactions

The Recognition Transactions flow includes calculated and non-calculated fields from objects in Revenue Management.

Revenue Waterfall

The Revenue Waterfall flow includes fields associated with the Revenue Schedule and the Billing Schedule objects in Revenue Management.

Billing Contracts

The Billing Contracts flow includes calculated and non-calculated fields from objects in Accounting and Billing Central.

Billing Documents

The Billing Documents flow includes calculated and non-calculated fields from objects in Accounting and Billing Central.

Supply Chain Management Core Fields

The Supply Chain Management Core dataset includes calculated and non-calculated fields from the following objects in SCM.

Lenses

The lenses included in Business Analytics.

Calculated Fields

The Billing Contracts dataset includes calculated fields derived from the Company, Contract, Contract Line Item, Opportunity and Account objects in Accounting and Billing Central as well as other associated objects.

KPIs Quick Reference

This is a summary of the KPI groupings which are available and their associated KPIs.

Transformed Fields

Fields containing the suffix (s) have been transformed in some way. This is a summary of the transformed fields in Financial Management Analytics.