What are the four pieces that make up a key performance

Question

Question 1- Provide a case when you would use a URL Action with the target being a specific measure. What would be the business purpose for this?

Question 2- What is a Drill Through Action used for? What risks are associated with defining too many Drill Through Actions?

Question 3- Relational OLAP - data stored in the database, Multidimensional OLAP - data stored in the cube, Hybrid OLAP - aggregates are stored in the cube and details are stored database. Explain the design considerations in how you would decide which storage type to use.

Question 4- What would be the purpose of defining multiple partitions for a given measure group? In other words, what sort of issues are you able to solve by splitting the data into multiple partitions.

Question 5- What are the four pieces that make up a Key Performance Indicator (KPI)? Provide an example of a KPI based on the AdventureWorks database. When would it not make sense to use KPI's.

Question 6- What is a typical purpose for writing data back to a cube? Explain the fundmental difference between dimension write back and measure write back. Where do the changes get stored in each case?

Question 7- Given the range of reporting and data extraction tools, when does it make sense to use OLAP? What would you consider the main selling points of OLAP technology? When would OLAP not be a good choice?

Answer 1

Make sure to read the below questions properly and please apply the concepts of DBMS to respond for the following: Q1. Give a case when you would utilize a URL Action by means of the target being a particular measure. Explain what would be the business rationale for this? Q2. What do you mean by the Drill through Action used for? What are the risks related with defining numerous Drill through Actions? Q3. Relational OLAP - data stored in the database, Multidimensional OLAP - data stored in the cube, Hybrid OLAP - aggregates are stored in the cube and information are stored database. Describe the design considerations in how you would decide which storage kind to use. Q4. Illustrate what would be the aim of defining the multiple partitions for a particular measure group? In another words, what kind of issues are you capable to resolve by splitting the data to multiple partitions.