OBIEE Hints from Answers - Page 2 — Oracle Analytics

Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

OBIEE Hints from Answers

Received Response
747
Views
13
Comments
2»

Answers

  • Joel
    Joel Rank 8 - Analytics Strategist

    I totally agree with Robert. The OP needs to review the underlying data model and rather than doing these conversions at  runtime, these should be derived, calculated as part of your data warehouse ETL process. This will definitely bring on some performance improvements.

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

    There is an English joke to the effect of; - "Man in car - What is the best way to Leicester from here?  Local - I wouldn't start here if I wanted to go to Leicester."

    That is my best advice for this situation, don't start here ;-)

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics Strategist

    I recognize the tables ... it's OBI Apps ...  adding hints makes it worse ... are you following the proper customization techniques for Apps?  You've purchased a product that does perform - don't go making changes so that it doesn't.

    I have implemented Apps on very large instances of the Apps warehouse ... before you fiddle with OBIEE and force hinting on the optimizer ... what have you done to tune the database?  Indexing and partitioning need to be changed, especially if you've added custom columns (X_COLUMNAME is the convention and I see you've done that) that you are going to be using heavily from the OBIEE side.