Create Dataset from Planview PPM Pro

This article details how to create a Dataset from Planview PPM Pro Plugin.

PREREQUISITES:

Established connectivity to Planview PPM Pro

1. Create a New Dataset

Access +New > Dataset > Create New

  1. Measured: Select the measurement interval that applies to the level of aggregation that you want in your result set
  2. Name: Give the Dataset a descriptive name
  3. Category:  Specify the Category to place the Dataset 

2. Complete the Data Tab

Open the Data tab

  1. Data Source: Select the Planview PPM Pro Data Source
  2. Data collection trigger: Specify the Data collection trigger that will be used to collect data for Dataset
  3. Object: Select the Planview PPM Pro object that should serve as a basis for Dataset
  4. Plugin command: Build a query listing all the data you would like to fetch from Planview PPM Pro
  5. [Validate]
  6. [Save]
  7. [Enable & View]

NOTE: Metric Insights can't retrieve Reports from Planview PPM Pro. However, all the data that is stored in Reports can be pulled from the Requests object. Filters and plugin commands can be used to mimic the necessary Reports.

2.1. Set Filters

NOTE: Only Filters, retrieved from Planview PPM Pro can be applied to Planview PPM Pro Objects. Filters created via [+Filter] option won't work.

  1. [Manage Filters]
  2. Retrieve Filter names from Planview PPM Pro: Enable this toggle switch and wait for the Filters list refreshing
  3. [Done]

2.2. Apply Filters to Results

  1. Click the Pencil icon in the filter row
  2. Use: Choose how you want to use the filter
    • "All Values": All Values of the Filter will be applied to the results
    • "Only Selected Values": The Values that will be chosen from the list will be applied to the results
    • "Ignore Filter": The Filter won't be applied to the results
  3. [Save]