Creating Import Models

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.

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.

3.

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

4.

How is the model's time unit granularity defined?

Choose the correct answer.

By the model settings

By the imported data

By the date dimension

By the import query

5.

What time pattern is supported for the Date dimension?

Choose the correct answer.

4-4-4

4-5-5

13x4

12x4

6.

What is a prerequisite for creating a custom time hierarchy?

Choose the correct answer.

Add the hierarchy to the source system

Add time-related properties to the date dimension

Change the date dimension to organize date by fiscal year

7.

Dimension member formulas are only available for the account type dimension.

Choose the correct answer.

True

False

8.

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.

9.

Model imports settings allow you stop an import job if one step fails.

Choose the correct answer.

True

False

10.

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

Knowledge quiz

How can the currency table be updated?

Which of the following can you do in the Prepare Data step when importing and transforming transaction data into an import model?

In the Review Import step, if there are no issues which area will be blank?

How is the model's time unit granularity defined?

What time pattern is supported for the Date dimension?

What is a prerequisite for creating a custom time hierarchy?

Dimension member formulas are only available for the account type dimension.

Which of the following statements about calculated measures are true?

Model imports settings allow you stop an import job if one step fails.

Where does SAP Analytics Cloud store exchange rates?