LOD

Question 1

True or False?

Datasets with more records always contain higher lvl of granularity than datasets with less records

Answer 1

False

the amount of records is not a direct indicator of the data granularity. It’s what one record of data represents that determines the level of detail of the dataset

Question 2

True or False:

LOD expressions require the same dimensions to be present in the canvas

Answer 2

False

LOD expressions are used so that the dimensions DON’T have to be present in the canvas

Question 3

Unlike ___ LOD expressions, ____ is sensitive to adding or removing dimensions in the view, as doing this will change the calculation.

Answer 3

FIXED
INCLUDE & EXCLUDE

Question 4

What will happen to a FIXED LOD expression if you add/remove dimensions in the view?

Answer 4

Nothing

Question 5

What will happen to an INCLUDE LOD expression if you add/remove dimensions in the view?

Answer 5

the calculations will change therefore the results will change

Question 6

What will happen to an EXCLUDE LOD expression if you add/remove dimensions in the view?

Answer 6

the calculations will change therefore the results will change

Question 7

Why would you use an EXCLUDE LOD instead of the Analysis tab for calculating subtotals?

Answer 7

B/c using the analysis tab does not allow us to further calculate the totals, for example, using the total to create a new column calculating the percentage

see image in doc.

Question 8

Where do FIXED LODs lie in the Order of Operations

Answer 8

Context Filters then
Fixed LODs then
Dimension Filters

Question 9

Where do Include/Exclude LODs lie in the Order of Operations

Answer 9

Dimension Filters then
Include/Exclude LOD then
Measure Filters

Question 10

What is the full Order of Operations for Filters and LODs

Answer 10

Extract Filters
Data Source Filters
Context Filters
Fixed LOD
Dimension Filters
Exclude/Include LOD
Table Calc Filters

Question 11

A typical use case of ___ is calculating totals & subtotals

Answer 11

Exclude

Question 12

____ calculates at a higher LOD than the one which is present in the visualization

Answer 12

Exclude

Question 13

Calculates at a lower LOD than the database

Answer 13

Include

Question 14

Calculates at a finer LOD than the database

Answer 14

Include

Question 15

___ LOD expression allows you to calculate on a finer detail of the data and re-aggregate it on the canvas on a coarser level.

Answer 15

INCLUDE