(2 OM) 13. Sheets Flashcards
There are two permissions related to accessing sheets…
- Access Sheets.
- Edit Sheets.
- Editable Sheet Access.
- Import Sheets.
- Access Sheets (allows you to open and view sheets).
- Editable Sheet Access (allows you to edit data on sheets).
Standard sheets display ___ across the columns and either ___ or ___ down the rows.
Time, Accounts, Levels.
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.
24
You must create a new plan version for predicting values prior to generating predictions using intelligent planning. True or false?
True.
Anomaly detection is available only within certain areas of your model. Anomaly detection works for…
- GL Accounts.
- Custom Accounts.
- Cube Accounts.
- Standard Sheets.
- Modelled Sheets.
- Plan Versions.
- Child Levels.
- Web Sheets.
- GL Accounts.
- Custom Accounts.
- Standard Sheets.
- Plan Versions.
- Child Levels.
- Web Sheets.
Anomaly detection does not work for…
- Rollup data.
- (Only) Levels.
- Actuals versions.
- OfficeConnect reports
- All accounts excluding general ledger and custom accounts.
- Cube and modeled sheets.
- Rollup data.
- (Only) Levels.
- Actuals versions.
- OfficeConnect reports
- All accounts excluding general ledger and custom accounts.
- Cube and modeled sheets.
In Modelled Sheets, you can enter data at rollup Levels. True or false?
True (if you enable the sheet setting “Allow editing while viewing rollup levels.”)
Modeled sheets do not require a time period by default. True or false?
True
How many timespan fields are allowed in Modelled Sheets?
- 1
- 5
- As many as you want.
1.1
In a Modelled Sheet, which field is the only field which can contain formulas?
- Account.
- Timespan.
- Dimensions.
- Levels.
- Timespan.
You can do Version comparison on Modelled Sheets. True or false?
False
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.
Modelled.
Up to how many dimensions can you select to evaluate a derived dimension value?
- 3
- 6
- 9
- 10
- 6
You can override a derived dimension. True or false?
True
Derived dimensions are ___-specific and mappings automatically apply your derived dimension rules at a ___ level to all ___ levels.
Version, parent, child.
The derived dimensions mapping will only take effect if you use the same dimensions within the modeled sheet for data entry. True or false?
True
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?
True
Cube sheet maximum limits are 5GB in-memory limit per version, ___ row display limit and ___ dimensions.
15000, 10
Cube sheet core components which are required include…
- Accounts
- Time
- Version
- Dimensions
- Attributes
- Levels
- Accounts
- Time
- Levels
You can enter data into rollup accounts, levels and dimensions on cube sheets. True or false?
False (You can however enter data at individual values and rollup values for Attributes).
You can delete a dimension from the cube sheet, even if data exists within that dimension. True or false?
False (The administrator must select “Erase All Data” from the cube sheet summary page to remove the dimension.)
Assumption (aka user assigned) sheets are assigned by ___ instead of ___.
User, Level.
There are two significant differences regarding security with assumption sheets…
- 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?
- Assumption sheets don’t abide by the permission Access salary detail, therefore allowing users to view salary detail. True or false?
- True
- True
You can add ___ accounts to Assumption Sheets or Level Assigned Sheets. However, these accounts are only editable at the ___ rollup (only) level.
Assumption, highest
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.
Task
When a process owner creates tasks, what type of tasks can be selected?…
- Standard Task.
- Level Workflow Task.
- Attribute Assignment Task.
- Sheet Workflow Task.
- Dashboard Review Task.
- Standard Task.
- Level Workflow Task.
- Sheet Workflow Task.
A Standard task associates with content such as ___, ___, ___, or ___. You can assign a standard task to a specific user or user group.
Sheets, reports, workflows, dashboards
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 specified level with access to the specified version can see this task.
Version, Level, cannot
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.
Version, cannot
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.
Approval, Version, Level
For individual Levels, you can set the following status options…
- Submit
- Approve
- Recall
- Reject
- Submit (locks cells at specified version and level intersection).
- Approve (locks all cells on all sheets for all users, for a specific version and level intersection).
- Recall (only available once the planner selects Submit, and lets you recall the submission if you want to make further changes.)
For rollup Levels, you can set the following status options…
- Submit
- Approve
- Recall
- Reject
- Submit (automatically set all child levels to the approved and locked status.)
- Approve (automatically set all child levels and the rollup level to the approved and locked status.)
- Reject (automatically set all child levels to the rejected status and unlocks all child levels).
Workflow is typically only used for Planning versions but can also be used for Actuals. True or false?
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.)
What are some pros of cube sheets?
- Unlimited number of rows and columns.
- Can have multiple dimensions.
- Dimensions apply to all versions of the model.
- Debit and credit classifications available.
- You can pivot data between rows and columns.
- The time stratum is customisable.
- Can have multiple dimensions.
- Dimensions apply to all versions of the model.
- You can pivot data between rows and columns.
- The time stratum is customisable.
You can use Attributes on ___ and ___ sheets.
Modelled, cube.
What are some pros of modelled sheets?
- Suitable for large datasets.
- They are time stratum flexible.
- Sheet formulas calculate across the entire version.
- Sheet security can protect against the permission “Access Salary Detail.”
- They allow actuals overlay.
- They allow multiple time spans.
- Suitable for large datasets.
- They are time stratum flexible.
- Sheet formulas calculate across the entire version.
- Sheet security can protect against the permission “Access Salary Detail.”
(5 and 6 are cons of modelled sheets).
