HOTSPOT
You have a database named DB1. DB1 contains three tables named FactSales, DimCustomer, and DimEmployee.
A sample from DimEmployee is shown in the following table.
A sample from DimCustomer is shown in the following table.
A sample from FactSales is shown in the following table.
You create a cube named Sales that uses the three tables. FactSales is used as a fact table, DimCustomer is used to create a dimension named Customer, and DimEmployee is used to create a dimension named Employee.
Users report the following issues:
• When browsing the Customer dimension, the users see a blank member in the state hierarchy under United Kingdom.
• When browsing the Employee dimension, the sales data for Sales Managers and Sales Supervisors is NOT displayed.
You need to resolve the issues by configuring the properties of the dimension attributes.
What should you do? To answer, select the appropriate value for each property in the answer area.
Answer: 
Leave a Reply