(4. OfficeConnect) Filters, Reports and Ad Hoc Analysis

Question 1

OfficeConnect reports follow precedence rules for filtering. The order goes, from highest precedence to lowest; ___, ___, columns, ___, workbook, ___.

Answer 1

Cell, row, columns, worksheet, user defaults.

Cell > Row > Columns > Worksheet > Workbooks > User Defaults.

Question 2

You cannot apply filters to an entire workbook. True or false?

Answer 2

False (you apply workbook filters to an entire workbook and to an individual worksheet).

Question 3

All element types are available for repeating reports, except active ___ elements. To use a ___ element for a repeat, first clear the element in the Worksheet Filters window.

Answer 3

Filter, filter

Question 4

Explore commands OfficeConnect has include…

1. Expand and Collapse.
2. Keep Only and Remove Only.
3. Drill Up.
4. Explore Cell.

Answer 4

1. Expand and Collapse.
2. Keep Only and Remove Only.
3. Explore Cell.

Question 5

You can only select Explore Cell on a cell that has at least an account, version, level, and time applied to the cell. True or false?

Answer 5

True (You can optionally include dimension elements.)

Question 6

The Explore Cell window enables you to…

1. View cell details such as the contributing values and time, rollups, level, and account information. You can also view the ___ used to calculate the cell value.
2. View the ___ ___ report with the history of user-entered changes for the cell.
3. Drill into Workday to view ___, if your model integrates with Workday.

Answer 6

Formula, audit, trail, transactions.

Question 7

You can apply and expand all parent custom dimensions and attributes. True or false?

Answer 7

True