Creating a Dataset from Open Connectors Cloud Storage Data Sources

You can create a dataset from an Open Connectors cloud storage data source.

Prerequisites

Note
If your SAP Analytics Cloud system is hosted on a data center located within China, this feature is not available.

Procedure

  1. Create a new dataset and choose a data source:
    1. Select Start of the navigation path (Main Menu) Next navigation step  Create Next navigation step  DatasetEnd of the navigation path.
    2. Select Data from a data source.
    3. Choose an Open Connectors cloud storage data source, such as Dropbox or Microsoft OneDrive.
    Note
    From the acquire data panel, you can select the filter icon, and then choose Open Connectors to show only the Open Connectors data sources in the list.
  2. Select an existing connection, or select Create New Connection to create a new connection.

    For more information, see Import Data Connection to SAP Cloud Platform Open Connectors Cloud Storage Data Sources.

  3. Choose a file from the list, or search for a file, and select Next.
    Note
    Only files that have been loaded will appear in the search results. To see more results, open more folders.
    Note
    If you're importing an Excel workbook containing multiple sheets, the first sheet is automatically imported.
  4. Specify whether the first row of data contains column headers.
  5. If you're importing a .csv file, select which delimiter is used in the file, or select Auto-detect.
  6. Select Import to begin the import procedure.

Next Steps

After importing the raw data, continue with data preparation before completing your dataset: About Adding Data to a Story.