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.
Tagged:
0