Oracle Planning Certification Flashcards
Which three are benefits of using EPM Enterprise Cloud Service over EPM Standard Cloud Service? (Choose three.)
A. enable pre-seeded configurable content including dimensions, models, forms, rules, dashboards, infolets, and reports for Strategic Modeling
B. with Free Form Planning, deploy Planning business processes with no dimension requirements and create business processes using Essbase outline files
C. Custom Planning, which allows a high degree of business process customization to support business requirements
D. use of the Groovy scripting language to create or customize business rules
E. deploy more than one supported business process in the same instance
B. with Free Form Planning, deploy Planning business processes with no dimension requirements and create business processes using Essbase outline files
C. Custom Planning, which allows a high degree of business process customization to support business requirements
D. use of the Groovy scripting language to create or customize business rules
What is the difference between Financials and Strategic Modeling? (Choose the best answer.)
A. There is not a technical difference, both do essentially the same thing
B. Ownership Contributions and Consolidations are out of the box in Financials
C. Strategic Modeling is broader in focus and used for long range planning
D. Financials is more summarized than Strategic Modeling
C. Strategic Modeling is broader in focus and used for long range planning
Which two client requirements align with using an ASO plan type alongside the module-based plan types? (Choose two.)
A. The client would like to plan revenue by Product and Services dimensions.
B. The client would like to report the results of the allocation process by Entity.
C. The client would like to store 10 years of actuals history for reporting purposes but only requires prior year history for planning purposes.
D. Due to sparse dimensionality, aggregation times are slow in the application.
E. The client has 10 dimensions in the application and needs to report at each intersection.
D. Due to sparse dimensionality, aggregation times are slow in the application.
E. The client has 10 dimensions in the application and needs to report at each intersection.
What would be the recommended module-based cube architecture for a company wanting to enable Financials and Capital, as well as create a Detailed Sales Forecasting cube with complex allocations and calculations, corresponding sales reporting cube, and consolidated reporting cube? (Choose the best answer.)
A. 3 BSO cubes (1 required for the modules + 2 custom BSO cubes),2 ASO cubes
B. 2 BSO cubes(1 required for the modules + 1 custom BSO cubes), 2 ASO cubes
C. 3 custom BSO cubes, 2 ASO cubes
D. 3 BSO cubes(2 required for the modules + 1 custom BSO cube), 2 ASO cubes
D. 3 BSO cubes(2 required for the modules + 1 custom BSO cube), 2 ASO cubes
For importing data from a BSO plan type to an ASO plan type, which method cannot be utilized? Choose the best answer.
A. Smart Push
B. Data Maps
C. XWRITE business rule
D. Export/Import Capabilities
C. XWRITE business rule
What does a navigation flow allow you to do? Choose the best answer.
A. Promote a plan to your supervisor
B. Display report variances by geography
C. Run multiple business rules in a predetermined sequence
D. Customize the clusters and cards that a user can access
D. Customize the clusters and cards that a user can access
Which two clients or command line tools can you download from Planning? (Choose two.)
A. Data Management
B. EPM Automate
C. Strategic Modeling Smart View add-on
D. Calculation Manager
B. EPM Automate
C. Strategic Modeling Smart View add-on
Which card allows you to enable modules? (Choose the best answer.)
Valid Intersections Data Maps Overview Settings Configure
Configure
What is the correct sequence of steps for enabling each Planning module? Choose the best answer.
Enable the module, refresh the database
Run pre-configuration tasks, enable the module, configure the module
Configure the module, refresh the database
Enable the module, configure the module, run post configuration tasks
Enable the module, configure the module, run post configuration tasks
Which three describe the supported rolling forecast time periods in Financials? (Choose three.)
4, 6, or 8 quarters 4, 12, 36 weeks 1, 2, 4, 5 years 13, 26, or 52 weeks 12, 18, 24, 30, 36, 48, or 60 months
4, 6, or 8 quarters
13, 26, or 52 weeks
12, 18, 24, 30, 36, 48, or 60 months
How do you add custom dimensions when you enable features?
(Choose the best answer.)
By adding a new dimension with Data Management
By adding a new dimension to the cube in Create and Manage Dimensions
By renaming a dimension in Map/Rename Dimensions
By creating a new dimension in Application Overview
By renaming a dimension in Map/Rename Dimensions
In order to set up weekly planning for a continuous 18 months, which three options would need to be selected when initially configuring Financials? (Choose three.)
Rolling Forecast Custom Periods Weeks to months mapping Plan Element dimension Weekly Planning
Rolling Forecast
Weeks to months mapping
Weekly Planning
Which three do you need to enable in order to perform indirect cash flow statement planning? (Choose three.)
Expense Cash Flow Statement Income Statement Balance Sheet Revenue
Cash Flow Statement
Income Statement
Balance Sheet
After enabling Financials, which three are recommended configuration tasks? (Choose three.)
Setting up exchange rates (for multicurrency applications)
Removing custom dimensions
Adding custom expense driver categories
Adding custom dimensions
Completing Planning and Forecast Preparation
Setting up exchange rates (for multicurrency applications)
Adding custom expense driver categories
Completing Planning and Forecast Preparation
A company has enabled and configured Financials. Which are three recommended post configuration tasks? (Choose three.)
Entering exchange rates
Defining and managing the accounts and drivers
Specifying days in period for driver-based Balance Sheet
Running Financials rules to aggregate and calculate the data
Setting Up Planning and Forecast Preparation
Modifying account signage for alternate reporting methods
Specifying days in period for driver-based Balance Sheet
Running Financials rules to aggregate and calculate the data
Modifying account signage for alternate reporting method
A company has enabled Financials and now would like to make changes to the initial configuration. Which three changes can be made?
(Choose three.)
Enabling Expense Enabling Income Statement Disabling already enabled features Adding custom dimensions Enabling Rolling Forecast Removing custom dimensions
Enabling Expense
Enabling Income Statement
Enabling Rolling Forecast
If you choose to create your own chart of accounts in Financials, which four statements are TRUE? (Choose four.)
Predefined drivers and the chart of accounts you brought in can co-exist within the Account dimension member outline.
You enable base or parent features to create an account structure with key members for you to add your own chart of accounts.
You cannot reuse existing integrated financial statements and must design your own financial statements that include the accounts you imported.
You do not need to enable base or parent features, and instead import the metadata directly into the Financials cube.
You can perform calculations using existing rules, and plan using existing forms and dashboards.
You input or import your own accounts for each enabled feature.
Predefined drivers and the chart of accounts you brought in can co-exist within the Account dimension member outline.
You enable base or parent features to create an account structure with key members for you to add your own chart of accounts.
You can perform calculations using existing rules, and plan using existing forms and dashboards.
You input or import your own accounts for each enabled feature.
Which three Financials members within the Plan Element dimension allow for forecast and plan data entry? (Choose three.)
OFS_Trend OFS_Form Entry OFS_% Increase/(Decrease) OFS_Input OFS_Direct Input
OFS_Trend
OFS_% Increase/(Decrease)
OFS_Direct Input
Which three metadata artifacts can be exported to a flat file?
(Choose three.)
A. Exchange Rate Tables B. Dimensions C. Smart Lists D. Linked Reporting Objects E. Data Entry Forms
A. Exchange Rate Tables
B. Dimensions
C. Smart Lists
Which two delimiters are supported when creating a metadata import file? (Choose two.)
A. Percent sign
B. Forward slash
C. Tab
D. Comma
C. Tab
D. Comma
Dimensions can be added by which of the following actions? (Choose 3)
Renaming a dimension in the Map/Rename Dimensions section during enablement of a framework
Creating a new dimension through Application Overview for custom cubes
Adding a new dimension by loading it in Data Management
Adding a new dimension to the cube through Create and Manage Dimensions for custom cubes
Renaming a dimension in the Map/Rename Dimensions section during enablement of a framework
Creating a new dimension through Application Overview for custom cubes
Adding a new dimension to the cube through Create and Manage Dimensions for custom cubes
To assign Workforce resources to initiatives, which default custom dimension is required in the Map/Rename Dimensions section? (Choose the best answer.)
A. Project
B. Program
C. Elective
D. Measure
Project
In order to be able to configure Additional Earnings in the Benefits and Taxes wizard, into which dimension do you have to import members? Choose the best answer.
A. Pay Type
B. Property
C. Component
D. Account
C. Component
When calculating a tiered type of tax, what should be the selected ‘Maximum Value Type’? (Choose the best answer.)
A. Threshold Amount B. Percentage of Overall Earnings C. Percentage of Salary D. Percentage of Taxable Earnings E. Flat Amount
A. Threshold Amount
When loading Salaries into Workforce, which Property should the values be loaded to? (Choose the best answer.)
A. OWP_Gross Earnings
B. OWP_Salary Basis
C. OWP_Value
D. OWP_Expense Amount
B. OWP_Salary Basis
Which three are predefined Workforce business rules? (Choose three.)
A. Transfer B. Plan Departure C. Promote Employee D. Change Job E. Remove Existing Employee
A. Transfer
B. Plan Departure
D. Change Job
When loading Employee data into Workforce Business Process, which month should the data be loaded into?
A. &OEP_FcstMnth
B. &OEP_CurMnth
C. &OEP_StartMnth
D. &OEP_EndMnth
B. &OEP_CurMnth
What step is NOT required to calculate Merit dollars for each Employee within the Workforce framework?
A. Enter or Load a Merit Override Rate.
B. Enter or Load a Merit Month by employee.
C. Enter or Load a Performance Metric by employee.
D. Ensure there is a Merit Rate for each Performance Metric and component definitions have been updated
E. Execute the calculate Compensation Business Rule
A. Enter or Load a Merit Override Rate.
After loading Workforce data from external systems, which two statements describe actions you can take to process Workforce data? (Choose two.)
If an existing employee was omitted from the load file, you can add that existing employee in Workforce. Then assign properties and compensation options for that employee.
To calculate updated compensation data after changing benefit options and rates from the loaded file, first change the benefit options and rates in Workforce and then run the Calculate Compensation business rule.
If an existing employee was not loaded from the load file, you won’t be able to add their compensation information before first adding them to the source system and reloading the file.
Because you cannot override loaded default assignments in Workforce, change the defaults in the load file and reload it.
To override loaded default assignments, change them in Workforce. After saving your changes, updated compensation data is calculated.
To calculate updated compensation data after changing benefit options and rates from the loaded file, first change the benefit options and rates in Workforce and then run the Calculate Compensation business rule.
Because you cannot override loaded default assignments in Workforce, change the defaults in the load file and reload it.
Which two methods can be used to push data between cubes?
(Choose two.)
A. Data Management
B. Import Data
C. Data Maps
D. Copy Data
Data Management
Data Maps
Which three items would be in appropriate use case for “Data Management” in Enterprise Planning and Budgeting Cloud (EPBCS)? (Choose three.)
An organization requires the ability to provide “Drill-back” capabilities.
An organization requires the ability to load data to their application via flat files.
An organization requires the ability to build dimension hierarchies
An organization requires the ability to process data from multiple chart of accounts
An organization requires the ability to build custom calculations
An organization requires the ability to provide “Drill-back” capabilities.
An organization requires the ability to load data to their application via flat files.
An organization requires the ability to process data from multiple chart of accounts
An organization adds a dimension to their ePBCS Planning application. Assuming that Data Management is being utilized, which step would need to be executed?
Navigate to the Import Format screen in Data Management. Select the Import Format for the EPBCS application. Run the “Refresh Members and Metadata” action to update dimensions.
Navigate to the Target Application screen in Data Management, and select the EPBCS application. Run the “Refresh Members and Metadata” action to update dimensions.
Navigate to the Target Application screen in Data Management, and select the EPBCS application. Run the “Refresh Metadata” action to update dimensions.
Navigate to the Application Dimensions screen in Data Management. Refresh dimensions using “Update Application” action.
Navigate to the Target Application screen in Data Management, and select the EPBCS application. Run the “Refresh Metadata” action to update dimensions.
Where would you navigate in Data Management to map source data to target scenarios?
A. Category Mapping
B. Target Application
C. Import Format
D. Data Flow Mapping
A. Category Mapping
In Data Management, what are the steps you need to perform to synchronize the application metadata in the target application?
(Choose the best answer.)
In DM, navigate to Application Dimensions and click Refresh Dimensions
In DM, navigate to Import Format and select your Planning application. Click Refresh Dimensions
In DM, navigate to Target Application and select your Planning application. Click Refresh Members
In DM, navigate to Target Application and select your Planning application. Click Refresh Metadata
In DM, navigate to Target Application and select your Planning application. Click Refresh Members
What three tasks can you perform in the Data Management Workbench? (Choose three.)
A. Export B. Validate C. Maintain Process Tables D. Import E. Delete Integration
A. Export
B. Validate
D. Import
Which step is NOT associated with the ‘data load work bench” in Data Management?
A. Check
B. Validate
C. Import
D. Review
D. Review
When defining data load mappings in Data Management, what are the available types of member mappings? (Choose the best answer.)
A. Explicit, Range, In, Multi Dimension, As
B. Explicit, Range, In, Multi Dimension, Like
C. Explicit, Range, In, Ignore, Like
D. Explicit, Between, In, Multi Dimension, Like
D. Explicit, Between, In, Multi Dimension, Like
What three actions can you perform on the data displayed in the Data Integration Workbench? (Choose three.)
A. Re-register or modify the data source system
B. Open loaded data in Microsoft Excel
C. Apply a filter using Equal and a specific value
D. Apply a filter using Contains and a specific value
E. Drill-through to source from specified data cells
C. Apply a filter using Equal and a specific value
D. Apply a filter using Contains and a specific value
E. Drill-through to source from specified data cells
Which two items are NOT provided as configurable in Enterprise Planning and Budgeting Cloud (EPBCS)? (Choose two.) A. Capital B. Public C. Financial Close D. Financials E. Strategic Modeling
B. Public
C. Financial Close
What is the correct sequence of steps for enabling each business process framework?
A. Enable the framework, refresh the database
B. Enable the framework, configure the framework, run post configuration tasks
C. Configure the framework, refresh the database
D. Run pre configuration tasks, enable the framework, configure the framework
B. Enable the framework, configure the framework, run post configuration tasks
In Financials, you want to see asset related expenses such as depreciation, amortization, and insurance. Which describes the steps you can take to set this up? (Choose the best answer.)
A. Set up the Equipment Expense Reporting Capex data map to map asset related expenses to Financials.
B. On the Configure page for Capital, select the option to map Capital accounts to financial accounts. Then for each Capital account, select a financial account to map to.
C. On the Configure page for Financials, when enabling features, include a custom dimension to store asset related information.
D. On the Configure page for Financials, select Asset Accounts to set up the accounts from Capital that map to Financials.
B. On the Configure page for Capital, select the option to map Capital accounts to financial accounts. Then for each Capital account, select a financial account to map to.
Which statement is true when configuring the Projects option?
If using the Projects option, then the Capital option and the Workforce option must be configured
If using the Projects option, there is no dependency with the Capital option.
If using the Projects option, then the Capital option must also be configured.
If using the Projects option, then the Capital option must also be configured, only if capital projects are enabled.
If using the Projects option, then the Capital option must also be configured, only if capital projects are enabled.
What is the purpose of selecting the Project Benefits option when enabling Projects? (Choose the best answer.)
To track the Workforce expense benefits calculated on each Contract project
To plan detailed project revenue for Contract projects
To help justify the need for projects and plan non-financial benefits
To plan detailed project expenses for projects
To help justify the need for projects and plan non-financial benefits
A company would like to configure Financials, Workforce, and Projects. They would like to plan and forecast the Project dimension in Financials, as well as track employee utilization in Projects. Which two actions must they take to ensure that the Project dimension is shared and the data integrated correctly across all three modules? (Choose two.)
In Workforce, ensure that the granularity is at Employee or Employee and Job
In Financials, rename one of the custom dimensions to “Project” and enable it
In Projects, ensure that the Employee driver-based expense is enabled
In Workforce, rename one of the custom dimensions to “Project” and enable it
In Workforce, ensure that the granularity is at Employee or Employee and Job
In Financials, rename one of the custom dimensions to “Project” and enable it
In Projects, which three types of revenue and expense assumptions drive data calculations? (Choose three.)
Project rates
Standard rates
Discount rates
Program mappings
Plan start year
Working days and hours
Standard rates
Discount rates
Working days and hours
Revenue planned in Projects is rolled up into Financials for contract projects. How must you set up the modules to share the data?
Choose the best answer.
To capture Project revenue, enable Standard Rates from Projects.
When enabling Financials, create a custom Project dimension to map the data to.
In Projects, select an entity and map revenue accounts to Financials accounts for that entity.
Set up the Contract Revenue Reporting data map to map contract-related revenue to Financials.
In Projects, select an entity and map revenue accounts to Financials accounts for that entity.
In Projects, which is NOT a valid option for Contract project revenue recognition? Choose the best answer.
Monthly, Quarterly, or Semiannually
After Completion
When Paid
When Billed
When Paid
You want to move financial information from Projects to Financials for account level data. Which describes the action you can take to accomplish this? (Choose the best answer.)
In data maps, push data for the predefined Financial Statement Integration.
Rollup project data which pushes data to Financials based on account mappings.
On the Financials Integration Summary form, from the Actions menu, select PFP Detail to calculate project data.
In Financials, run the Financials Integration business rule to update data from Projects.
Rollup project data which pushes data to Financials based on account mappings.
What two form validation rules options are supported in Planning?
(Choose two.)
When enabled, execute validations associated with the form for all users regardless of access rights when validating the Approval unit.
When enabled, all validations are run as the administrator and applied to the form members.
When enabled, the user variable for the approval dimension on the form will be replaced by the approval unit member before the validations are run.
When enabled, the system figures out which page combinations have potential data blocks and runs the validations regardless of those page combinations.
When enabled, the form will be validated multiple times by replacing the user variable from the approval unit dimension with every possible value.
When enabled, the user variable for the approval dimension on the form will be replaced by the approval unit member before the validations are run.
When enabled, the form will be validated multiple times by replacing the user variable from the approval unit dimension with every possible value.
Several users continuously use custom-created formulas in Excel to supplement their Planning form inputs. What is another design alternative to reduce offline Excel maintenance? Choose the best answer.
Cell commentary
Reports
Ad hoc forms
Smart forms
Smart push
Smart forms
Which three security design principles can help reduce overall security maintenance and troubleshooting, while still balancing security control? (Choose three.)
Creating groups over assigning individual access permissions to users
Configuring single sign-on (SSO)
Assigning a higher level role than necessary, then scaling back access permissions
Using inherited permissions
Assigning global read access to each cube, then fine-tuning none and write access within dimensional security
Creating groups over assigning individual access permissions to users
Configuring single sign-on (SSO)
Using inherited permissions
Which options are true when implementing access permissions in Planning? (Choose two.)
Users and groups are restricted from accessing applications by removing custom application and plan-type security
A member that is set to read that has a parent with write access to all descendants will result in an access level of read
Planning roles can be assigned to members in all dimensions in all modules in the application
A user that is assigned read and write access to a member will result in write access
Planning roles can be assigned to members in all dimensions in all modules in the application
A user that is assigned read and write access to a member will result in write access
What are four types of values that can be used in business rule run-time prompts? (Choose four.)
String
Substitution Variables
Member or members
Integer
Date as Number
Smart Lists
Answer: BCDF ????
String
Member or members
Integer
Date as Number
Which two statements are true regarding the creation and management of business rules in module based Planning? (Choose two.)
Pre-defined business rules for modules may be modified, but may be ignored after an application upgrade.
Custom business rules for modules can only be created using the graphical designer.
Custom business rules can be created for each module.
Modules cannot use regular business rules. Instead, they must be scripted using Groovy
Pre-defined business rules for modules may be modified, but may be ignored after an application upgrade.
Custom business rules can be created for each module.
Which statement is true when executing a lifecycle management migration? Choose the best answer.
Restoring Essbase data from a snapshot will remove any data that doesn’t exist in the backup.
Importing Dimensions will remove members that do not exist in the snapshot.
Selected slices of data can be imported into Essbase.
All forms that do not exist in the snapshot will be deleted.
Restoring Essbase data from a snapshot will remove any data that doesn’t exist in the backup.
Which migration category is required to restore dimensional security? (Choose the best answer.)
Planning
Groups and Memberships
Reporting
Calculation Manager
Groups and Memberships
Which statement describes infolets? Choose the best answer.
Infolets help you personalize focused data slices that you frequently use for analysis.
Infolets help you quickly analyze data and understand key business questionss by presenting a visual overview of high-level, aggregated information.
Infolets are predefined dashboards that give you insight into overall project financials and expense and revenue metrics.
Infolets help you organize, track, and prioritize your workload.
Infolets help you quickly analyze data and understand key business questionss by presenting a visual overview of high-level, aggregated information.
Which three describe what you can do with Valid Intersections?
(Choose three.)
specify that certain programs are valid only for some periods or departments.
restrict cells containing invalid data, setting them to a read-only state within forms.
filter cell intersections to users when they enter data or select runtime prompts
prevent the user from executing any type of Calculation Manager rule that uses runtime prompts
allow all users to select from a non-filtered list of members on the form’s point of view
specify that certain programs are valid only for some periods or departments.
restrict cells containing invalid data, setting them to a read-only state within forms.
filter cell intersections to users when they enter data or select runtime prompts
Which two are displayed on the user point of view bar within a financial report? Choose two.
Dimensions that are tagged as type Time
Dimensions that are tagged as type Account
Dimensions not defined in a row, column, or page
Dimensions in a row, column, or page that are flagged for the current point of view
Dimensions not defined in a row, column, or page
Dimensions in a row, column, or page that are flagged for the current point of view
Which two tasks can be scheduled as a job in Planning? (Choose two.)
Import or export data
Create snapshots
Promote a Planning Unit
Execute Data Maps
Import or export data
Execute Data Maps
Which three can be automated with EPMAutomate? (Choose three.)
Import user security
Run a Business Rule
Import a file into the Planning inbox
Migrate a backup between test and production
Send an email to users
Run a Business Rule
Import a file into the Planning inbox
Migrate a backup between test and production
In what three ways can Service Administrators implement EPM Automate in Planning? (Choose three.)
To copy data from an aggregate storage database to a block storage database
To copy data from a block storage database to an aggregate storage database
To execute scripts that complete tasks using a scheduler
To import and export metadata, data, artifacts and snapshots
To promote financial plans to the next level in the approval hierarchy
To copy data from a block storage database to an aggregate storage database
To execute scripts that complete tasks using a scheduler
To import and export metadata, data, artifacts and snapshots
Which three statements are TRUE for Sandboxes? (Choose three.)
After you enable sandboxes for a cube, you can later disable that option.
You can enable sandboxes for all Planning cubes and Reporting cubes.
If you enable sandboxes for a cube, Version members have the Enable Sandboxes option.
You can enable sandboxes only in Planning cubes and for custom cubes created in module-based Planning, not for Reporting cubes.
After you enable sandboxes for a cube, you can’t later disable that option.
If you enable sandboxes for a cube, Version members have the Enable Sandboxes option.
You can enable sandboxes only in Planning cubes and for custom cubes created in module-based Planning, not for Reporting cubes.
After you enable sandboxes for a cube, you can’t later disable that option.
If the HSP_VIEW dimension exists in the cube, what feature has been enabled? (Choose the best answer.)
Rolling Forecast
Intercompany Eliminations
Multicurrency
Sandboxes
Sandboxes
Which describes Strategic Modeling? Choose the best answer.
Used to evaluate financial scenarios and perform financial impact analysis.
Used to evaluate how assets and resources related to corporate initiatives are allocated
Used primarily for balance sheet planning
Used to develop plans and forecasts and generate core financial statements
Used to evaluate financial scenarios and perform financial impact analysis.
What is the difference between Financials and Strategic Modeling?
(Choose the best answer.)
There is not a technical difference, both do essentially the same thing
Ownership Contributions and Consolidations are out of the box in Financials
Strategic Modeling is broader in focus and used for long range planning
Financials is more summarized than Strategic Modeling
Strategic Modeling is broader in focus and used for long range planning
Which two clients or command line tools can you download from Planning? (Choose two.)
Data Management
EPM Automate
Strategic Modeling Smart View add-on
Calculation Manager
EPM Automate
Strategic Modeling Smart View add-on
Which two roles can be set for Strategic Modeling? Choose two.
Analyst
Forecaster
Planner
Modeler
Analyst
Modeler
In Strategic Modeling Simulations, what are the three guidelines for selecting the appropriate probability distribution? (Choose three.)
Select the distribution where the conditions of the distribution match those of the input.
Randomly generate a range of values for assumptions and enter best guess estimates one cell at a time.
Evaluate the input in question, and list the conditions surrounding this input.
Review the descriptions of the probability distributions.
Use the Monte Carlo method to best guess your probability distribution options based on a range of assumptions.
Select the distribution where the conditions of the distribution match those of the input.
Evaluate the input in question, and list the conditions surrounding this input.
Review the descriptions of the probability distributions.
In Strategic Modeling Simulations, which probability distribution describes many phenomena such as returns on equity or assets, inflation rates, or currency fluctuations? (Choose the best answer.)
Normal
Lognormal
Triangular
BetaPERT
Uniform
Normal
What three time period management tasks can you perform in Strategic Modeling? (Choose three.)
Combine periods of years, halves, quarters, months, and weeks for historical and forecast data.
Configure time periods to reflect the detail required by financial models, such as different levels of granularity for different years.
Enable the input option for upper level time periods when you add time detail.
Create period-to-date, trailing periods, deal periods, and sub periods to record transactions.
Select and combine periods of years, halves, quarters, months, and weeks for the beginning balance year.
Combine periods of years, halves, quarters, months, and weeks for historical and forecast data.
Configure time periods to reflect the detail required by financial models, such as different levels of granularity for different years.
Create period-to-date, trailing periods, deal periods, and sub periods to record transactions.
Which time period allows you to collect the most recent number of time periods and measure business performance over a specific time duration? (Choose the best answer.)
Deal Period
Sub Period
Trailing period
Base Period
Periods-to-Date
Trailing period
Which two are supported funding methods in Strategic Modeling?
(Choose two.)
Target Capital Structure funding method
Standard funding method
Proposed Projects funding method
Employee-based funding method
Target Capital Structure funding method
Standard funding method
Which three are general methods for directly pushing data between cubes? (Choose three.)
Copy Data
Smart Push
Data Management
Import Data
Data Maps
Smart Push
Data Management
Data Maps
Which three are use cases for data maps? (Choose three.)
To push data from a planning cube to a reporting cube
To allow users to drill back to the data in a different cube
To integrate data between custom plan types and the business frameworks
To create a replicated partition between cubes
To integrate data between the business frameworks
To push data from a planning cube to a reporting cube
To integrate data between custom plan types and the business frameworks
To integrate data between the business frameworks
Whenever you change dimensionality in a target cube, what action on the Data Maps page must you take to ensure that you see metadata changes immediately? (Choose the best answer.)
Select the corresponding data map, and Refresh the Database.
Select the corresponding data map, and execute the Synchronize Defaults Business.
Select the corresponding data map, and Synchronize to refresh the data
Select the corresponding data map, and execute the Synchronize Components Business Rule.
Select the corresponding data map, and Synchronize to refresh the data
When setting up a data map, which two options are available for handling unmapped dimensions? (Choose two.)
Selecting a single unmapped dimension member on the source to map to multiple unmapped dimension members on the target
Selecting multiple unmapped dimension members on the source to map to multiple unmapped dimension members on the target
Selecting multiple unmapped dimension members on the source to map to a single unmapped dimension member on the target
Selecting a single unmapped dimension member on the source to map to a single unmapped dimension member on the target
Selecting multiple unmapped dimension members on the source to map to a single unmapped dimension member on the target
Selecting a single unmapped dimension member on the source to map to a single unmapped dimension member on the target
Which two are benefits of enabling Use Database Suppression in Smart Push? (Choose two.)
It automatically merges comments, attachments, and supporting detail when mapping a cube for reporting.
It helps eliminate the impact on query thresholds and improving wait times.
It allows you to continue using the application while Smart Push runs in the background.
It enables you to apply row suppression at the database level instead of the application level.
It enables you to apply row suppression at the database level instead of the application level.
It helps eliminate the impact on query thresholds and improving wait times.
Which two are use cases for Smart Push? (Choose two.)
Allow the application to determine when it is best to synchronize data
Allow users to update data in another cube on-demand
Allow users to update data in a reporting cube upon saving data in the planning web form
Allow users to schedule when to synchronize data between cubes
Allow users to update data in another cube on-demand
Allow users to update data in a reporting cube upon saving data in the planning web form
Which Smart Push option would allow a user to push data to another cube after manually saving the form?
Use form context
Run after save
Run form rules on autosave
Overwrite selection
Run after save
You want to share detailed benefits data from Workforce with Financials. Which statement describes the steps you must take? Choose the best answer.
Enable and configure Financials, and Workforce. When enabling Workforce, create a custom Benefits dimension to map the data to. Then for the Financial Statement Integration data map, synchronize and push the data.
Enable and configure Financials and Workforce. Then in the Workforce Benefits and Taxes wizard, select a financial account to map the benefit to. For Compensation Data to Financials, synchronize and run the data map.
Enable and configure Financials, and Workforce. When enabling Financials, create a custom Benefits dimension to map the data to. On the Financials Integration Summary form, run Calculate Compensation to update the Workforce data.
Enable and configure Financials, and Workforce. Then to capture Workforce expenses for employees, enable Standard Rates from Workforce. For the Compensation Data for Reporting data map, synchronize then push the data.
Enable and configure Financials and Workforce. Then in the Workforce Benefits and Taxes wizard, select a financial account to map the benefit to. For Compensation Data to Financials, synchronize and run the data map.
You want to move financial information from Projects to Financials for account level data. Which describes the action you can take to accomplish this? (Choose the best answer.)
In data maps, push data for the predefined Financial Statement Integration.
Rollup project data which pushes data to Financials based on account mappings.
On the Financials Integration Summary form, from the Actions menu, select PFP Detail to calculate project data.
In Financials, run the Financials Integration business rule to update data from Projects.
Rollup project data which pushes data to Financials based on account mappings.
Which data map is not used to move data from OEP_WFP to OEP_REP?
Headcount Data for Reporting
Compensation Data for Reporting
FTE Data for Reporting
Non Compensation Data for Reporting
FTE Data for Reporting
