IBM
COG-706 · Question #33
COG-706 Question #33: Real Exam Question with Answer & Explanation
The correct answer is B. Set up query variables for both the current and prior years.. See the full explanation below for the reasoning.
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.
Community Discussion
No community discussion yet for this question.