How should you write the calculation?

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?

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:=RELATEDTABLE(Geography)

B.
City:=Geography[City]

C.
=RELATED(Geography[City])

D.
City:=RELATED(Geography[City])

E.
=RELATEDTABLE(Geography)

F.
=Geography[City]



Leave a Reply 1

Your email address will not be published. Required fields are marked *


Marchello

Marchello

C.
=RELATED(Geography[City])