Which of the following can you use to create a calculated field that returns data independent of the data granularity in a view?

Question

Options

• AAn INCLUDE LOD calculation
• BA table calculation
• CA basic calculation
• DA FIXED LOD calculation

• A
  13% (4)
• B
  3% (1)
• C
  23% (7)
• D
  60% (18)

Explanation

A FIXED LOD calculation computes values at a specified dimension level regardless of what dimensions are in the view - it is completely independent of the view's granularity. For example, { FIXED [Customer] : SUM([Sales]) } always returns customer-level sales whether the view is filtered by region, date, or anything else.

Why the distractors are wrong:

• A (INCLUDE LOD): INCLUDE adds dimensions to the view's granularity rather than ignoring it, so the result changes as the view changes.
• B (Table calculation): Table calculations operate on the result set already in the view, making them entirely dependent on view granularity.
• C (Basic calculation): Basic (row-level or aggregate) calculations are evaluated at the view's level of detail and change as dimensions are added or removed.

Memory tip: Think of FIXED as "fixed in stone" - it locks onto the dimensions you specify and refuses to budge no matter what the view does around it. INCLUDE and EXCLUDE are "view-relative" (they negotiate with the view), while FIXED is "view-independent."

No community discussion yet for this question.