Operations Modeling Basics Flashcards

1
Q

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

A

Avoid naming convention that requires frequent changes

Organize levels with the same currency under a shared parent level

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

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

A

User Defined Currency

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Fill in the blank: Similar to level attributes, level __________________ can be used to define alternate level hierarchies.

A

dimensions

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Fill in the blank: A level structure ______________ can either overwrite, update or append any existing definitions.

A

import

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Level access assigned to a rollup is automatically applied to all underlying levels.

True
False

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

The account code must be the same as the account code in the source system.

True
False

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Net Income (Loss) and Year to Date Income (Loss) should never have data imported to them.

True
False

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

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

A

Nothing is loaded

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Data can be loaded to both attributes and dimensions.

True
False

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

A week that crosses two different months must use two different time codes.

True
False

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

The default time stratum can only be changed be deleting all standard account data.

True
False

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Fill in the blank: __________________ can be created to organize versions.

A

Folders

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Fill in the blank: Best practice is to enable _______________ when a version is complete to avoid potential inputs errors.

A

locked version

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

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

A

Number of formulas evaluated

Sheet load time

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Fill in the blank: The Starting scroll location defines the first column of ______________ displayed in the sheet.

A

actuals

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

When logging in, users initially see the current version.

True
False

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

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.

A

roles

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

Two predefined role groups are available. Both can be modified but not deleted.

True
False

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

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

A

Roles

Users

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

The Import Access permission does not respect level access.

True
False

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

Data can be erased for both Actuals and Plan data with the Erase Data functionality.

True
False

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

Data must be imported in the currency assigned to the level.

True
False

A

True

23
Q

Users can view Actuals data based on the left scroll limit in a Plan version without the role permission Privileged Actuals Access.

True
False

A

True

24
Q

Fill in the blank: An _______________ column is included in the import template when importing balance sheet account opening balances. (The answer is two words.)

A

Initial Balance

25
Q

The standard template for Actuals import can be used for Plan imports to cube and modeled sheets.

True
False

A

False

26
Q

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

A

True

27
Q

Which of the following is a driver of sheet performance? Check all that apply.

Accounts
Dimensions
Formulas
Levels

A

Accounts
Dimensions
Formulas
Levels

28
Q

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

A

Allow for account customization

Data withstands sheet deletion

Support version comparison

29
Q

Fill in the blank: Adding rollup, or parent accounts, to the sheet automatically adds any current or future _______________ .

A

children

30
Q

Fill in the blank: In _____________________ mode, accounts display as a drop-down selection.

A

View By Level

31
Q

Setting an account to read-only within the account group affects all levels.

True
False

A

True

32
Q

Fill in the blank: Best practice dictates that __________________________ should be run on a version when completed to ensure that there are no formula errors.

A

formula validation

33
Q

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

A

Avoid using dates

Avoid using hard-coded drivers in formulas

34
Q

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.

A

data privacy

35
Q

Fill in the blank: this.account and version.name are examples of _____________________ syntax.

A

dot notation

36
Q

Shared formulas do not support dimensionality.

True
False

A

True

37
Q

Fill in the blank: _______________formulas delete all existing data from the account.

A

master

38
Q

Personnel can be planned by week in a modeled sheet even with the default time stratum set to month.

True
False

A

True

39
Q

Fill in the blank: Modeled sheets allow for only one ______________ column.

A

timespan

40
Q

Modeled sheets support version comparison.

True
False

A

False

41
Q

Fill in the blank: Modeled sheet design is performed within the __________________ which consists of three panes.

A

sheet editor

42
Q

Fill in the blank: ______________ is a required column type and included by default in a new modeled sheet.

A

level

43
Q

Which column type is not available for use in matrix reports or formulas.

Text Selector
Text
Timespan
Date

A

Text Selector

44
Q

Which account type only allows for data entry at the highest (only) level of the structure?

Assumption
Custom
Metric
Modeled

A

Assumption

45
Q

Modeled accounts include the sheet code as a prefix to all accounts. Once created, this code can be modified.

True
False

A

False

46
Q

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

A

Do not respect Access salary detail permission

Administrator selects the users who can view the user-assigned sheet

47
Q

Cube accounts can be created manually or imported with the Import Structure feature.

True
False

A

True as of 2021R1. New functionality.

48
Q

Which general ledger account supports the use of the Formulas sheet to create formulas?

cube
standard

A

standard

49
Q

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

A

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

50
Q

Fill in the blank: Up to ten_______________ can be added to a cube sheet.

A

dimensions

51
Q

An account’s type cannot be modified. If an error is made, delete the account and begin again.

True
False

A

True

52
Q

Fill in the blank: _________________ are created at the intersection of any two elements in order to hide or make certain input cells read-only.

A

restrictions

53
Q

Linked accounts do not cross all versions and levels.

True
False

A

False