You are developing a SQL Server Analysis Services (SSAS) tabular project.
A column named City must be added to the table named Customer. The column will be used in the definition of a hierarchy. The City column exists in the
Geography table that is related to the Customer table.
You need to add the City column to the Customer table.
How should you write the calculation?

A. City:= LOOKUP(Geography[City],Geography[GeographyKey],[GeographyKey])
B. City:= LOOKUPVALUE(Geography[City],Geography[GeographyKey],[GeographyKey])
C. =RELATED(Geography[City])
D. =RELATED(Geography.City)
E. =VALUES(Geography[City])
F. City:=VALUES(Geography[City])

  Discussion forum


Leave an answer