/
Browse
/
Courses
/
Designing Data Models and Transforming Data in SAP Analytics Cloud
/
Creating Import Models
Explaining the Basics of Data Structures in SAP Analytics Cloud
Explaining Where the Data Comes From
9 min
Identifying the Differences Between Model Types
14 min
Creating Datasets
11 min
Quiz
Designing and Creating Dimensions
Defining Dimensions
8 min
Identifying Dimension Types
10 min
Describing Properties
8 min
Designing and Creating Hierarchies
22 min
Importing and Preparing Master Data for a Dimension
20 min
Quiz
Creating Import Models
Creating an Import Model
28 min
Importing Data Into a Model.
21 min
Preparing and Transforming Transaction Data
34 min
Scheduling Data Imports
3 min
Introducing Formulas and Calculations
15 min
Creating Formulas and Calculations
16 min
Converting Currency
35 min
Designing and Creating Time Hierarchies
25 min
Quiz
Working With Live Models
Using Data Analyzer to Preview Your Live Data Structure
12 min
Creating Live Models
31 min
Working With SAP Datasphere
25 min
Quiz
Working With Geographic Data
Configuring Geographic Data in a Model
20 min
Quiz
Defining Data Security
Defining Data Access
23 min
Quiz
Explaining the Basics of Data Structures in SAP Analytics Cloud
Explaining Where the Data Comes From
9 min
Identifying the Differences Between Model Types
14 min
Creating Datasets
11 min
Quiz
Designing and Creating Dimensions
Defining Dimensions
8 min
Identifying Dimension Types
10 min
Describing Properties
8 min
Designing and Creating Hierarchies
22 min
Importing and Preparing Master Data for a Dimension
20 min
Quiz
Creating Import Models
Creating an Import Model
28 min
Importing Data Into a Model.
21 min
Preparing and Transforming Transaction Data
34 min
Scheduling Data Imports
3 min
Introducing Formulas and Calculations
15 min
Creating Formulas and Calculations
16 min
Converting Currency
35 min
Designing and Creating Time Hierarchies
25 min
Quiz
Working With Live Models
Using Data Analyzer to Preview Your Live Data Structure
12 min
Creating Live Models
31 min
Working With SAP Datasphere
25 min
Quiz
Working With Geographic Data
Configuring Geographic Data in a Model
20 min
Quiz
Defining Data Security
Defining Data Access
23 min
Quiz
Knowledge quiz
It's time to put what you've learned to the test, get 8 right to pass this unit.
1.
How can the currency table be updated?
There are three correct answers.
SAP BPC rate model
Flat File
FTP
SAP BW query
Internet download
2.
What happens when you turn off the Planning option in Model Settings?
Choose the correct answer.
Data can't be written to the model
Currency conversion is possible
The Version dimension goes away
The Date dimension is added
3.
What time pattern is supported for the Date dimension?
Choose the correct answer.
4-4-4
4-5-5
13x4
12x4
4.
Where does SAP Analytics Cloud store exchange rates?
Choose the correct answer.
In a dataset
In a currency table
In a model
In a dimension
5.
Which of the following statements about calculated measures are true?
There are two correct answers.
They are accessed from the model Calculations workspace.
They are custom calculations that create new data in the model.
They can only be used in one story at a time.
The calculation is performed dynamically during analysis or visualization.
6.
Model imports settings allow you stop an import job if one step fails.
Choose the correct answer.
True
False
7.
Dimension member formulas are only available for the account type dimension.
Choose the correct answer.
True
False
8.
Which of the following can you do in the Prepare Data step when importing and transforming transaction data into an import model?
There are three correct answers.
Make simple data changes with smart transformations and quick actions directly from the data table.
Use the overview panel to perform a quality check on the data.
Perform complex transactions with the calculation editor.
Change the job settings.
9.
When importing data into a model, which dimension has no import option?
There are two correct answers.
Version
Account
Date
Organization
10.
In the Review Import step, if there are no issues which area will be blank?
Choose the correct answer.
Dimension Restrictions
Map Properties
Prepare Data
Prepare Data