Getting Help from Oracle

If the preceding optimization steps do not improve the performance of ASO cubes, seek help from Oracle.

  1. Create a Provide Feedback submission that captures your actions. Optionally, allow Oracle to access the maintenance snapshot of the environment by consenting to application snapshot submission. See Creating a Provide Feedback Submission.
  2. Create a technical service request that identifies the Provide Feedback reference number. See Submitting a Technical Service Request. The service request must contain the following:
    • The name of the ASO cube that you are trying to optimize.
    • The Form or the Excel spreadsheet you are using to test cube performance.
    • If using a Form for testing, a chronological listing of the selections that must be made in the form to reproduce your issue.

      If a combination of steps demonstrates the issue while another does not, provide both set of selections.

    • If the issue is related to zooming in (not related to data retrieval), attach the spreadsheet before zoom and provide specific instructions to reproduce the issue; for example, open the spreadsheet, select cell B2, and then zoom in to next level. Also explain the result of the operation.
    • Screenshots of Oracle Smart View for Office Options (ensure that all options on each tab are captured).
    • Did this issue start after the latest monthly update?
    • Is this is a critical outage?