What is a dataset? A dataset is a simple collection of data, usually presented in a table. You can use a dataset as the basis for your story, and as a data source for Smart Predict. Datasets are a good choice when you want to create stories quickly and do not want to get into structure definition or when development does not demand IT governance.
Create Datasets
Access the Datasets menu option from the SAP Analytics Cloud side navigation. From there, you can create public datasets based on a file or an import data source.
Public and Embedded Datasets
Public datasets are data sources that can be used in multiple stories by any users who have access to them. They can be created directly from the vertical toolbar and can also be used for Smart Predict.
Embedded datasets are created in and exist in only a single story, and cannot be shared or used in other stories or with Smart Predict. However, if you need others to be able to use this dataset, you can convert it to a public dataset.
Datasets are intended to supplement models and be used only for ad-hoc, ungoverned data analysis.
Datasets versus Models
| Characteristics | Datasets | Live Models | Import Models |
|---|---|---|---|
| Purpose | Ad-hoc/Smart predict | Planning (BPC Embedded only) | Planning and Analysis |
| Scheduled imports available | No | No | Yes |
| Public or embedded | Both | Public | Public |
| Table | 1 data table | Dimensions and data tables | Dimensions and data tables |
| Calculated measures | No | No | Yes |
| Data Security in SAP Analytics Cloud | No | No | Yes |