ExamGecko
Question list
Search
Search

Question 9 - C_SAC_2415 discussion

Report
Export

You import data into a dataset. One of the columns imported is Year, and SAP Analytics Cloud interprets it as a measure. How can you ensure that it is treated as a calendar year?

A.

Change the Year measure to a dimension in the dataset.

Answers
A.

Change the Year measure to a dimension in the dataset.

B.

Includes the Year measure in a level-based time hierarchy in the dataset.

Answers
B.

Includes the Year measure in a level-based time hierarchy in the dataset.

C.

Insert a character into the Year measure using the transform bar.

Answers
C.

Insert a character into the Year measure using the transform bar.

D.

Add the month as a suffix to the Year measure.

Answers
D.

Add the month as a suffix to the Year measure.

Suggested answer: A

Explanation:

If SAP Analytics Cloud interprets a 'Year' column as a measure instead of a dimension, it should be changed to a dimension to ensure it is treated as a calendar year. This adjustment can be made within the model or dataset settings, where the column's role can be switched from a measure (quantitative value) to a dimension (qualitative value). Treating 'Year' as a dimension allows it to be used appropriately in time-based analyses, such as trends over time, without being aggregated like a numerical measure.

asked 31/10/2024
Daniel Ramos
34 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first