(2 OM) 9. Foundation Structure

Question 1

A locale is the ___ for a location and any ___, ___, or ___ formatting that is specific to that location.

Answer 1

Language, date, time, number

Question 2

Erase Standard Data erases all standard non-modeled, non-cube data. True or false?

Answer 2

True

Question 3

Labels are for display purposes only on ___ and in ___. You can use any text to describe the time stratum of this date.

Answer 3

Sheets, reports

Question 4

The default time stratum is the time stratum set for all standard ___ and ___ ___.

Answer 4

Accounts, exchange rates. (Standard accounts include GL, metric, assumption and custom accounts).

Question 5

You should re-use import templates to reduce the amount of manual effort that needs to be made. True or false?

Answer 5

False (always download a new template before importing into the model).

Question 6

The default reporting currency cannot be deleted. True or false?

Answer 6

True

Question 7

Default Reporting Rates is the currency assigned to the ___ hierarchical level.

Answer 7

Highest

Question 8

What are use cases for using Custom Currencies?

1. Cryptocurrencies
2. Two or more levels require the same currency but different exchange rates.
3. Creating test currencies to test the impact of different exchange rates.

Answer 8

1. Cryptocurrencies
2. Two or more levels require the same currency but different exchange rates.

Question 9

What are the default exchange rates used in Adaptive Planning?

1. Start of month
2. End of month
3. Average
4. Median

Answer 9

2. End of month
3. Average

Question 10

You can delete exchange rates at any time. True or false?

Answer 10

False (you can only delete them when they are not assigned to an Account.)

Question 11

Each exchange rate must have a unique code no more than 8 characters long and containing only…

1. Letters
2. Numbers
3. Special characters
4. Underscores
5. Punctuation

Answer 11

1. Letters
2. Numbers
3. Underscores

Question 12

What are the different exchange rate methods used in Adaptive Planning?

1. Addition
2. Divisor
3. Multiplier
4. Subtractor

Answer 12

2. Divisor
3. Multiplier

Question 13

When you enable CTA (cumulative translation adjustment), the system creates an account in the ___ account tree. This handles any variances within that tree and the ___ and ___ account trees resulting from the presence of different exchange rate types in those trees.

Answer 13

Equity, Assets, Liabilities

Question 14

When inputting GL account details, there are 3 “Types” of account they can be which are…

1. Non-cumulative
2. Cumulative
3. Standard
4. Link
5. Periodic

Answer 14

2. Cumulative (can be planned by “Delta” or “Balance”).
3. Link
4. Periodic

Question 15

A Link Type account populates the account you’re editing (destination) with the data of the account you choose (source). Link Type accounts cannot be applied for rollup accounts. True or false?

Answer 15

True

Question 16

When inputting GL account details, the “Actuals Overlay” option determines if the account displays actuals data on planning versions prior to the Start of Plan date. True or false?

Answer 16

True

Question 17

In general it is best to use ___ attributes when associating levels to hierarchies. Attributes work especially well with formulas.

Answer 17

Level

Question 18

Use cases for level dimensions include the requirement to…

1. Tag a parent different than the child.
2. Override the value with data entry.
3. Frequent data imports.
4. Use lookup tables from a cube or modeled sheet when entering data directly.

Answer 18

1. Tag a parent different than the child.
2. Override the value with data entry.
3. Use lookup tables from a cube or modeled sheet when entering data directly.

Question 19

Attributes are not supported by the following…

1. Report calculations
2. Dashboards
3. Associations
4. Data export
5. Splits
6. Access Rules

Answer 19

3. Associations
4. Data export
5. Splits

Question 20

When inputting Dimension details, the Dimension Attributes drop-down is only applicable to dimensions enabled as a “list dimension.” True or false?

Answer 20

True

Question 21

A list dimension is the preferred dimension type. A list dimension is a ___ list of dimension values. If you select the “List dimension checkbox” when creating a dimension, you can only apply Dimension Attributes (via the drop-down box) to the dimension.

Answer 21

Flat

Question 22

When inputting Dimension details, the “Use on Levels” checkbox allow the dimension to appear on the ___ page when you can assign values to different Levels.

Answer 22

Levels

Question 23

Which below statements about linked accounts are true?

1. Linked accounts can carry dimensionality and allow for filtering based off it.
2. Linked accounts can differ by version and level.
3. Linked accounts cannot add data from different accounts in different sheets.
4. Linked accounts are less flexible than a formula.
5. Better performance than shared formulas.
6. Can add data from different accounts into different sheets.
7. Erases all previous plan data in the destination account.

Answer 23

1. Linked accounts can carry dimensionality.
2. Linked accounts are less flexible than a formula (shared accounts/formulas are most flexible).
3. Better performance than shared formulas.
4. Can add data from different accounts into different sheets.
5. Erases all previous plan data in the destination account.

Question 24

What are some breakback methods?

1. Breakback evenly
2. Breakback Increase
3. Breakback proportionally
4. Breakback incrementally

Answer 24

1. Breakback evenly
2. Breakback proportionally