Setting up PS Cloud Core Analytics Apps

Depending on your business requirements, you can choose to create a PS Cloud Core Analytics app, or a PS Cloud Core Analytics app and a PS Cloud Advanced Analytics app. The PS Cloud Core Analytics app is required to provide the data displayed in the dashboards created by the PS Cloud Advanced Analytics app.

This chart represents a high-level overview of the process of creating your PS Cloud Analytics apps.

Process flow for the creation of PS Cloud Core and Advanced Analytics apps.

What is PS Cloud Core Analytics?

Refer to the following tables and their linked pages for information related to:

  • Licensing
  • Supported environment
  • Prerequisites and configuration
  • How to generate apps

You must be signed in as an administrator, or equivalent, to complete these tasks.

We recommend you that you complete the tasks in the order shown. All tasks are mandatory unless marked as [Optional].

Setting up Your PS Cloud Core Analytics App

The table below describes the steps for setting up your PS Cloud Core Analytics App.

PS Cloud Core Analytics Setup Steps

Step

Task

Related Help Topic
1. Ensure the Analytics View Only Embedded App permission set licenses have been enabled in your org. To do this, navigate to Setup | Company Information | Permission Set Licenses and look for Analytics View Only Embedded App.

Advanced Analytics licenses (CRM Analytics Platform) can be used to set up the app instead of View Only Embedded licenses.

If CRM Analytics Platform or View Only Embedded Licenses are not available in your org, contact your Certinia Account Manager or Customer Success Manager.
2. Ensure that Analytics is enabled in your org. If this is not enabled contact your Onboarding Team to raise a case with Salesforce. To check whether Analytics is enabled in your org, navigate to Setup | Analytics | Getting Started. If you see a blue Launch CRM Analytics button in the upper right corner, Analytics is already enabled.

3.

Ensure that null measure handling is enabled in your org. If it is not listed as an option in Analytics Settings, contact your Onboarding Team to raise a case with Salesforce to enable the setting.

 To check whether null measure handling is enabled in your org, navigate to Setup | Analytics | Settings. If you see an option for Allow null measure handling in datasets and it is ticked, then null measure handling is enabled in your org. For more information, see Null Measure Handling in PS Cloud Core Analytics

5.

Ensure that the following packages are installed in your org:

  • Foundations
  • PSA Core
  • PSA
  • [Optional] Services CPQ
 Supported Environment

6.

If your org is configured to support multiple currencies, ensure that the Integration User's currency is set to your corporate currency. To do this, navigate to Setup | Company Information and look at the corporate currency.

Ensure the currency selected is same as in Users | User, Integration.

 See the Salesforce Help.

7.

Create a read access permission set for the Skill / Certification Rating, Contact, and Resource Change objects and assign this to the Integration User.

 PS Cloud Core Analytics Permission Sets

8.

Assign required permission sets and licenses to the Integration User.

9.

Assign required permission sets and licenses to the PSA Admin User. This is the user who creates and administers the analytics app.

10.

Assign required permission sets and licenses to the View User.

11.

Prepare Backlog calculations.

 Preparing the Data Environment for PS Cloud Analytics

12.

Populate Utilization Results or Utilization Summary or Details objects.

 Preparing the Data Environment for PS Cloud Analytics

13.

[Optional] Create Data for the Revenue Forecast dataset.

 Preparing the Data Environment for PS Cloud Analytics

14.

[Optional] Create Data for the Project Margin dataset.

 Preparing the Data for Project Margin

15.

[Optional] Create data for Revenue Forecasts.

 Preparing the Data Environment for PS Cloud Analytics

16.

Ensure you have data in the required objects in your PSA data environment.

 Objects Required by the PS Cloud Analytics Dataflow

17.

[Optional] Ensure you have data in the required objects in your Services CPQ  data environment.

 Objects Required by the PS Cloud Analytics Dataflow

18.

Configure and create your PS Cloud Core Analytics app.

 Creating an App from the PS Cloud Core Analytics Template
19. Schedule your dataflows. Running Dataflows