Before you can use Financial Management Analytics, you must ensure that:
- You have the necessary licenses for Analytics and it is enabled in your user orgs. Contact FinancialForce Onboarding for assistance.
- You have the necessary licenses to use Business Analytics. See Licensing for more information.
- Your administrator has enabled Analytics from Setup in Feature Settings | Analytics | Analytics | Getting Started.
- Your administrator has selected the Enable Analytics Templates setting in the settings for Analytics.
- You have data in the following Accounting objects: Transaction, Transaction Line Item, Reporting Balances, Cash Matching History.
- [Optional, to create the Billing Contracts dataset] You must have data in the following Billing Central objects: Account, Contract, Contract Line Item, Opportunity, Opportunity Product, and Product.
- [Optional, to create the Recognition Transactions dataset] You must have data in the following Revenue Management objects: Account, Revenue Recognition Transaction, and Revenue Recognition Transaction Line.
- [Optional, to create the Revenue Waterfall dataset] You must have data in the following Revenue Management objects: Account, Contract, Contract Line Item, Revenue Schedule, and Revenue Schedule Line.
Your administrator is responsible for managing your Analytics settings.
Financial Management Analytics Permission Sets
The following permission sets are required for Financial Management Analytics users:
|
Users |
Permission Sets |
Description |
|---|---|---|
| Integration User | Analytics and Financial Statements Read Access |
Data access to objects and fields derived from Accounting and used in the Financial Management Analytics dataflow. For more information on the Analytics and Financial Statements Read Access permission set, see the Accounting Help. |
| Accounting - Multi Book - Read Access |
Data access to objects and fields used by the Multi-Book Accounting feature in Accounting. For more information on the Accounting - Multi Book - Read Access permission set, see the Accounting Help. |
|
| [Optional] Billing Central Analytics Read Access | Data access to objects and fields derived from Billing Central and used in the Financial Management Analytics dataflow. | |
| [Optional, required for use with Billing Central] FDN Core Analytics | Data access to Foundations companies. This is required to display data from Foundations companies integrated with Accounting | |
| [Optional] RevMan Analytics | Data access to objects and fields derived from Revenue Management and used in the Financial Management Analytics dataflow. | |
| [Optional] Fixed Asset Management - Business Analytics Read Access |
Data access to objects and fields derived from Fixed Asset Management and used in the Financial Management Analytics dataflow. For more information on this permission set, see the Fixed Asset Management Help. |
|
| [Optional] SCM - Use Business Analytics for SCM | Required to provide read-only access to the SCM objects and fields included in the Supply Chain Management Core dataset. | |
| Admin User | Financial Analytics App Template - App Creation | Enables the user to create and customize Financial Analytics apps using the app template. |
| Financial Statements Reporting | Enables the user to create and customize Financial Statements built using Analytics. | |
| Financial Analytics App Template - Cash Flow Analytics |
Create and customize Cash Flow Analytics built using Analytics and Lightning Web Components. This permission is also required by view users to use the Exclude Journals from Cash Flow Analytics bulk action. |
|
|
Analytics Platform |
Administrator access to all Analytics features. You can assign appropriate access to Analytics Features for this user by editing their available permissions under System Permissions. | |
| Tableau CRM Platform Admin | Enables all permissions required to administer the Analytics platform, including permissions to enable creating Analytics templated apps and Apps. | |
| View User | Tableau CRM Platform User | Enables all permissions required to use the Analytics platform and Analytics templated apps and Apps |
|
Analytics Platform |
Enables access to all Analytics Features. You can assign appropriate access to Analytics Features for this user by editing their available permissions under System Permissions. |
Integration User Requirements
Salesforce automatically generates the integration user when Analytics is enabled in your org. This user needs the relevant access permissions to link your Salesforce data with Analytics.
This user requires a Accounting license and read access to Accounting. Additionally, your administrator must link the Accounting permission set Analytics and Financial Statements Read Access to the integration user. For more information, see "Permission Sets Added Incrementally" in the Accounting Help.
The integration user requires licenses to access object data from different products to create datasets and dashboards. For more information on the licenses required by the integration user, see Licensing.
In addition:
- Your administrator must link the Accounting permission set Accounting - Multi Book - Read Access to the integration user if you have the Multi-Book Accounting feature enabled in your org.
- Your administrator must link the Foundations permission set FDN Core - Analytics - Read to the integration user to create the Billing Document and Billing Contracts datasets.
- Your administrator must link the permission set Billing Central Analytics Read Access to the integration user, to extract data from Billing Central objects and display it in Business Analytics.
- Your administrator must link the permission set RevMan Analytics to the integration user, to extract data from your Revenue Management objects and display it in Business Analytics.
- Your administrator must ensure the integration user currency is equal to the org's Dual Currency before creating the Financial Management Analytics app.
For Winter 2021, if you are also generating the Revenue Waterfall dataset and the Deferred Revenue Waterfall dashboard you must manually assign the integration user Read and View All permissions to the following Revenue Management objects and fields:
|
Objects |
Fields |
Permissions |
|---|---|---|
| Revenue Schedules Lines | Period End |
|
| Period Start | ||
| Revenue | ||
| Schedule Line Number | ||
| Revenue Schedules | Account | |
| Document Currency | ||
| End Date | ||
|
ffrrBCContractLineItem |
||
| Recognition Method | ||
| Start Date | ||
| Total Revenue | ||
| Total Scheduled Revenue |
Additionally, if you are using an Accounting version prior to Winter 2021 you need to manually assign the Integration User permissions to the following fields:
- c2g__CODAAccountsPayableControl__c
- c2g__CODAAccountsReceivableControl__c
- c2g__CODABankAccountNumber__c
- c2g__CODABankSWIFTNumber__c
- c2g__CODAECCountryCode__c
- c2g__CODAVATRegistrationNumber__c
App Template Design User Requirements
All users who intend to create apps using the App Template Design wizard require:
- A Accounting license.
- A Business Analytics license.
- [Optional] A Billing Central license to add the Billing Contracts dataset.
- One of the following permission sets assigned: the Financial Management Analytics App Template permission set (to use Financial Analytics and Financial Statements) or the Financial Statements App Template permission set (to use just Financial Statements).
- Read access to the General Ledger Account, Company, and all dimension objects in Accounting.
Standard User Requirements
Users who only require access to the information related to their assigned company need the Analytics Platform User permission set assigned. See "User Companies" in the Accounting Help for more information on assigning user access to FinancialForce companies. With this permission, users can view the information in apps shared with them by the administrator.
Your company may prefer to use Financial Management Analytics in one of the following ways:
- Your administrator is responsible for creating applications using the App Template Design wizard and sharing them with the necessary users.
- Users create applications using the App Template Design wizard themselves. In this case, these users require the Financial Analytics App Template - App Creation permission set.