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