PS Cloud Analytics Setup Fields

Here is a description of the fields on the PS Cloud Analytics Setup object.

PS Cloud Analytics Setup Fields

Field Option

Description

Active

Indicates the PS Cloud Analytics Setup record used to create the PS Cloud Core Analytics app. You can have only one active PS Cloud Analytics Setup configuration record.

Utilization Calculation Type

If Utilization Setup is selected, creates the Utilization Results dataset. This is required to create the Utilization Analytics dashboard in the PS Cloud Core Analytics app, and the Utilization Capacity and Demand Planning and Skills Capacity and Demand Planning dashboards in the PS Cloud Advanced Analytics app. If Utilization Calculation is selected, creates data in the Utilization Summary/Detail and Utilization dataset. This is required to create the Utilization dashboard in the PS Cloud Advanced Analytics app. If Both Calculation Types (for migration purposes) is selected it creates the Utilization Results, Utilization Summary/Detail and Utilization datasets.

Additional Project Fields

Stores additional fields from the Project object added to the datasets created in the PS Cloud Core Analytics app. This includes user-generated custom fields and packaged custom fields.

You can select one or more additional fields from the Project object. These are added to the following datasets:

  • Backlog
  • Billings
  • Project Reporting
  • Revenue Forecast
  • Total Project Margin (Workspace)
Additional Contact Fields

Stores additional fields from the Contact object added to the datasets created in the PS Cloud Core Analytics app. This includes user-generated custom fields and packaged custom fields.

Additional Project Field API Names Stores the API names of additional fields from the Project object added to the datasets created in the PS Cloud Core Analytics app. This includes user-generated custom fields and packaged custom fields.
Additional Contact Field API Names Stores the API names of additional fields from the Contact object added to the datasets created in the PS Cloud Core Analytics app. This includes user-generated custom fields and packaged custom fields.
Billing Forecast If selected, creates the Billing Forecast Summaries and Billing Forecast Details datasets and the Billing Forecasts dashboard in PS Cloud Core Analytics.
Fiscal Year Start Month

Indicates the month set as the start of your fiscal year. The default option is January.

Backlog

If selected, creates the Backlog dataset in the PS Cloud Core Analytics app. This is used to create the Backlog and PSA Overview dashboards in the PS Cloud Advanced Analytics app.

Note:

This setting controls the data displayed in the Backlog chart in the PSA Overview Dashboard and PSA Performance Summary Dashboard.

Object Sharing

If selected, your org's PSA object sharing model is used to control the data displayed in PS Cloud Core Analytics.

Revenue Forecast Permission Controls

If selected, applies permission controls from PSA to the Revenue Forecast dataset and dashboard.

Project Margin

If selected, creates the Project Margin dataset and the Total Project Margin (Workspace) dashboard in PS Cloud Core Analytics.

PS Cloud Analytics Setup Name The name of the PS Cloud Analytics Setup record.
Revenue Forecast

If selected, creates the Revenue Forecast dataset in PS Cloud Core Analytics.

Note:

This setting controls the data displayed in the Revenue Forecast chart in the PSA Overview Dashboard and PSA Performance Summary Dashboard.

Services CPQ

If selected, creates the SCPQ Estimator and SCPQ Estimate Manager dashboards in PS Cloud Core Analytics.

Revenue Management Fields

If you use Revenue Management, when this is selected, the following fields are included in the Project Reporting dataset in PS Cloud Core Analytics:

  • Project Cost Amortized
  • Project Revenue Recognized
  • Project Total Cost Amortized
  • Project Total Revenue Recognized
Note 1:

The fields that contain the recognized to date and the amortized to date values for a project are determined using your Revenue Management settings for the Project object. If a source field is not specified in the settings records, the field is not included in the Project Reporting dataset. In addition, if you have multiple settings records for the Project object, you must ensure that all of the records have the same values for the relevant source fields.

Note 2:

This requires access to Revenue Management objects and fields in your org. It also requires access to the fields that contain the values on the Project object. Both you and the Integration User must have PSA and Revenue Management licenses, as well as access to the relevant objects and fields.

For more information about these fields and how they are populated, see Project Reporting Flow Intermediate Processing and Project Reporting Dataset Output Fields.

Utilization Results

If selected, creates the Utilization Results dataset in the PS Cloud Core Analytics app.