1. Visualizing Data and Building Reports in Oracle Analytics Cloud
  2. Prepare Data
  3. Connect to Your Data Using Datasets
  4. Create a Dataset from a Local Analysis

Create a Dataset from a Local Analysis

You can create datasets from analyses stored in your Oracle Analytics instance.

Use the Local Subject Area connection option to create datasets from local analyses. Don't create or use an "Oracle Applications" connection to connect to your local Oracle Analytics instance. Using a connection to your local instance results in data caching issues and errors in visualizations.
  1. On the Oracle Analytics Home page, click Page Menu, then click Open Classic Home.
  2. In Classic Home, click Catalog and locate and open the analysis to use to create the dataset. In the Analysis editor, click the Advanced tab.
  3. In the SQL Issued field, select and copy the SQL code.
  4. In the Oracle Analytics Home page, click Create and then click Dataset.
  5. In the Create Dataset dialog, select Local Subject Area.
  6. In the Connections pane, locate and expand the subject area and locate the Manual Query option.
  7. Drag and drop Manual Query to the Join Diagram to create a table shell.
  8. Double-click the Manual Query table.
  9. In the Add Dataset page, rename the table and confirm that Enter Logical SQL is selected.
  10. In the Statement field, paste the SQL statement.
  11. Click OK.
  12. Optional: To modify the SQL statement, go to the Table Page Tabs and confirm that the tab for the table you created is selected. Click Edit Definition to access the Add Dataset page and modify the SQL statement.