AnsweredAssumed Answered

Is there a way to improve performance when reporting off time slices?

Question asked by vtleogal2 on Feb 1, 2013
Latest reply on Feb 6, 2013 by Rajini
BOBJ XI 3.1
Clarity 12.1

I am in Webi using the Resource Universe and I am trying to pull
resource name, id, department ID, department OBS, resource class, resource type, investment id, investment name, investment role, resource availabililty, resource allocation (soft), resource hard allocation and actuals i do have the monthly start and monthly end date in the output and the filter.
I filtered on one specific resource with not much data.

This, then , is reading from the time slices. the report runs but it takes over 20 minutes just for one resource. If I don't use the time slice data, the report runs quickly.
The report eventually appears and it is correct - except past availablity does not show..

Any idea why it is so slow when adding the time slice data ? Is there a way to improve it? Essentially, this is like the resource planning (weekly detail) portlet, but adding in some of the resource attributes.

Thanks
Lynn

Outcomes