IBM C2090-621 dumps - 100% Pass Guarantee!

A company distributes a monthly email to the sales managers at the beginning of each month that shows how well they are doing using a tabular formatted report. The report is delivered in Excel format and the sales managers would like the report to be in a Crosstab format.

How should the report be changed?

A. Use the convert list to Crosstab option. Format and sort the Crosstab appropriately. Save the report.

B. Add a Crosstab data container to the report. Format and sort it appropriately. Delete the list data container and save the report.

C. Use the convert list to Crosstab option. Format and sort the Crosstab appropriately. Add a page set that is grouped on sales manager. Save the report.

D. Add a repeater to the report. Use the convert list to Crosstab option. Format and sort the Crosstab appropriately. Place the Crosstab within the repeater. Create a Master detail relationship between the Crosstab and the repeater on sales manager. Save the report.

A report author needs to create an offline interactive report that can be filtered by clicking on a list of values. For example, by clicking on Region "A" the List will display only the details from Region "A".

Which Reaction behavior should be selected?

A. Enable a control.

B. Filter an item in a control.

C. Select an item in a control.

D. Create a report expression and use it in filters.

A report author wants to create an Active report with a Static Deck/ Each card should show a Chart with differently-filtered data.

What should the Chart for each card be based on?

A. An item that is a property of the page.

B. A query item that is a property of the Chart.

C. A unique query with a filter applied to the query.

D. Reuse the same query with a filter applied to the query.

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?

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

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

C. 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.

D. 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.

A report author wants to show a value that is independent from the rest of the values in the report. For example, the total revenue value in the header of each page in a report.

Which type of object should be used?

A. Repeater

B. Singleton

C. Layout calculation

D. Session parameter