1. Using Oracle Fusion Analytics Warehouse
  2. Work with Data
  3. Manage Data
  4. Use a Subject Area as a Data Set
  5. Create a Dataset from an Oracle Application's Analysis

Create a Dataset from an Oracle Application's Analysis

You can create datasets with multiple tables from analyses stored in Oracle applications such as Oracle Fusion Applications with Oracle Transactional Business Intelligence.

Oracle Analytics doesn't automatically join tables created from analyses. You need to manually join these tables.
Don't create or use an Oracle Applications connection to connect to your local Oracle Analytics instance. Using a connection to your instance to create datasets from local subject areas or analyses results in data caching issues and errors in visualizations. Instead, use the Local Subject Area connection type to create a dataset from a analyses stored in your Oracle Analytics instance.
  1. On the Home page, click Create and then click Dataset.
  2. In the Dataset editor, go to the Connections pane and browse or search for an analysis.
  3. Drag and drop one or more analysis to the Join Diagram.
  4. In the Join Diagram, locate the table that you want to join, hover over it to select it, and then click and drag and drop it on to the table that you want to join it to. Open the Join editor to inspect or update the join type and conditions.
  5. Click Save.
  6. Enter a name and click OK.