Set Up Reporting
Configure data governance and data mapping so you can report on accrual data.
Required Editions
| Available in: Lightning Experience |
| Available in: Enterprise and Unlimited Editions where Trade Promotion Management, CRM Analytics, and Data Cloud are enabled. |
| User Permissions Needed | |
|---|---|
| To Access Data Cloud and CRM Analytics: | Data Cloud Architect CRM Analytics Platform Admin CRM Analytics Plus Admin |
| To configure apps and assign permission sets: | CGCloud Business Admin |
Important By default, users can access all records in Data 360. To control
which records your users can see, define a data governance policy. For more
information, see Add Row-Level Security with a Data Governance Policy
-
Create a data space for accruals.
- From Setup, in the Quick Find box, enter Data Spaces, and select Data Spaces.
- Click New.
- Enter a Name (for example, Accrual Data Space) and a Prefix.
- Click Save.
-
Add the accrual data lake objects to the new data space.
- From the App Launcher, find and select Data Spaces.
- Open the data space that you created.
- In the Data Lake Objects section, click Add Data Lake Object.
- Select accrualoutput_decorated and click Next.
- Click Add Filter.
-
Set the filter to: Usage Tag
Equals
Your Accrual Usage Tag.
Note Use the same accrual Usage Tag that you set on your sales organization record. - Click Save.
-
Deploy the data model and the CRM Analytics dashboards by preparing the files
and then running the deployment command.
-
In your local copy of the CGCloudAddons/TPM/Accruals/Accruals
Reports folder, perform these replacements in the file
and folder names.
- _DATASPACE_PREFIX_: Replace with the prefix for your Dataspace. If you're using the default DataSpace, use an empty string.
- _DATASPACE_NAME_: Replace with the API name of your Dataspace. If you're using the default Dataspace, use default.
- _ORG_NS_: Replace with your org's namespace. If your org doesn't have a namespace, use an empty string.
-
After you update the names, deploy the files. Open your terminal and
run the deployment command.
sf project deploy start -d <CGCloudAddons/TPM/Accruals/Accruals Reports -o <org_alias>
-
In your local copy of the CGCloudAddons/TPM/Accruals/Accruals
Reports folder, perform these replacements in the file
and folder names.
-
Verify the setup in Analytics Studio.
- From the App Launcher, find and select Analytics Studio.
- Open the Promotion Tactic Summary report.
- Verify that the accrual data is visible and filtered according to your data space settings.
-
After deployment, add the dashboards to a new or existing Lightning app to make
them available to your users.
- Create a Lightning app.
- From the app page editor, drag the CRM Analytics Dashboard component onto the page.
-
In the component's properties, for Dashboard,
select Accrued Month End Report
[DATASPACE_NAME].
Replace [_DATASPACE_NAME_] with your Dataspace name.
- Set the Height to 800.
- Save your changes and activate the page.
-
Configure the Promotion Tactic Accrual Summary component, which requires a
custom Lightning web component.
- Deploy the UI component from the CGCloudAddons/TPM/Accruals/UI folder.
-
Configure the component controller to map the correct report and
filters for your sales org. Open the controller file and find the
component.CONFIGURATION_BY_SALESORGcode block.Use these replacement tokens:- _DATASPACE_PREFIX_: Replace with the prefix for your Dataspace. For the default Dataspace, use an empty string.
- _DATASPACE_NAME_: Replace with the API name of your Dataspace. For the default Dataspace, use default.
- _ORG_NS_: Replace with your org's namespace. If your org doesn't have a namespace, use an empty string.
Add new entries for all your sales orgs. Make sure that the
DASHBOARD_DEVELOPER_NAMEmatches the dashboard you deployed. - Deploy the updated component.
-
Add the configured component to the Promotion page layout.
- Click Setup, and then select Edit Page.
- From the Components pane, drag the TPM Accrual Tactic Summary component onto the page, placing it under the Tactic Funds card.
- Save the page.
When a user selects a tactic for a promotion, the Tactic Accrual Summary is shown on the promotion's page.
Did this article solve your issue?
Let us know so we can improve!

