(5.Web Reporting) 1. Audit Trail

Question 1

Audit Trail tracking allows you to run a report to view the history of changes to…

1. All ___ entered on sheets of any type, including those in custom accounts on standard sheets.
2. All sheet cells that allow users to ___ data, including date and text columns on ___ sheets, dimensions, and initial balances.
3. ___ formulas created on the Formulas page.
4. Values or formulas entered in ___ accounts, including those within global, cube sheet, and modeled sheets.
5. Monthly and spread ___ tables in modeled sheet builders.
6. Cell notes.
7. Currency ___ ___.

Answer 1

1. Data
2. Enter, Modelled
3. Shared
4. Assumption
5. Lookup
6. Exchange rates

Question 2

Turning off the audit trail deletes all audit trail information for the version. True or false?

Answer 2

True

Question 3

When you run an Audit Trail report “basic search”, the only requirement is you select a ___ and ___ range.

Answer 3

Level, time

Question 4

Once you start searching, the Audit Trail Search Results list includes details such as…

1. The time of change.
2. Who made the change.
3. The level, account or column, and row, split, or location of the change.
4. The time period.
5. Where the change was made (i.e in OfficeConnect or in web-based Adaptive Planning).
6. The old and new values.

Answer 4

1. The time of change.
2. Who made the change.
3. The level, account or column, and row, split, or location of the change.
4. The time period.
5. The old and new values.

Question 5

Characteristics of Report Templates include…

1. In addition to custom formatting, you can add ___, other summary data, and ___.
2. You can calculate data across different ___.
3. You can ___ the original report data tabs so users only view the template version.
4. You can create templates that are ___-specific.
5. You can add ___ for more advanced report formatting and transformation.

Answer 5

1. Notes, calculations.
2. Versions.
3. Hide.
4. Locale.
5. Macros.

Question 6

For repeating reports that use a template, you should add a formatting tab for every repeating tab of the report. True or false?

Answer 6

True

Question 7

When creating Report Templates, follow best practice such as…

1. Add new worksheet ___ when making customizations.
2. Before attaching the template, clear all data from the ___ ___ tab. This removes any stale data from the template and prevents you from exposing data to users who should not view it.
3. Use dynamic references in Excel.
4. Embed supported objects such as ___, ___, ___ and pivot tables.
5. Consider that users can add account ___ at any time.

Answer 7

1. Tabs
2. Report, data
3. Images, charts, graphs.
4. Splits.