Explanation:Typically, the key attribute represents the primary key column or columns in the dimension table. 8. Which of the following property is set to zero so that all levels are not created ?
A. Aggregatable
B. IsAggregatable
C. IsAggregate
D. All of the mentioned
Answer:A
Explanation:Typically, the key attribute represents the primary key column or columns in the dimension table. 8. Which of the following property is set to zero so that all levels are not created ?
A. Aggregatable B. IsAggregatable C. IsAggregate D. All of the mentioned
Explanation:The All level contains the aggregated value of the attribute’s members across the measures in each measure group to which the dimension of which the attribute is related is a member. 9. By default, in a ________ schema, all attributes are directly related to the key attributes.