You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

OTBI Performance - Project Cross Subject Area - Date Filters Affecting Performance very bad

Summary: Using Projects - Cross Subject Area Analysis - Real Time there are severe performance issues filtering by accounting date less than or equal to.
There is same issue if I select all periods for accounting period name in that range. 
Anytime I add any element as filter under "fiscal calendar" performance becomes very poor.

How can we achieve better performance?  I am adding in project #, cost and revenue amount which performs in under 5 seconds.  
If I add accounting date filter, performance suffers severly.


Content (please ensure you mask any confidential information):

I have tried several ways. Anytime I add a filter in criteria tab for Accounting Period or Accounting Date performance is horrible.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!