Question 11
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution. Determine whether the solution meets the stated goals.
You have an existing multidimensional cube that provides sales analysis. The users can slice by date, product, location, customer, and employee.
The management team plans to evaluate sales employee performance relative to sales targets. You identify the following metrics for employees:
You need to implement the KPI based on the Status expression.
Solution: You design the following solution:
Does the solution meet the goal?
You have an existing multidimensional cube that provides sales analysis. The users can slice by date, product, location, customer, and employee.
The management team plans to evaluate sales employee performance relative to sales targets. You identify the following metrics for employees:
You need to implement the KPI based on the Status expression.
Solution: You design the following solution:
Does the solution meet the goal?
Question 12
DRAG DROP
You are a business analyst for a company that uses a Microsoft SQL Server Analysis Services (SSAS) tabular database for reporting. The database model contains the following tables:
You have been asked to write a query for a report that returns the total sales for each product subcategory, as well as for each product category.
You need to write the query to return the data for the report.
How should you complete the DAX statement? To answer, drag the appropriate DAX segment to the correct locations. Each DAX segment may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
Select and Place:
You are a business analyst for a company that uses a Microsoft SQL Server Analysis Services (SSAS) tabular database for reporting. The database model contains the following tables:
You have been asked to write a query for a report that returns the total sales for each product subcategory, as well as for each product category.
You need to write the query to return the data for the report.
How should you complete the DAX statement? To answer, drag the appropriate DAX segment to the correct locations. Each DAX segment may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
Select and Place:
Question 13
You are building a Microsoft SQL Server Analysis Services multidimensional model over a
SQL Server database. In a cube named OrderAnalysis, there is a standard cube dimension named Stock Item.
This dimension has the following attributes:
Users report that the attributes Stock Item Key and Photo are distracting and are not providing any value. They have asked for the attributes to be removed. However, these attributes are needed by other cubes.
You need to hide the specified attributes from the end users of the OrderAnalysis cube.
You do not want to change the structure of the dimension.
Which change should you make to the properties for the Stock Item Key and Photo attributes?
SQL Server database. In a cube named OrderAnalysis, there is a standard cube dimension named Stock Item.
This dimension has the following attributes:
Users report that the attributes Stock Item Key and Photo are distracting and are not providing any value. They have asked for the attributes to be removed. However, these attributes are needed by other cubes.
You need to hide the specified attributes from the end users of the OrderAnalysis cube.
You do not want to change the structure of the dimension.
Which change should you make to the properties for the Stock Item Key and Photo attributes?
Question 14
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution. Determine whether the solution meets the stated goals.
You have a Microsoft SQL Server Analysis Services (SSAS) multidimensional database that stores customer and order data for customers in the United States only. The database contains the following objects:
You must create a KPI named Large Sales Target that uses the Traffic Light indicator to display status.
The KPI must contain:
You need to create the KPI.
Solution: You set the value of the Status expression to:
Does the solution meet the goal?
You have a Microsoft SQL Server Analysis Services (SSAS) multidimensional database that stores customer and order data for customers in the United States only. The database contains the following objects:
You must create a KPI named Large Sales Target that uses the Traffic Light indicator to display status.
The KPI must contain:
You need to create the KPI.
Solution: You set the value of the Status expression to:
Does the solution meet the goal?
Question 15
You are designing a SQL Server Analysis Services (SSAS) cube.You need to create a measure to count unique customers.What should you do?