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

Document ID : KB000032830
Last Modified Date : 14/02/2018
Show Technical Document Details

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' 

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) 

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

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