7. Importing Data

Question 1

In order to import data into Workday Adaptive Planning, users must have the correct permissions. Permissions related to data importing include…

1. Import Capabilities
2. Export Capabilities
3. Import to All Locations
4. Export to All Locations
5. Erase Data

Answer 1

1. Import Capabilities
2. Export Capabilities
3. Import to All Locations
4. Erase Data

Question 2

The “Import Capabilities” permission enables you to access ___ from the Global Navigation menu and import data to the ___ that you have permission to access.

Answer 2

Integration, Levels

Question 3

The “Import To All Locations” grants permission to map and import data to all ___, ___, and ___. Access rules and level ownership do not restrict this permission.

Answer 3

Levels, accounts, dimensions

Question 4

The “Erase Data” permission enables you to delete data from ___ or non-virtual ___ versions for selected periods, levels, and accounts.

Answer 4

Actuals, plan

Question 5

Standard data import includes:

1. GL account data.
2. Custom account data.
3. Assumptions.
4. Exchange rates.
5. Cube Accounts.
6. Modelled Accounts.

Answer 5

1. GL account data.
2. Custom account data.
3. Assumptions.
4. Exchange rates.

Question 6

You should import all mapping tables in advance of the data import to allow for bulk mapping. If not done, you will be required to map each value one at a time during the data import. True or false?

Answer 6

True

Question 7

You can view the import history for Actual and Plan versions. True or false?

Answer 7

False (Actuals version only, planned version imports are not stored).

Question 8

When importing Actuals using an import template, which fields are mandatory to include (but not necessarily populated)?

1. Account.
2. Level Code.
3. Region Code.
4. Split Label.
5. Time Period.

Answer 8

1. Account.
2. Level Code.
3. Split Label (if you don’t have splits then leave blank, however the column header “Split Label” must be included).
4. Time Period.

Question 9

Data import formats both credit balance accounts (such as revenue) and debit balance accounts (such as expenses) as ___ numbers.

Answer 9

Positive

Question 10

___ balances import only for true contra or offset balances, which roll up to a parent of the opposite sign.

Answer 10

Negative

Question 11

Data can be mapped…

1. Manually
2. Automatically during data import.
3. As a separate step (creating mapping tables) prior to data import.
4. No need to map data.

Answer 11

1. Manually
2. Automatically during data import.
3. As a separate step (creating mapping tables) prior to data import.

Question 12

Data imports in the currency assigned to the level. ___ ___ defined in the model then convert the data to the corporate currency.

Answer 12

Exchange rates

Question 13

Grant the “Privileged Actuals Access” permission to…

1. All Users.
2. Senior Users only such as Finance Managers and CFO.
3. Only to those users who need to view the actuals version.

Answer 13

3. Only to those users who need to view the actuals version.

Question 14

Grant the “Import Capabilities” permission only to those users responsible for importing data.
Additionally, the administrator must determine if these users require the “Import To All Locations” permission. True or False?

Answer 14

True