Getting Help from Oracle
If the preceding optimization steps do not improve the performance of ASO cubes, seek help from Oracle.
- 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.
- 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?