nerdexam
IBM

COG-706 · Question #33

A user is retrieving data from 2009 and 2010 using an OLAP connection. How can the retrieval be automated so when the report is rolled over to 2011, data from 2011 and 2010 will be retrieved?

Sign in or unlock COG-706 to reveal the answer and full explanation for question #33. The question stem and answer options stay visible for context.

Question

A user is retrieving data from 2009 and 2010 using an OLAP connection. How can the retrieval be automated so when the report is rolled over to 2011, data from 2011 and 2010 will be retrieved?

Options

  • ASet up ##S variables for both the current and prior years and use ##D to retrieve the data.
  • BSet up query variables for both the current and prior years.
  • CSet up ##GSD variables for both the current and prior years.
  • DSet up note variables for both the current and prior years.

Unlock COG-706 to see the answer

You've previewed enough free COG-706 questions. Unlock COG-706 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Full COG-706 Practice