Add a File to a Dataset Created From a Connection
A dataset can contain tables created from files and connections.
Most connections are available for you to add to a dataset. Exceptions include Oracle EPM Cloud, Oracle Essbase, or Google Analytics.
Before you add a connection, you can check to see if the data source connections you need already exist. See View Available Connections.
If you drag a subject area or analysis to the Join Diagram, then no columns are displayed. You must use the Transform Editor to specify which columns to include in the subject area's dataset table.
Before you upload a file, confirm that the file meets these requirements:
- The file is either an Excel spreadsheet in .XLSX or .XLS format, a CSV file, or a TXT file.
- The spreadsheet contains no pivoted data.
- The spreadsheet is structured properly for import and use as a dataset. See About Files for Datasets.