You are developing a Microsoft SQL Server 2005 Analysis Services (SSAS) project.

Your data source has the following tables:

Scenarios table that contains columns named ScenarioKey and ScenarioName.FactFinance table that contains a foreign key column named ScenarioKey.

You need to create a calculated column in a data source view named ScenarioCalc in the FactFinance table to display the ScenarioName.

Which expression should you use?

A.
Select ScenarioName as ScenarioCalc where ScenarioKey=FactFinance.ScenarioKey

B.
(Select ScenarioName from Scenarios where ScenarioKey=Scenarios.ScenarioKey)

C.
(Select ScenarioName from Scenarios where ScenarioKey=FactFinance.ScenarioKey)

D.
ScenarioCalc=Select ScenarioName from Scenarios where ScenarioKey=FactFinance.ScenarioKey