When importing data into the Financials framework, which Plan Element dimension member should be selected to help keep track of the cube’s data sources?
OFS_Integration
OFS_Calculated
OFS_Systems
OFS_Load
When modifying Employee and Job dimensions, what step is required to synchronize Smart Lists in Data Maps?
Execute the Rollup WFP Business Rule
Synchronize Data Maps
Execute the Synchronize Components Business Rule
Execute the Synchronize Defaults Business Rule
What is a navigation flow?
Functionality that enables running multiple business rules in a predetermined sequence
The application home page that users will see upon logging into the application
A type of report that shows variances by geography
A way to promote a plan to your supervisor
What Enterprise Planning and Budgeting Cloud (EPBCS) card in the Application cluster was built to navigate administrators through maintenance activities?
Data Maps
Overview
Settings
Valid Intersections
Configure
Which step is NOT associated with the ‘data load work bench” in Data Management?
Check
Validate
Import
Review
Which is NOT available for assigning customized navigation flows?
Global
Group
User
Role
In order to set up weekly planning for a continuous 18 months, which three options would need to be selected/configured when initially enabling the Financials framework?
Weeks to months mapping
Weekly Planning
Rolling Forecast
Plan Element dimension
Custom Periods
An organization adds a dimension to their Enterprise Planning and Budgeting Cloud (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.
Which two delimiters are supported when creating a metadata import file? (Choose two.)
Percent sign
Forward slash
Tab
Comma
Which two are valid commands in EPM Automate? (Choose two.)
epm automate clear cube
epm automate copy snapshot from instance “Artifact Snapshot” service Admin https://testcloud-pln.pbcs.us1.oraclecloud.com A12343
epm automate download file dataexport.txt
epm automate run business rule Rollup US Sales Period=Q1 Entity=USA
When a cube is enabled for sandboxes, what is the name of the dimension that is automatically added for the feature?
Sandboxes
HSP_Rates
ConsolidatedData
HSP_NoLink
HSP_View
Which three modules would you recommend deploying in ePBCS (Enterprise Planning and Budgeting Cloud)? (Choose three.)
Balance Sheet Planning
Statistical Planning
Capital Expense Planning
Workforce Planning
Project Planning
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
When loading flat file data from external systems into the Enterprise Planning and Budgeting Cloud (EPBCS) business process frameworks, which three are recommended methods? (Choose three.)
Financial Data Quality Management Enterprise Edition (FDMEE)
Data Management
XREF member formulas
Import Data option with framework templates
DATAEXPORT command in Calculation Manager business rules
Which LCM Category is required to restore dimensional security?
Reporting
Groups and Memberships
Calculation Manager
Planning
Where would you navigate in Data Management to map source data to target scenarios?
Category Mapping
Target Application
Import Format
Data Flow Mapping
Which three metadata artifacts can be exported to a flat file? (Choose three.)
Data Entry Forms
Supporting Detail
Exchange Rate Tables
Smart Lists
Dimensions
After enabling the Financials framework, which three are recommended configuration tasks? (Choose three.)
Adding custom expense driver categories
Completing Planning and Forecast Preparation
Setting up exchange rates (for multicurrency applications)
Adding custom dimensions
Removing custom dimensions
Which two dimensions are displayed on the user point of view bar within a Financial Report? (Choose two.)
Dimension tagged as Time
Dimension tagged as Account
Dimensions in a row, column, or page that are flagged for the current point of view
Dimensions are not currently defined in a row, column, or page
Which three functions does the Enterprise Planning and Budgeting Cloud (EPBCS) data load templates allow?
Load data directly into Data Management without the need for mappings
Import business process data into a specific framework cube
Customize the data import process to your application’s unique requirements
Use the EPBCS Import Data feature
Allow for a single Excel template to load data to all frameworks without custom modifications
Which financial framework member within the Plan Element dimension stores the aggregated value of all driver-derived calculations after adjustments have been applied?
OFS_Adjustment
OFS_Trend
OFS_Total
When setting up a data map, which two options are available for handling unmapped dimensions? (Choose two.)
Selecting multiple unmapped dimension members of the source to map to a single unmapped dimension member on the target
Selecting a single unmapped dimension members of the source to map to a single unmapped dimension member on the target
Selecting a single unmapped dimension members of the source to map to multiple unmapped dimension member on the target
Selecting multiple unmapped dimension members of the source to map to multiple unmapped dimension member on the target
Which three Financial framework members within the Plan Element dimension allow for forecast and plan data entry?
OFS_Direct Input
OFS_Input
OFS_Form Entry
OFS_% Increase/(Decrease)
Which business rule is unavailable to manipulate existing employee data?
Remove Existing Employee
Change Job
Plan Departure
Transfer
Which three are Enterprise Planning and Budgeting Cloud (EPBCS) features that can be used to help streamline the amount of time a user spends in a web form? (Choose three.)
Valid intersections
Hide dimension name
Action menus
User variables
Workflow
Which two options related to Planning and Budgeting Cloud (PBCS) security are true? (Choose two.)
Users in the User role can create and edit Business Rules
Users can write to members in a dimension that are calculated
All users can install Smart View
Users can have different access to Data Forms between the SUI and Smart View
The company would like to enable Financials, Workforce, and Project frameworks. They would like to plan and forecast the Project dimension in the Financials framework, as well as track employee utilization in the projects framework. Which two actions must they take to ensure that the Project dimension is shared and the data integrated correctly across all three frameworks?
In the Projects framework, ensure that the Employee driver-based expense is enabled.
In the Workforce framework, rename one of the custom dimensions to “Project” and enable it
In the Financials framework, rename one of the custom dimensions to “Project” and enable it
In the Workforce framework, ensure that the granularity is at Employee or Employee and Job
Which two statements are true regarding the creation and management of business rules within the business process frameworks? (Choose two.)
The business process frameworks cannot use regular business rules – they must be scripted in Groovy
Custom business rules can be created for the business process frameworks
The pre-built framework business rules cannot be modified directly and saved
Custom business rules for the business process frameworks can only be created using the graphical designer
Which three are general methods for directly pushing data between cubes? (Choose three.)
Copy Data
Smart Push
Import Data
To staff resources onto initiatives, which custom dimension is required in the Map/Rename Dimensions section?
Programs
Initiatives
Electives
Projects
Which two components can be installed on the administrator’s computer to support Planning and Budgeting Cloud (PBCS)? (Choose two.)
Strategic Modeling
EPM Automate
The Simplified User Interface
Which three security design principles will help reduce overall security maintenance and troubleshooting, while still balancing security control? (Choose three.)
Creating security groups over assigning individual access permissions to users
Using inherited permissions
Assigning a higher level role than necessary, then scaling back access permissions
Assigning global read access to each cube, then fine tuning none and write access within dimensional security
Configuring single sign-on (SSO)
Which LCM Category is required to restore Essbase data?
To configure ‘Benefits & Taxes”, which dimension should new members be imported into?
Pay Type
Component
Account
Property
When loading Employee data into Workforce Business Process, which month should the data be loaded into?
&OEP_FcstMnth
&OEP_CurMnth
&OEP_StartMnth
&OEP_EndMnth
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.
What client requirement aligns with using a custom BSO plan type alongside the Enterprise Planning and Budgeting Cloud (EPBCS) plan types?
Due to sparse dimensionality, Aggregation times are slow in EPBCS.
The client has 10 dimensions in the EPBCS application and needs to report at each intersection.
The client requires to plan by more dimensions than the framework allows.
The client would like to plan revenue by Product.
The Operations department requires a more granular level of detail than the Sales department.
What are four types of values that can be used in business rule run-time prompts? (Choose four.)
Text
Member of members
Dates
Numbers
Substitution Variables
What step is NOT required to calculate Merit dollars for each Employee within the Workforce framework?
Enter or Load a Merit Override Rate.
Enter or Load a Merit Month by employee.
Enter or Load a Performance Metric by employee.
Ensure there is a Merit Rate for each Performance Metric and component definitions have been updated
Execute the calculate Compensation Business Rule
Which year variable is NOT impacted by the Planning and Forecasting Preparation configuration step?
&OEP_CurYr
&OEP_YearRange
&OEP_YrlyFcstEnd
&OEP_FcstEndYr
If a user is having trouble accessing a specific intersection of data on a form that opens without error, which three actions can an administrator take to help troubleshoot the problem? (Choose three.)
Run a system report on Access Control
Confirm the user’s/group’s dimension access rights
Set Dimension Administration auditing within System Reports
Run Application Diagnostics
Which two options are true when implementing security in Enterprise Planning and Budgeting Cloud (EPBCS)? (Choose two.)
Users are restricted from applications by removing application/module security
EPBCS roles can be assigned to members in all dimensions
The member that is set to read that has a parent with write access to all descendants will result in an access level of read
A user that is assigned read and write access to a member will result in write access
A user is new to creating business rules. Which two business rule features can help new users save time with pre-built components? (Choose two.)
Rule sets
Edit Script mode
Business rule templates
Business rule scripts
Designer mode
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
Which OEP_WFSC dimension is NOT configurable in Enterprise Planning and Budgeting Cloud (EPBCS)?
Job
Union Code
Which two statements are false? (Choose two.)
Business logic is often developed in Rules.
Users connect to Data Management to update their budget and forecast.
Dashboards are not available in PBCS
Approvals allows the business to approve changes and request updates to budget and forecast data.
Which two operations can be performed on the default navigation flow? (Choose two.)
It can be copied.
It can be renamed
It can be deleted.
It can be deactivated.
Which three can be automated with EPM Automate? (Choose three.)
Send an email to users
Run a Business Rule
Import a file into the EPBCS’s inbox
Import user security
Migrate a backup between test and production
A company has enabled the Revenue/Gross Margin, Expense, Income Statement, and Balance Sheet options within the Financials framework and has run through the configuration steps.Which are three recommended post configuration tasks? (Choose three.)
Defining and managing the Accounts and Drives
Modifying account signage for alternate reporting methods
Entering exchange rates
Planning and Forecast preparation
Specifying days in period for driver-based Balance Sheet
Running Financials rules to aggregate and calculate the data
What is the correct sequence of steps for enabling each business process framework?
Enable the framework, refresh the database
Enable the framework, configure the framework, run post configuration tasks
Configure the framework, refresh the database
Run pre configuration tasks, enable the framework, configure the framework
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
What would be the recommended Enterprise Planning and Budgeting Cloud (EPBC) cube architecture for a company wanting to enable the Financials and Capital frameworks, as well as create a Detailed Sales Forecasting cube with complex allocations and calculations, corresponding sales reporting cube, and consolidated reporting cube?
2 BSO cubes (1 required for the frameworks + 1 custom BSO cube), 2 ASO cubes
3 custom BSO cubes, 2 ASO cubes
3 BSO cubes (1 required for the frameworks + 2 custom BSO cubes), 2 ASO cubes
3 BSO cubes (2 required for the frameworks + 1 custom BSO cube), 2 ASO cubes
Which two statements are true about EPM Automate functions? (Choose two.)
Copy snapshot must use an encrypted password file
Downloading a file with only a file name looks to the Inbox folder
Deletepov removes data from a reporting application
Reset service deletes and resets the PBCS instance
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 map data from multiple chart string segments to a single dimension
Which three parameters might be included when executing a REST Request? (Choose three.)
URL
Response Type
Payload
Content Type
Post Type
Which three are traits of the Sandboxes feature?
Sandboxes can be enabled at the application level only
Sandboxes can be enabled for BSO and ASO cubes
Planners can have multiple sandboxes
Planners can immediately see the effect of their changes
When working in a sandbox, planners can add members
Which two Essbase options can be changed in PBCS? (Choose two.)
The default caches
The default CalcTaskDims
Aggregate missing values
Two-Pass Calculation
Which two client requirements align with using an ASO plan type alongside the Enterprise Planning and Budgeting Cloud (EPBCS) plan types? (Choose two.)
The client would like to plan revenue by Product and Services dimensions.
The client would like to report the results of the allocation process by Entity.
The client would like to store 10 years of actual history for reporting purposes but only requires prior year history for planning purposes
Which statement is true when executing an LCM migration?
Importing Dimensions will remove members that do not exist in the LCM Backup
Selected slices of data can be imported into Essbase
Restoring Essbase data from an LCM backup will remove any data that doesn’t exist in the backup
All forms that do not exist in the LCM backup will be deleted
When configuring expenses for driver and trend based calculations, which Action is NOT available for configuration?
Add Predefined Member
Add
Add Item
Add Expense Account
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
Which two items are NOT provided as configurable in Enterprise Planning and Budgeting Cloud (EPBCS)? (Choose two.)
Capital
Public
Financial Close
Financials
Which item lists the available types of mapping in Data Management?
Explicit, Range, In, MultiDim, As
Explicit, Between, In, MultiDim, Like
Explicit, Range, In, Ignore, Like
Explicit, Range, In, MultiDim, Like
When enabling a business process framework, custom dimensions can be added by taking which action?
Renaming a dimension in the Map/Rename Dimensions section during enablement
Creating a new dimension through the Application Overview area
Adding a new dimension by loading it in Data Management
Adding a new dimension to the cube through the Create and Manage Dimensions area
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?
Ad Hoc Forms
Reports
Smart Forms
Cell commentary
Which two operations can be completed in calculation manager? (Choose two.)
View and kill requests
Delete a reporting application
Restructure a planning application
Create planning applications
Which two Jobs in Planning and Budgeting Cloud (PBCS) can be scheduled? (Choose two.)
Executing Data Maps
Executing a Data Management process
Restarting the PBCS instance
Which three accounts leverage the component Dimension for driver and trend based calculations? (Answers not verified, do research on your own)
Cash Flow
Revenue
Expense
Balance Sheet
Which two options can be content within a report? (Choose two.)
Task lists
Data entry forms
Images
Grids
When loading Salaries into Workforce, which Property should the values be loaded to?
OWP_Gross Earnings
OWP_Expense Amount
OWP_Salary Basis
OWP_Value
Which artifact cannot be imported via a flat file?
What are two use cases for converting from Planning and Budgeting Cloud (PBCS) to Enterprise Planning and Budgeting Cloud (EPBCS)? (Choose two.)
The ability to directly integrate with Enterprise Performance Reporting Cloud (EPRCS).
The ability to leverage out of the box frameworks, like Financials and Projects.
The ability to utilize a fully integrated application, with shared metadata and direct data flows between plan types.
The ability to use Data Management.
The ability to directly integrate with on-premise Hyperion Planning.
Which two scenario configuration options are available within the Planning and Forecasting preparation area? (Choose two.)
Configure the Long Range Planning scenario Annually
Configure the Actual scenario for years 1 through 3 Monthly
Configure the Forecast scenario for years 1 through 3 Monthly, and Years 6 thru 10 Annually
Configure the Plan scenario for years 1 through 3 Bi-Weekly
Set the Current Month
A company has enabled the Financials business process and now would like to make changes to the initial configuration. Which three changes can be made after the initial setup of the Financials framework? (Choose three.)
Disabling already enabled features
Enabling Rolling Forecast
Enabling Income Statement
Enabling Expense
Which two are NOT true with a Planning and Budgeting Cloud (PBCS) application? (Choose two.)
Three custom planning applications can be Initialized
Four custom reporting applications can be initialized
Approvals is not included
Groovy calculations are available
A company wants to remove existing level zero data before allocating data back down to those same members. Which two graphical designer objects will help achieve this calculation process? (Choose two.)
Member Block
Clear Data
Allocation
Amount-Unit-Rate
If a user needs to be able to perform application administration, as well as assign user security in Enterprise Planning and Budgeting Cloud (EPBCS), which two global roles would need to be assigned to them? (Choose two.)
Service Administrator
Identity Domain Administrator
Approvals Administrator
System Administrator
Which Substitution Variables are used in the ‘Process Loaded Data’ Business Rule?
&OEP_CurMnth, &OEP_CurYr, &OEP_YearRange
&OEP_FcstMnth, &OEP_FcstYr, &OEP_FcstEndYr
&OEP_PlanMnth, &OEP_PlanYr, &OEP_PlanRange
&OEP_LoadMnth, &OEP_LoadYr, &OEP_LoadRange
When calculating a tiered type of tax, what should be the selected ‘Maximum Value Type’?
Threshold Amount
Percentage of Taxable Earnings
Percentage of Salary
Flat Amount
Percentage of Overall Earnings
A company wants to enable Cash Flow within the Financials framework using a derived method based on Operating, Investing, and Financing activities. Which four options must be enabled to properly configure the Cash Flow Statement this way? (Choose four.)
Cash Flow Statement
Direct Method
Indirect Method
Income Statement
