Set up visual analytics integration

To integrate visual analytics through Tableau, follow these steps:

Set up your AWS environment

The integration uses Zilliant Report API External link indicator to securely retrieve Tableau report URLs and embed them in CPQ. To enable CPQ to authenticate against Report API, add your credentials in the AWS environment where your CPQ application is running.

Sign in to the AWS access portal with your administrator credentials.
On the top navigation bar, ensure that the correct region is selected.
Select your system.
Select Elastic Beanstalk, then select your environment.
Select Configuration, then in the Environment properties section, enter the following values:
- ZORG_API_URL—Report API URL with your API hostname.
- ZORG_CLIENT_ID—OAuth client ID for authentication.
- ZORG_CLIENT_SECRET—OAuth client secret.
- ZORG_USERNAME—Username.
- ZORG_PASSWORD—Password.

Enable visual analytics in CPQ

Define which Tableau reports and where in the UI you want to display. You can embed multiple analytics reports at the same launch point. For example, at the agreement header level, you can add several reports and display them in a tabbed layout, so users can easily switch between different insights.

From the CPQ left navigation area, select Administration.
From the top navigation bar, select Destination Configuration.
Select to add a destination, defining where to enable visual analytics.
In the Create New Destination dialog, enter values to define a destination:
- Destination Name—System name for the visual analytics report.
- URL—Report API URL without path and query parameters. For details on the URL syntax, read How View URLs Are Structured in Tableau’s documentation.
Select Create.
Select the new destination from the list.
In the Additional Properties section, select to define path and query parameters for the URL. In the new row, define each parameter using the left field for the key and the right field for the value.
- LaunchPoint—Define where the report appears in CPQ. Use one of the following values:
  - QT_HEADER_CVA_CONFIG—Quote header level.
  - QT_LINE_CVA_CONFIG—Quote line item level.
  - AG_NEG_HEADER_CVA_CONFIG—Header level of agreements under negotiation.
  - AG_NEG_LINE_CVA_CONFIG—Line item level of agreements under negotiation.
  - PUB_AG_HEADER_CVA_CONFIG—Header level of published agreements.
  - PUB_AG_LINE_CVA_CONFIG—Line item level of published agreements.
- Title—Name of the report tab as it appears in the UI.
- Sequence—Order number of the report’s tab in the UI.
- WorkbookName—Name of the Tableau workbook.
- WorksheetName—Name of the Tableau worksheet.
- (Optional.) Add standard Tableau query parameters to control how the embedded report behaves. For example, you can pass the :showDataDetails : yes key-value pair to display additional information in the analytics view. For details on the query parameter syntax, read How View URLs Are Structured and Embed Code Parameters for Views in Tableau’s documentation.
- (Optional.) Add query parameters to dynamically filter Tableau report data based on the context of the currently opened quote or agreement in CPQ. These parameters fetch live values, such as customer account ID, sales region, or selected product, and pass them to Tableau at runtime. Tableau then returns data filtered according to those parameters.
  Each parameter value must align with the attribute names defined in the CPQ schema model. To fetch live data correctly, use the corresponding CPQ application metadata path.
  Tip
  To pass data from the quote header, start the parameter value with Quote.. To pass data from line items, start with SalesItem.. For example, to pass the account ID as a query parameter, add the account_id : Quote.quoteContainedBy.objectERPId key-value pair.
On the bottom button bar, select Save.
Repeat Steps 1–8 for each visual analytics report and CPQ UI destination where you want to enable it.

Open visual analytics in CPQ

After you enable the integration, users can open visual analytics in agreements or quotes. For details, read: