Create Datasets from Files
You can create datasets from a range of files, including comma-separated value (*.CSV), text (*.TXT), and spreadsheets.
About Files for Datasets
You can create datasets from Microsoft Excel spreadsheets (XLSX and XLS), Google Sheets, CSV files, and TXT files. The maximum file size you can upload is 250 MB and the data column limit for a single file is 250 columns.
You can upload and use files from your computer, or from Dropbox or Google Drive data source connections.
When you upload a file, you can use it only in the dataset that you uploaded it to. Because Oracle Analytics doesn't store an uploaded file, you must upload the file again to include it in another dataset.
Formatting Rules for Excel Spreadsheet and Google Sheets Files
- Tables start in Row 1 and Column 1.
- Tables have a regular layout with no gaps, repeated column names, or inline headings. An example of an inline heading is one that's repeated on every page of a printed report.
- Row 1 contains the unique names of the columns in the table.
- Row 2 and greater contain the data for the table.
- Data in a column is of the same type. For example, don't use a phone number column to hold email addresses.
- Data is at the same granularity.
Character Set Encoding Rules for CSV and TXT Files
- Encode source files using UTF-8.
- Before you edit your files, configure your text editor to use the appropriate font and script (or subset).
Create a Dataset from a File Uploaded from Your Computer
You can upload spreadsheets from Microsoft Excel or Google Sheets, CSV files, and TXT files from your computer to create a dataset.
- The file is either a Microsoft Excel (.XLSX or .XLS format) or Google Sheets spreadsheet, a CSV file, or a TXT file.
- Spreadsheets shouldn't contains pivoted data.
- Spreadsheets are structured properly for import and use as a dataset. See About Files for Datasets.
Create a Dataset from a File Uploaded from Dropbox or Google Drive
You can upload spreadsheets from Microsoft Excel or Google Sheets, CSV files, and TXT files from Dropbox or Google Drive and use them to create a dataset.
Note:
Files uploaded from Google Analytics aren't available to create or include in a dataset with multiple tables.- The file is either a Microsoft Excel (.XLSX or .XLS format) or Google Sheets spreadsheet, a CSV file, or a TXT file.
- Spreadsheets shouldn't contains pivoted data.
- Spreadsheets are structured properly for import and use as a dataset. See About Files for Datasets.
Add Multiple Files to a Dataset
A dataset can include more than one file uploaded from your computer or from Dropbox or Google Drive.
Note:
Files uploaded from Google Analytics aren't available to create or include in a dataset with multiple tables.- The file is either a Microsoft Excel (.XLSX or .XLS format) or Google Sheets spreadsheet, 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.
Index a Dataset on Demand
You don't have to wait for a dataset to be indexed after refresh, or wait for a dataset's indexing schedule to run. You can index a dataset anytime you need to make its data available in the Home Page's search results.
- On the Home page, click Navigator, and then click Data.
- Click the Datasets tab.
- Locate the dataset that you want to index on demand, click Actions, and then click Inspect.
- Click the Search tab.
- Click Run Now to index the dataset.
Certify a Dataset
When you certify a dataset, you're confirming that the dataset contains accurate, reliable data. When users search for data from the Home page, certified data is ranked high in the search results.
Note:
A file-based dataset must be indexed and certified before the users you shared the dataset with can use it to build visualizations from the Home Page. See Index a Dataset and Use the Search Bar to Visualize Data from the Home Page.You can certify datasets if you're a member of an Administrator role and have Full Control or Read-Write access to the dataset.
For best search results only certify the datasets with data that users need to find. Certifying all datasets yields too many search results. Oracle recommends that you first certify the minimum number of datasets and then certify additional datasets only as needed.
- On the Home page, click Navigator and then click Data.
- Click the Datasets tab.
- Locate the dataset that you want to certify, click Actions, and then click Inspect.
- Click the General tab.
- Go to the Certified By field and click the Certify button.
- Click Save.