Introduction to Modeling Flashcards
Where should all formulas be created?
At the intersection of a level and account.
In a level tag, such as a dimension or attribute
At the highest rollup
At the intersection of a level and account.
Fill in the blank: Actuals and Plan data should always be at the __________ level.
same
Creating and using a consistent level structure year over year impacts which of the following? Check all that apply.
Maintenance
Security
Reporting
Maintenance
Security
Reporting
Which of the following should be completed before loading a level structure? Check all that apply.
Enable the required currencies
Create and load in any level dimensions and/or level attributes for reporting
Select the parent currency for the Total Company or Top Level, if not USD
Enable the required currencies
Create and load in any level dimensions and/or level attributes for reporting
Select the parent currency for the Total Company or Top Level, if not USD
Which of the following is a true statement?
Reloading the entire structure will only erase the data for the current level in the current version
Reloading the entire structure will only erase the data for all levels in the current version
Reloading the entire structure will erase the data for all levels in all versions
Reloading the entire structure will erase the data for all levels in all versions
The top level should be tagged with the correct corporate currency before any child level is created.
True
False
True
Which of the following are best practices for managing currencies. Check all that apply.
Only input the exchange rates for the direction in which you need currency translations
When importing data, verify that it will be loaded at the local level currency
Enable user defined currencies for entities with the same currency but different exchange rates
Only input the exchange rates for the direction in which you need currency translations
When importing data, verify that it will be loaded at the local level currency
Enable user defined currencies for entities with the same currency but different exchange rates
Which of the following methods can be used to set up exchange rates?
Import the applicable rates
Manually enter the applicable rates
Copy and paste from Excel
All of the above
All of the above
Accounts are the driving force of the model.
True
False
True
Which accounts can be classified as debit or credit accounts?
Modeled accounts
General Ledger accounts
Metric accounts
Custom accounts
General Ledger accounts
When working with root accounts, which of the following can a user change? Choose all that apply.
Account name
Account type
Account code
Balance type
Account name
Account code
Which of the following are best practices for accounts? Check all that apply.
Use custom accounts for formula writing
Use multiple charts of accounts to provide more detailed reporting
Use rollup accounts for formula writing
Use master formulas for Net Income and YTD Earnings (Loss) root accounts
Always import data to Net Income or Year to Date Income (loss) accounts
Use naming conventions of Account Number and Name for Account Name field, e.g., 7010 Accounting Fees
Make the Account Code same as Account Code from the data source system
Use rollup accounts with child accounts; do not import a flat hierarchy
Use custom accounts for summarized reporting
Use rollup accounts for formula writing
Use master formulas for Net Income and YTD Earnings (Loss) root accounts
Use naming conventions of Account Number and Name for Account Name field, e.g., 7010 Accounting Fees
Make the Account Code same as Account Code from the data source system
Use rollup accounts with child accounts; do not import a flat hierarchy
Which of the following statements are correct? Check all that apply.
Hierarchical dimensions can have dimension attributes
Attributes have a 1:1 relationship
Dimensions and attributes can be flat or hierarchical
Level dimensions cannot have dimension attributes
Attributes have a 1:1 relationship
Dimensions and attributes can be flat or hierarchical
Level dimensions cannot have dimension attributes
A dimension must have a flat hierarchy to enable dimension attributes.
True
False
True
Which of the following is a correct statement?
Data can be input into attributes
Data can be input into dimensions
Data can be input into either dimensions or attributes
Data can be input into dimensions
Dimensions and attributes cannot be used in formulas.
True
False
False
When loading data to a dimension, it is best practice to load data to:
A dimension attribute
The dimension value
The parent dimension
The dimension value
What should be done before setting up the calendar and importing data? Check all that apply.
Identify the default time stratum needed for the general ledger accounts
Determine the fiscal year
Understand the customer’s reporting requirements, e.g, day, week, month
Identify the default time stratum needed for the general ledger accounts
Determine the fiscal year
Understand the customer’s reporting requirements, e.g, day, week, month
Who is responsible for setting up the fiscal year in Adaptive?
The implementer
Adaptive Provisioning team
The Account Manager
The implementer
The default time stratum determines the exchange rate time stratum.
True
False
True
Which option should be used to add new years to the calendar?
Update
Append
Reload entire structure
Append
A user can reference data across formulas in different versions?
True
False
False
Which of the following are types of versions? Check all that apply.
Actuals Plan Historical Reporting only Virtual
Actuals
Plan
Virtual
Which data crosses versions?
Plan
Actuals
Virtual
Reporting
Actuals
Which version is read only?
Actuals
Plan
Virtual
Virtual
Is it a best practice to enable the locked version option and the audit trail option?
Yes
No
Yes
When setting the left scroll limit, how many years is typically sufficient for formula writing?
1
2
3
4
2
Which of the following are true statements regarding Roles and Permissions? Check all that apply.
Permissions indicate whether a user can input, edit or view data
Permissions are globally set for each user
Settings affect all levels in a model
Permissions indicate whether a user can input, edit or view data
Permissions are globally set for each user
Settings affect all levels in a model
Which of the following are unique to a super user role? Check all that apply.
Create custom reports
Create roles and users
View salary detail
Bypass any security control
Create roles and users
Bypass any security control
Which of the following are best practices? Check all that apply.
Login as a new user to confirm the access and permissions
Enable the User Activity Log
Require users to change their password on first login
Login as a new user to confirm the access and permissions
Enable the User Activity Log
Require users to change their password on first login
Adding rollups to the sheet automatically adds any future children to the sheet’s design.
True
False
True
In View by level mode, which of the following is displayed?
Levels down the rows of the sheet, time as a drop-down selection, and accounts in the columns
Levels down the rows of the sheet, accounts as a drop-down selection, and time in the columns
Accounts down the rows of the sheet, levels as a drop-down selection, and time in the columns
Accounts down the rows of the sheet, time as a drop-down selection, and levels in the columns
Levels down the rows of the sheet, accounts as a drop-down selection, and time in the columns
Splits can be added to cube and standard sheets.
True
False
False
A report must contain at least one account or account attribute and an element on both the row and column axes before it can be saved.
True
False
True
When not specifically assigned in the report’s design, the version defaults to the Current Version; whatever was selected last in sheets.
True
False
True
Saving or clicking Modify Report from the viewer does not update the report’s design to the displayed expanded or Drill into… presentation.
True
False
False
Import templates are sheet specific.
True
False
True
Are dimensions required to be in the import template?
Yes
No
No
The user must populate data for all columns when loading data to a which type of sheet?
Standard
Modeled
Cube
Cube
What is required to tell the system where to put the data when it comes into Adaptive?
Unique name for all fields
A mapping table
A data source selector
A mapping table
Existing data is automatically erased when a user manually imports data?
True
False
False
