A cube designer is creating a cube and has established the following dimension structure:

The cube designer would like to add the customer name and have it associated with the customer ID. Which action should the cube designer take?

Question

A cube designer is creating a cube and has established the following dimension structure:

The cube designer would like to add the customer name and have it associated with the customer ID. Which action should the cube designer take?

Accepted Answer

D. Add Customer_NAME as a new level, placing if after Customer_ID in the hierarchy

Answer

A. Add a level attribute to the Customer_ID level

Answer

B. Create a new hierarchy that contains Customer_Name instead of Customer_ID as a level

Answer

C. Add a member property to the Customer_ID level

A cube designer is creating a cube and has established the following dimension structure: The cube designer would like to add the customer name and have it associated with the customer ID. Which…