Operations Modeling Basics Flashcards
Which of the following is considered a best practice with regards to levels? Check all that apply.
Avoid naming convention that requires frequent changes
Create a level structure where actuals and plan data exist at different levels
Organize levels with the same currency under a shared parent level
Use punctuation symbols in level names
Avoid naming convention that requires frequent changes
Organize levels with the same currency under a shared parent level
Which of the following options would be used when multiple levels use the same currency, but need different exchange rates?
Exchange Rate Type
Standard Currency
User Defined Currency
User Defined Exchange Rate Type
User Defined Currency
Fill in the blank: Similar to level attributes, level __________________ can be used to define alternate level hierarchies.
dimensions
Fill in the blank: A level structure ______________ can either overwrite, update or append any existing definitions.
import
Level access assigned to a rollup is automatically applied to all underlying levels.
True
False
True
The account code must be the same as the account code in the source system.
True
False
False
Net Income (Loss) and Year to Date Income (Loss) should never have data imported to them.
True
False
True
Which of the following is true when a structure import template contains errors?
The structure is imported for only those values that do not contain an error(s)
Nothing is loaded
Nothing is loaded
Data can be loaded to both attributes and dimensions.
True
False
False
A week that crosses two different months must use two different time codes.
True
False
True
The default time stratum can only be changed be deleting all standard account data.
True
False
True
Fill in the blank: __________________ can be created to organize versions.
Folders
Fill in the blank: Best practice is to enable _______________ when a version is complete to avoid potential inputs errors.
locked version
Which of the following is impacting by the version length? Check all that apply.
Importing data process
Number of formulas evaluated
Report generation time
Sheet load time
Number of formulas evaluated
Sheet load time
Fill in the blank: The Starting scroll location defines the first column of ______________ displayed in the sheet.
actuals
When logging in, users initially see the current version.
True
False
False
Fill in the blank: User security is based on the ________________ to which a user is assigned and the level(s) the user needs to access.
roles
Two predefined role groups are available. Both can be modified but not deleted.
True
False
False
When multiple administrators are required, best practice is to have only one “super” administrator with access to which of the following administrative permissions? Check all that apply.
Import to All Levels
Privileged Actuals Access
Roles
Users
Roles
Users
The Import Access permission does not respect level access.
True
False
True
Data can be erased for both Actuals and Plan data with the Erase Data functionality.
True
False
False
Data must be imported in the currency assigned to the level.
True
False
True
Users can view Actuals data based on the left scroll limit in a Plan version without the role permission Privileged Actuals Access.
True
False
True
Fill in the blank: An _______________ column is included in the import template when importing balance sheet account opening balances. (The answer is two words.)
Initial Balance
The standard template for Actuals import can be used for Plan imports to cube and modeled sheets.
True
False
False
Do not rename the Actuals tab in the data import template; data will load to the version selected on the Import Data page.
True
False
True
Which of the following is a driver of sheet performance? Check all that apply.
Accounts
Dimensions
Formulas
Levels
Accounts
Dimensions
Formulas
Levels
Which of the following is true of standard sheets? Check all that apply.
Allow for account customization
Data withstands sheet deletion
Default time stratum independence
Support version comparison
Allow for account customization
Data withstands sheet deletion
Support version comparison
Fill in the blank: Adding rollup, or parent accounts, to the sheet automatically adds any current or future _______________ .
children
Fill in the blank: In _____________________ mode, accounts display as a drop-down selection.
View By Level
Setting an account to read-only within the account group affects all levels.
True
False
True
Fill in the blank: Best practice dictates that __________________________ should be run on a version when completed to ensure that there are no formula errors.
formula validation
Which of the following are true concerning formula best practices? Check all that apply.
Avoid using dates
Reference time rollups or a prior period with the modifier time.this syntax
Avoid using hard-coded drivers in formulas
Use the * symbol to annotate a formula
Avoid using dates
Avoid using hard-coded drivers in formulas
Fill in the blank: The __________________ for an account must be set to one of the public options for its data to evaluate in a formula that crosses organization levels.
data privacy
Fill in the blank: this.account and version.name are examples of _____________________ syntax.
dot notation
Shared formulas do not support dimensionality.
True
False
True
Fill in the blank: _______________formulas delete all existing data from the account.
master
Personnel can be planned by week in a modeled sheet even with the default time stratum set to month.
True
False
True
Fill in the blank: Modeled sheets allow for only one ______________ column.
timespan
Modeled sheets support version comparison.
True
False
False
Fill in the blank: Modeled sheet design is performed within the __________________ which consists of three panes.
sheet editor
Fill in the blank: ______________ is a required column type and included by default in a new modeled sheet.
level
Which column type is not available for use in matrix reports or formulas.
Text Selector
Text
Timespan
Date
Text Selector
Which account type only allows for data entry at the highest (only) level of the structure?
Assumption
Custom
Metric
Modeled
Assumption
Modeled accounts include the sheet code as a prefix to all accounts. Once created, this code can be modified.
True
False
False
Which of the following is true of user-assigned sheets? Check all that apply.
Respect level access
Do not respect Access salary detail permission
Administrator selects the users who can view the user-assigned sheet
Only a modeled sheet can be a user-assigned sheet
Do not respect Access salary detail permission
Administrator selects the users who can view the user-assigned sheet
Cube accounts can be created manually or imported with the Import Structure feature.
True
False
True as of 2021R1. New functionality.
Which general ledger account supports the use of the Formulas sheet to create formulas?
cube
standard
standard
Which of the following is true of cube general ledger accounts? Check all that apply.
Must be added to a cube sheet.
Data entry to the account is performed on a cube sheet
Can be displayed on a standard or cube sheet
Formulas can be entered on the Formulas sheet or in each cell
Must be added to a cube sheet.
Data entry to the account is performed on a cube sheet
Can be displayed on a standard or cube sheet
Fill in the blank: Up to ten_______________ can be added to a cube sheet.
dimensions
An account’s type cannot be modified. If an error is made, delete the account and begin again.
True
False
True
Fill in the blank: _________________ are created at the intersection of any two elements in order to hide or make certain input cells read-only.
restrictions
Linked accounts do not cross all versions and levels.
True
False
False
