Hi all,
I have a report which runs across an Oracle Financials universe that I recently created.
The universe is a Linked universe with the master and 6 slave universes. The slaves are topic specific, GL, AP, FA etc and are linked together with joins via the master.
The problem is, and I don’t believe that it is the design, is that I have a requirement in a report to drill down to Cost Center, Function and Natural, no big deal, done in many other universes in the past without a problem.
Except in this universe. I have a derived table that is created from a schema called APPS (those familiar with Oracle Financials should know this one.) . The table is aliased in three times, once for each field, no bid deal. I can run a query on the table and put a field on say Natural = 1100 and the query returns in an instant.
However I am using XI R2 and when I add a prompt, it obviously needs to be populated, and I need to be able to select one, many or all of the three fields mentioned.
Herein lies the problem. I have tried two different ways of create a prompt that uses the ‘*’ as the wild card, both of which work perfectly in every other universe I have, but in this universe, because the filter has the ‘OR’ operator, for some reason the run time is blown out from milliseconds to around 9.5 minutes.
I am at a loss, I have never experienced this before and hope that someone may be able to answer my question as to what may be causing this.
Thanks
plessiusa (BOB member since 2004-03-22)