What is the correct Measurement Source to pull hourly allocations into an Ad Hoc Jaspersoft report?

book

Article ID: 32830

calendar_today

Updated On:

Products

CLARITY PPM FOR ITG CLARITY PPM FEDERAL Clarity PPM SaaS - Application Clarity PPM On Premise

Issue/Introduction

Question:

What is the correct measurement source to pull hourly allocations into an Ad Hoc report in PPM?

 

I am creating an Ad Hoc view that pulls in resources and investments with their hourly allocations similar to the weekly detail portlet, however I can not seem to pull in individual resource allocations.

 

Answer:

The measurements that allocation hours are found under are Weekly Periods, Calendar Periods, and / or Fiscal Periods.

 

Below are the steps on how to pull in these measurements.

1. In Advanced Reporting, select Create then Ad Hoc View
2. Click Domains
3. Drill down in CA PPM->Domains->Investment Management and click 'Choose Data' 

<Please see attached file for image>

domain1.JPG

4. Select your desired fields for the report, being sure to include the period types you want to use in allocations: Weekly Periods, Calendar Periods, and / or Fiscal Periods (For this example: Weekly Periods) 

<Please see attached file for image>

selectperiods.JPG
5. Click the desired report type. (For this example: Table)

6. Under the "Measures" section on the bottom left hand side of the page, drill down into the following: Investments->Weekly Periods->Team->Hours

<Please see attached file for image>

Measures.JPG
7. Drag and drop the desired allocation hour types (Such as Team Allocation Hours) over to the New Ad Hoc window

 

Environment

Release: ESPCLA99000-14.3-Clarity-Extended Support Plus
Component:

Attachments

1558699292823000032830_sktwi1f5rjvs16olq.jpeg get_app
1558699290810000032830_sktwi1f5rjvs16olp.jpeg get_app
1558699288861000032830_sktwi1f5rjvs16olo.jpeg get_app