Class 8: Parameters + LOD

Question 1

WIndow Functions

Answer 1

when you need the aggregate of an aggregate

Question 2

parameters

Answer 2

will be on the final exam

Question 3

when you dont have LOD calculations

Answer 3

performs calculation across all rows of table (i.e., no dimension of the view is considered)

Question 4

{fixed […]: …}

Answer 4

level of detail defined by […] (irrespective of level of detail in view)

Question 5

{exclude[…]: …}

Answer 5

excludes […] from level of detail in view (i.e., less granular,
since it takes out a dimension that is in the view)

Question 6

{include[…]:…}

Answer 6

includes […] from level of detail in view (i.e., more granular,
since it ads another dimension that is not in the view)