A.To allow filter push-down in stacked calculation views

B.To avoid columns being unnecessarily used in an aggregation

C.To include columns that are NOT requested by a query

D.To apply filters that are hidden from the end user

A.Access hierarchies created in external schemas

B.Provide reusable hierarchies for drilldown in a CUBE without star join

C.Provide reusable hierarchies for drilldown in a CUBE with star join

D.Enable SQL SELECT statements to access hierarchies

A.Debug Query mode

B.Explain plan

C.SQL analyzer

D.Database explorer

A.To store historical versions of attributes

B.To provide the time intervals required by time-dependent parent-child hierarchies

C.To provide additional time-related navigation possibilities

D.To add a temporal condition to a join to find matching records from two tables based on a date

A.To ensure that the aggregation always happens after the join execution

B.To force the calculation at the relevant level of granularity, even if this level is not the grouping level defined by the query

C.To ensure that the join execution only uses the join columns requested in the query

D.To allow data analysis at different levels of granularity with the same calculation view