When using an OLAP data source, summaries that use 'For' clauses give incorrect results. Which best describes the reason for this?

Question

Options

• ATime state rollups against OLAP data sources are not supported
• BOLAP data sources do not have detail rows
• CThe 'For' clause does not generate incorrect summaries.
• DIncorporating context filters using MDX functions is not supported.

• A
  5% (3)
• B
  11% (6)
• C
  82% (46)
• D
  2% (1)

Explanation

Option C is correct because it directly refutes the false premise in the question - 'For' clauses in summaries do not produce incorrect results with OLAP data sources; they function as expected. The question is a classic trap designed to test whether you'll accept a faulty assumption without questioning it.

Option A is incorrect because time state rollups are supported against OLAP data sources. Option B is a partial truth (OLAP data is indeed pre-aggregated without traditional detail rows), but this doesn't cause 'For' clause errors - it's a red herring that sounds plausible. Option D is incorrect because incorporating context filters via MDX functions is supported in OLAP reporting.

Memory tip: When an exam question describes a known behavior as "incorrect," always consider whether the premise itself is the trap. If you see answer choice wording like "does not generate incorrect summaries," that's a signal the question is testing whether you'll second-guess a working feature. Anchor on what you know works - 'For' clauses are reliable with OLAP.

No community discussion yet for this question.