(2 OM) 13. Sheets

Question 1

There are two permissions related to accessing sheets…

1. Access Sheets.
2. Edit Sheets.
3. Editable Sheet Access.
4. Import Sheets.

Answer 1

1. Access Sheets (allows you to open and view sheets).
2. Editable Sheet Access (allows you to edit data on sheets).

Question 2

Standard sheets display ___ across the columns and either ___ or ___ down the rows.

Answer 2

Time, Accounts, Levels.

Question 3

Use anomaly detection to discover hidden trends and outliers in your data.
Anomaly detection uses an algorithm that references your actuals. You must have at least ___ data points of actuals data in an account for anomaly detection to work for that account.

Answer 3

24

Question 4

You must create a new plan version for predicting values prior to generating predictions using intelligent planning. True or false?

Answer 4

True.

Question 5

Anomaly detection is available only within certain areas of your model. Anomaly detection works for…

1. GL Accounts.
2. Custom Accounts.
3. Cube Accounts.
4. Standard Sheets.
5. Modelled Sheets.
6. Plan Versions.
7. Child Levels.
8. Web Sheets.

Answer 5

1. GL Accounts.
2. Custom Accounts.
3. Standard Sheets.
4. Plan Versions.
5. Child Levels.
6. Web Sheets.

Question 6

Anomaly detection does not work for…

1. Rollup data.
2. (Only) Levels.
3. Actuals versions.
4. OfficeConnect reports
5. All accounts excluding general ledger and custom accounts.
6. Cube and modeled sheets.

Answer 6

1. Rollup data.
2. (Only) Levels.
3. Actuals versions.
4. OfficeConnect reports
5. All accounts excluding general ledger and custom accounts.
6. Cube and modeled sheets.

Question 7

In Modelled Sheets, you can enter data at rollup Levels. True or false?

Answer 7

True (if you enable the sheet setting “Allow editing while viewing rollup levels.”)

Question 8

Modeled sheets do not require a time period by default. True or false?

Answer 8

True

Question 9

How many timespan fields are allowed in Modelled Sheets?

1. 1
2. 5
3. As many as you want.

Answer 9

1.1

Question 10

In a Modelled Sheet, which field is the only field which can contain formulas?

1. Account.
2. Timespan.
3. Dimensions.
4. Levels.

Answer 10

2. Timespan.

Question 11

You can do Version comparison on Modelled Sheets. True or false?

Answer 11

False

Question 12

A derived dimension has values that auto-populate in ___ sheets based on mapping rules. This helps your planners have fewer fields to input and to better control the contents of those fields.

Answer 12

Modelled.

Question 13

Up to how many dimensions can you select to evaluate a derived dimension value?

1. 3
2. 6
3. 9
4. 10

Answer 13

2. 6

Question 14

You can override a derived dimension. True or false?

Answer 14

True

Question 15

Derived dimensions are ___-specific and mappings automatically apply your derived dimension rules at a ___ level to all ___ levels.

Answer 15

Version, parent, child.

Question 16

The derived dimensions mapping will only take effect if you use the same dimensions within the modeled sheet for data entry. True or false?

Answer 16

True

Question 17

Cube sheets display elements across the vertical and horizontal axes. The horizontal axis only allows one element, while the vertical axis allows you to stack for multiple elements on top of each other. True or false?

Answer 17

True

Question 18

Cube sheet maximum limits are 5GB in-memory limit per version, ___ row display limit and ___ dimensions.

Answer 18

15000, 10

Question 19

Cube sheet core components which are required include…

1. Accounts
2. Time
3. Version
4. Dimensions
5. Attributes
6. Levels

Answer 19

1. Accounts
2. Time
3. Levels

Question 20

You can enter data into rollup accounts, levels and dimensions on cube sheets. True or false?

Answer 20

False (You can however enter data at individual values and rollup values for Attributes).

Question 21

You can delete a dimension from the cube sheet, even if data exists within that dimension. True or false?

Answer 21

False (The administrator must select “Erase All Data” from the cube sheet summary page to remove the dimension.)

Question 22

