A.To provide access to your data model to additional client tools.

B.To support development of custom logic within calculation views.

C.As an alternative to developing calculation views when high performance is essential.

D.To make changes to the runtime objects of your calculation view with SQL.

A.From the SQL view data sources

B.From the table data sources

C.From the underlying dimension views

D.From the current calculation view

A.A table function that returns a list of allowed values.

B.An organization hierarchy that provides role-based access to data.

C.A scalar function that returns a list of the allowed values for each attribute.

D.A procedure that returns the data access condition as an SQL expression.

A.Use a spatial join to find the distance between clinics.

B.Use a union with constant values to "pivot" the values.

C.Use a temporal join to find the distance between clinics.

D.Use a ranking to find the top 10 values.

E.Use an aggregation with the maximum option.

F.Use a dynamic join to find the longest distance between clinics.

G.Use a level hierarchy for drilldown.

H.Use a spatial join to find the distance between clinics.

A.Multiple entries

B.Single value

C.Range

D.Interval