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.
Hide Member of Property for State : No Name
Hide Member of property for City :Never
Members with Data Property for Employee : NoLeafDataVisible
http://www.200-120exam.com/wp-content/uploads/2015/02/clip_image00914.jpg
http://www.200-120exam.com/wp-content/uploads/2015/02/clip_image01114.jpg
I agree
I agree with Carlos
Hide Member of Property for State : No Name
Hide Member of property for City :Never
Members with Data Property for Employee : NoLeafDataVisible
I agree with Carlos & Ralph