Planning 3 Flashcards
1
Q
- Mass update forms in workforce:
A
- Quickly update and process data on multiple existing employees or jobs and then process the updated data in WK
- Review and edit info after data is loaded
- Each form is associated with a Groovy rule that processes only changed data
- You can change existing properties or add a new record then 1. apply configured default assign or override default assign and rates
- After modify salary, you can re-apply configured default assign for B&T, Add. Earnings
- Override default assignments and then apply the configured defaults
2
Q
- About IPM - Intelligent Performance Management
A
- Integrated directly in Planning applications ( predictive capabilities, insight discovery, fin pattern recognition)
- Auto-predict improves accuracy of forecast using automated predictive capabilities
- IPM Insights reduces time spent in analysis thanks to financial pattern recognition, offering insights to planners
- ML Machine Learning Model Import, power of data science with what-if analysis on a trained ML model that has been imported into Planning application
3
Q
- True about approval units
A
- Approval units are the basic units for preparing, annotating, reviewing and approving plan data
- Using approvals you submit plan data for a particular scenario, version and entity
- Process :
1. Set the approval units
2. Designates who reviews/approves the plan data as data moves thru organization( promotion path)
3. Begin planning cycle by officially starting each approval units- Its state then changes to under review
4
Q
- True about Optimize Dimension Order
A
- Before optimizing dimension order, refresh database then backup application and download snapshot
- Perform this task in test environment before production
- Available only for Financials and Projects and only for provided BSO cubes created when you first enable and configure
- This new order is maintained even If you enable additional feature/modules/applicatio
5
Q
- Which three statements are true about migration snapshots ?
A
- Oracle backs-up application & data to create a snapshot while performing daily maintenance
- Service administrators cand create full-backup snapshots of environment or incremental backup snapshot of artifacts at any time
- Generally, snapshots are compatible with previous/next updates
- Files/snapshots created or uploaded deleted after 60days
- Daily maintenance monitors the environment and automatically removes 60-days old snapshots
- If total size of snapshots > 150 GB - deletes snapshots from last 60-d (oldest) until <150GB
- Daily maintenance snapshot always retained irrespective of size.
- ``If maintainece snapshot > 150 GB - all other snapshots are deleted
6
Q
- True statements about importing metadata from a flat file
A
~~~
1. You can load multiple dimension at the same time/separate
2. Create an import file for each artifact you want to import
3. Import file must contain
1. Header record
2. Below a list of metadata records
3. Delimited list of properties value that matches the order designated in the header
4. File format .csv or .txt
5. If import file valid, load -> select location local/inbox ( server)
6. If import with jobs then upload file to the inbox/outbox explorer
7
Q
- In Strategic Modelling, which three are benefits of Simulations?
A
- Perform automated what-if analysis on Strategic Modeling models
- Assign a range of possible value that are uncertain, and analyze how uncertainty affects related accounts
- Quickly calculate/review hundreds of possible outcomes and likelihood of occurrence
- Analyze best and worst case scenarios
- Assess likelihood of meeting target goals
- See how key uncertain inputs affect your bottom line
- Simulations results will show range of forecast sales and their likelihood
8
Q
- Freeform four statements to describe it?
A
- You can create applications with multiple cubes/single cube then add later up to 12 total
- The single cube can be created from existing Essbase outline (OTL) file or Essbase Migration package
- Of the 12 cubes allowed, only first cube from OTL/Essbase Migration
- Each multi-cube FreeForm application generates its own outline on Essbase. Dimensionality is shared but not outline
- The cubes be can be any ASO/BSO combo.
9
Q
- True statements about Machine Learning (ML)?
A
- Data scientist gather and prepare historical data related to a business problem, train the algorithm and generate a PMML file
- EPM administrator cand then import and configure the fully trained ML model, which generates two Groovy rules.
10
Q
- You can load data into planning using these Data Load Options
A
- Planning Interface
- RESTAPIs
- EPM Automate
- Migrations
- Data Integration and Management (complex data mappings)