You are developing a SQL Server Analysis Services (SSAS) cube that contains the data for a

running team.
The data warehouse used by the cube contains the time durations of laps run by each runner on
the team. The time durations are stored in seconds as an integer.
You need to build the following two measures in the cube:
A measure named Measure1 that must contain the average time duration of the laps run by
each runner.
A measure named Measure2 that must contain the lap-time duration and the name of the runner
who ran the fastest lap.
What should you do? To answer, select the appropriate Aggregation Function property for each
measure in the answer area.

Hot Area:

Answer:

Explanation:

Note: For Measure1 we use Average, and for Measure2 Min to get the fastest time.