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 an Analysis in Oracle Fusion Cloud Applications Suite

Create a Dataset from an Analysis in Oracle Fusion Cloud Applications Suite

You can create a dataset based on analyses from applications in Oracle Fusion Cloud Applications Suite. For example, Oracle Fusion Cloud Financials with Oracle Transactional Business Intelligence.

Oracle Analytics doesn't automatically join tables created from analyses. You need to manually join these tables. See Understand Dataset Table Joins.
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. See Create a Dataset from a Local Analysis.
  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 Dataset.
  6. Optional: Change the default name "New Dataset" displayed top left.