Assumption (aka user assigned) sheets are assigned by ___ instead of ___.

Answer 22

User, Level.

Question 23

There are two significant differences regarding security with assumption sheets…

1. Assumption sheets don’t abide by access rules. Any user assigned to an assumption sheet can view data for all levels enabled on assumption sheets. True or false?
2. Assumption sheets don’t abide by the permission Access salary detail, therefore allowing users to view salary detail. True or false?

Answer 23

1. True
2. True

Question 24

You can add ___ accounts to Assumption Sheets or Level Assigned Sheets. However, these accounts are only editable at the ___ rollup (only) level.

Answer 24

Assumption, highest

Question 25

A process is an ordered ___ list, designed by a process owner, to navigate assignees to their work. Tasks and processes help teams collaborate to complete business processes such as fiscal period close or quarterly budget review.

Answer 25

Task

Question 26

When a process owner creates tasks, what type of tasks can be selected?... 1. Standard Task. 2. Level Workflow Task. 3. Attribute Assignment Task. 4. Sheet Workflow Task. 5. Dashboard Review Task.

Answer 26

1. Standard Task. 2. Level Workflow Task. 4. Sheet Workflow Task.

Question 27

A Standard task associates with content such as ___, ___, ___, or ___. You can assign a standard task to a specific user or user group.

Answer 27

Sheets, reports, workflows, dashboards

Question 28

A Level workflow task is performed on a specific ___ and ___ intersection. You ___ assign this task type to a specific user or user group. Only owners of the speci­fied level with access to the specified version can see this task.

Answer 28

Version, Level, cannot

Question 29

A Sheet workflow task is assigned to a specific ___ and user assigned sheet. You ___ assign this task type to a specific user or a user group. Only users with access to the specified version and sheet can view this task.

Answer 29

Version, cannot

Question 30

Workflow provides an ___ process for completed sheets, both level assigned and user assigned (assumption) sheets. Once you complete all data entry for sheets, submit them to a manager or supervisor for approval. After approval, each individual level locks for the specified ___ and ___ intersection.

Answer 30

Approval, Version, Level

Question 31

For individual Levels, you can set the following status options... 1. Submit 2. Approve 3. Recall 4. Reject

Answer 31

1. Submit (locks cells at specified version and level intersection). 2. Approve (locks all cells on all sheets for all users, for a specific version and level intersection). 3. Recall (only available once the planner selects Submit, and lets you recall the submission if you want to make further changes.)

Question 32

For rollup Levels, you can set the following status options... 1. Submit 2. Approve 3. Recall 4. Reject

Answer 32

1. Submit (automatically set all child levels to the approved and locked status.) 2. Approve (automatically set all child levels and the rollup level to the approved and locked status.) 4. Reject (automatically set all child levels to the rejected status and unlocks all child levels).

Question 33

Workflow is typically only used for Planning versions but can also be used for Actuals. True or false?

Answer 33

True (Note that you cannot enter data into a sheet after levels are approved with workflow in the actuals version, though importing data into levels is still permitted.)

Question 34

What are some pros of cube sheets? 1. Unlimited number of rows and columns. 2. Can have multiple dimensions. 3. Dimensions apply to all versions of the model. 4. Debit and credit classifications available. 5. You can pivot data between rows and columns. 6. The time stratum is customisable.

Answer 34

2. Can have multiple dimensions. 3. Dimensions apply to all versions of the model. 5. You can pivot data between rows and columns. 6. The time stratum is customisable.

Question 35

You can use Attributes on ___ and ___ sheets.

Answer 35

Modelled, cube.

Question 36

What are some pros of modelled sheets? 1. Suitable for large datasets. 2. They are time stratum flexible. 3. Sheet formulas calculate across the entire version. 4. Sheet security can protect against the permission "Access Salary Detail." 5. They allow actuals overlay. 6. They allow multiple time spans.

Answer 36

1. Suitable for large datasets. 2. They are time stratum flexible. 3. Sheet formulas calculate across the entire version. 4. Sheet security can protect against the permission "Access Salary Detail." (5 and 6 are cons of modelled sheets).