Objectives
After completing this lesson, you will be able to:
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.
For the most part, datasets acquire data via import connections. The only exception is that a dataset can be built based on a live connection to a HANA data repository.
Access the Datasets menu option from the SAP Analytics Cloud navigation bar. From there, you can create public datasets based on a file or an import data source.
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.
NoteA shareable live dataset can be created for SAP HANA. Live datasets can also be created from a story based on SAP Datasphere.
Datasets are intended to supplement models and be used only for ad-hoc, ungoverned data analysis.
| 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 Anlaytics Cloud | No | No | Yes |
You have a file with HR data and you need to create a public dataset so that it can be used in multiple stories.
In this practice exercise, you will:
Log in to track your progress & complete quizzes
