Noetix for Ora 10.7

general discussion
1

Does anyone have any experience on creating universes from Noetix for Oracle Financials 10.7
thank you. daniel

_________________________________________________________ DO YOU YAHOO!?
Get your free @yahoo.com address at http://mail.yahoo.com

Listserv Archives (BOB member since 2002-06-25)

2

Daniel,

Don’t remember the exact version of Oracle that was used, but I have used BO with Noetix/Oracle Financials. I can’t say it was an extremely satisfying experience. The problems we ran into were mainly performance related.

  • Performance can be extremely slow. If you look at the SQL for the Noetix views you will understand why!
  • Joining views, even on the Noetix defined join columns made performance worse.

We decided to make a universe for each application (ie. AP, AR, PA, FA…) and within these universes didn’t join views unless absolutely necessary. (Users were instructed to only use objects from one class for reports. Cartesian Products were Not Allowed.) This seemed to work OK. If a join was necessary then it was fully tested for performance.

Noetix seemed to be fairly helpful (once you get hold of the right person) in willing to add columns to their views. Their position seemed to be that if we needed the field in a view then it is likely other installations will also. This lowered the need to join views.

Hope this helps and Good Luck!
Kerry

Listserv Archives (BOB member since 2002-06-25)