How do you change the dimension on which a section is based?

• A.Right click in a blank area of the section. Select Edit Section. Choose the new dimension.
• B.Right click the section cell. Select Sort. Select Advanced. Remove the existing dimension. Add the new dimension.
• C.Right click the section cell. Select Edit Formula. Choose the new dimension.
• D.Right click in a blank area of the section. Select Format Section. Modify dimension after "Section on:".

Comment: *

Name: *

Email: *

Verification: *

Why is the subtotal missing from the bottom of each break in the attached diagram?

• A.The report is NOT sectioned by year.
• B.The calculation was applied to the table before the break.
• C.The break footers display option is NOT selected.
• D.The default aggregation on the measure is delegated.

Comment: *

Name: *

Email: *

Verification: *

When scheduling a Web Intelligence document, what output formats are available? Note: There are 2 correct Answers to this question.

• A.Plain Text (TXT)
• B.Adobe Acrobat (PDF)
• C.Microsoft PowerPoint (PPT)
• D.HyperText Markup Language (HTML)

Comment: *

Name: *

Email: *

Verification: *

You are asked to create a table to display revenue data values in three distinct colors. What must you create in a single conditional formatting rule?

• A.A single formula using the WHERE operator
• B.Multiple Else conditions
• C.Multiple predefined filters
• D.A single formula using the IF function

Comment: *

Name: *

Email: *

Verification: *

A table contains a dimension [CITY] and a measure [SALES]. You insert a column to display the formula AVERAGE([SALES]). Which operator do you add to the formula so that it displays the average for the table in every row? Note: There are 2 correct Answers to this question.

• A.ForAll ([CITY])
• B.In Body
• C.ForEach ([CITY])
• D.In Block

Comment: *

Name: *

Email: *

Verification: *