1. Visualizing Data and Building Reports in Oracle Analytics Cloud
  2. Report Data
  3. Create Analyses
  4. Create Your First Analysis

Create Your First Analysis

You can quickly create an analysis to query against your organization's data. The analysis results help you answer your business questions. For example, you can create an analysis using the SampleApp subject area Brand and Revenue columns.

  1. On the Classic Home page, in the Create pane, click Analysis.
  2. Use the Select Subject Area dialog to search for and select a subject area.
  3. Add the columns that you want to include in the analysis by dragging and dropping them from the Subject Areas pane to any position within the Selected Columns pane. You can select multiple non-contiguous columns by using the Ctrl key, selecting each column to include, and then dragging the columns to the Selected Columns pane.
  4. To change the column order, use the crosshairs on the column to drag and drop the column to a different position.
  5. To save a column to the catalog, in the Selected Columns pane, click Options beside the column name, and click Save Column As.
  6. In the Save As dialog, specify the folder, name, and description for the column and click OK.
  7. To remove a column, in the Selected Columns pane, click Options beside the column name, and click Delete.
    To remove all columns, click Remove all columns from criteria. Note that there is no undo action available for this option. Instead of removing columns, you can hide the columns whose appearance adds no value to the analysis.
  8. Click the Results tab to see the results of the analysis in a table or pivot table.
  9. Click Save Analysis to display the dialog to save the analysis.
  10. In the Save As dialog, select a folder, and specify a name, and optional description for the analysis.
    If you want others to be able to view the analysis, then save it in the shared folder area. If your analysis contains other objects, then you'll be prompted to assign access permissions to those objects.
    If you don’t want anyone else but yourself to be able to view the analysis, then save it in My Folders.
  11. Click Refresh at the bottom of the pane to double-check that the analysis is listed under the folder in which you saved it.