READ Free Dumps For Cognos- BI0-112
Question ID 18185 | In Report Studio, an author merges Query1 and Query2 into one result set (Query3) using |
Option A | The author must add a sort key data item directly to Query3. |
Option B | The author must sort the Order method data item in Query1 and the Product line data item in Query2. |
Option C | The author must sort the data item in the Query3 that retrieves both Order method and Product line data. |
Option D | The author must add a sort key data item to Query1 and to Query2, and then add this sort key data item to Query3. |
Correct Answer | D |
Question ID 18186 | The following report was created in Report Studio using a relational package and shows |
Option A | Only reps who generated total revenue greater than 500,000. |
Option B | Only cities that generated total revenue greater than 500,000. |
Option C | Only countries that generated total revenue greater than 500,000. |
Option D | Only reps who had individual sales transactions of greater than 500,000. |
Correct Answer | A |