You acquire data by copying it from a data source to a local dataset.
Your input table forExpert Analytics must contain unique column names. The application does not consider columns with same names, but different letter cases, as unique.
|
Data source |
Description |
|---|---|
|
Microsoft Excel |
Loads an Excel worksheet as a dataset |
|
Text file |
Loads a text file (.csv or .txt) as a dataset |
|
Clipboard |
Creates a dataset from data that was copied to the clipboard |
|
SAP HANA |
Downloads data from SAP HANA (offline) |
|
Connects to SAP HANA (online) |
|
|
SAP BusinessObjects universe |
Downloads data from SAP BusinessObjects universe files (.unv and .unx) |
|
Query with SQL |
Runs freehand SQL on a database, to download a dataset |
After acquiring a dataset, you can add or remove columns, dimensions, measures, and variables in it.