Examice

Exam C2090-621 All QuestionsBrowse all questions from this exam

Question 69

A customer wants to report the product types with the largest average revenue. In addition, the total revenue should be shown and all product types with revenue less than three percent (>3%) in a single bar.

Targeting this result:

How can this be done?

Using a visualization, because it is not possible in the default chart engine.

Using the property "summarize small items" on the chart, the type total and setting the item label. Set the order on the default measure.

Using the property "summarize small items" on the chart, the type average and setting the item label. Set the order on the chart node member.

Writing a new query where you summarize the Product types and create a new "My small value" item based on the calculated average. Order the values in the query.

Correct Answer: C

The requirement is to report product types with the largest average revenue and consolidate product types with revenue less than three percent into a single bar labeled accordingly. The correct solution is to use the 'summarize small items' property on the chart, select the type average, and set the item label. Then, you need to set the order based on the chart node member. This configuration ensures that the chart consolidates less significant items into a single 'My small values' bar, as shown in the provided image.

Discussion

prueba1231231231Option: C

incorrect C) is correct https://www.ibm.com/support/knowledgecenter/SSEP7J_11.1.0/com.ibm.swg.ba.cognos.ug_cr_rptstd.doc/t_small_slices.html