Enero 2024

Which Planning application type is supported In EPM Standard Cloud Service?. Custom. Sample. FreeForm. Modules.

Which three Planning application types can you select when creating an application with EPM Enterprise Cloud?. Hybrid. FreeForm. Modules. Plan. Custom.

In which four ways can you create a FreeForm application?. Using a single cube, and then adding more cubes later. Importing a single Essbase outline, and then adding more cubes later. With multiple cubes by using the Application Creation Wizard or Excel template in Smart View. With a maximum of 12 cubes. Migrating an Essbase snapshot with Custom Defined Functions. Importing multiple Essbase outlines - one for each cube.

Which three statements are true about dimensions and members in FreeForm applications?. Set up the core required dimensions for account (measures) and time before adding custom dimensions. Native account, period, and entity dimensions can be inherited by the cubes. You can include up to 30 total dimensions. Cubes can have stand-alone dimensionality. Dimensions can be shared between cubes.

Which configuration task Is NOT mandatory in Workforce?. Benefits and Taxes. Planning and Forecast Preparation. Workforce Assumptions. Employee Type.

What two levels of workforce detail granularity would you need to perform Merit-Based Planning?. Employee and Job. Job. Employee. Merit.

Which two statements are true about Importing group assignments of users?. After importing group assignments of users from a CSV file, EPM Cloud enforces appropriate application-level and artifact-level security assignments based on the new group assignments. After importing group assignments of users from a CSV file, you must refresh the database to enforce artifact-level security assignments based on the new group assignments. Service Administrators can remove group assignments of users by importing a CSV file into Access Control groups. Service Administrators can import group assignments of users from a CSV file to create new assignments in existing Access Control groups.

Which two statements are true regarding what you can do when configuring Insights?. Define insights for up to 1000 data intersections. Use prediction results as input for generating insights. Create and edit data views to customize the display on the dashboard. Select either a single type of insight or multiple types of insights.

Which two tasks can you perform when creating strategic models?. Build the calendar structure for a model. Select a file from which to import account groups. Choose which reports to include. Create a model from a template.

In which three ways can you create a model in Strategic Modeling?. From a template. From a scenario. From an existing model. From a combination of scenarios. From a local file.

Which two permissions are assigned when a model is first created in Strategic Modeling?. Viewer permissions. Power User permissions. Default permissions. Owner permissions.

In which two ways do parent/child relationships between approval unit hierarchy members affect the review process?. When the status of all children changes to one status (for example, Signed Off) the parent status changes to the same status. After all children are promoted to the same owner, the parent status is changed to Signed Off. When you approve a parent, its children are Stoned Off. After all children are promoted to the same owner, the parent is promoted to the owner.

Which statement describes Strategic Modeling?. It is used to strategically manage and analyze finances at any business level with built-in dashboards. It is used to quickly model and evaluate financial scenarios, and offers out-of-the-box treasury capabilities. It is Used to model the flow of data by defining strategic rules for sharing data between modules. It is used to develop driver-based strategic plans and generate core financial statements.

From which two locations can you Import data files?. Repository. Local. Inbox/Outbox Explorer. Workspace.

A Department Manager requires access to all accounts in their own department, but only a certain account in all other departments. With the usual metadata security, the Manager would have access to all accounts across all departments. Which feature does the Service Administrator use to control the intersection of all accounts with the Manager's department, and only the specific account in all other departments?. Access control. Member security. Artifact security. Cell-level security.

Which module should you enable first to track the utilization of employees in Projects?. Projects module before Workforce module. Projects module before Financials module. Financials module before Projects module. Workforce module before Projects module.

Which three are used by Application Monitor to evaluate, identify, and resolve design flaws before an application is placed in production?. I Individually-selected artifacts. Error log files. Migration snapshots. The entire application. Types of artifacts, such as forms and approval units.

Which two statements describe tasks that need to be completed so that planners can use a Machine Learning (ML) model in Planning?. Administrators build a navigation flow to set up the ML model definition, and then set up a data map to map historical data to future data and push the actual data to the cube. Administrators create an action menu to run the Groovy rule generated from the ML model definition, and then assign the action menu to a form. Administrators import the ML model into a Planning application and define how the input variables and the target variable map to dimension members or cell values in the Planning application. Administrators build a task list to set up the ML model definition, and then run the Groovy rule to generate future data.

Which task must be completed before EPM administrators Import a Machine Learning model into Planning?. EPM administrators create a data model and push data to it to generate a PMML file. EPM administrators create data maps and Groovy rules to move and process data. Data scientists create Groovy rules designed to evaluate historical data and identify patterns. Data scientists build and train the ML model in a data science tool and save it as a PMML file.

When designing forms, which Smart Push option do you select to automatically move data when the form data Is saved?. Run After Save. Enable Autosave. Sync Data After Save. Push Data After Save.

Which three should be considered when designing data entry forms?. Use User Variables for dimensions to help reduce the dimension selection for end users. Put dense dimensions in the row or column of a form. Determine the right number of accounts in a single form and the number of forms required to support your process. Select specific members rather than using functional relationships. Include all or as many accounts in a single form.

Which REST API method Is used to execute a job In Planning?. POST. GET. EXECUTE. PUT.

Which Planning feature enables you to customize the clusters and cards that a user can access?. Navigation flows. Infolets. Manage approvals. Task Manager.

Which two statements are true about approval units?. Approval units are combinations of scenario, version, and entity or part of an entity. You can have up to three scenario/version combinations per approval unit. Approval units can also include secondary dimensions within any entity. You can set the option in Application Settings to include detailed annotations for approval units.

Which card In the Application cluster allows you to enable modules?. Tools. Configure. Enable Features. Cube Editor. Settings.

A company has enabled Financials and would now like to make changes to the Initial configuration. Which three changes can be made?. Renaming custom dimensions. Enabling rolling forecast. Changing the selected cash flow method. Adding custom dimensions. Enabling Income Statement. Enabling Expense.

How do you add custom dimensions when you enable features?. By adding a new dimension to the cube in Create and Manage Dimensions. By adding a new dimension with Data Management. By creating a new dimension in Application Overview. By renaming a dimension in Map/Rename Dimensions.

Which two components are Included in Salary Grade assumptions?. Salary Rate. Salary Basis. Merit Rate. Partial Payment Factor.

Which three statements are true about migration snapshots?. Oracle backs up your application and data to create a snapshot while performing daily maintenance of your environment. If the daily maintenance snapshot size exceeds 150 GB, it marks it for review and notifies the service administrator. Generally, a snapshot is compatible with the previous and next updates of an environment. Snapshots must always run through an upgrade process if taken from a previous version of the environment. Files and snapshots that you create or upload to an environment are deleted after 60 days.

Which three form validation rules options are supported In Planning?. Validate for all page combinations and all existing or potential blocks. Validate only for pages with existing blocks. Validate rules as Service Administrator, regardless of logged-in user, when the form is loaded or saved. Validate only for users with access to this form. Validate only for cells and pages to which a user has access.

Which two features can help create business rules for users that are new to business rules?. Add calculations in calculations script syntax by switching to Script Mode. Rules are represented graphically in a flow chart into which you can drag and drop components to design the rule. Design sophisticated rules that solve use cases that normal business rules cannot solve by using Groovy business rules. Add calculations by using preformed system templates, such as clearing data, copying data, aggregating data, and so on.

Which Planning feature or component enables you to create, validate, deploy, and launch business rules?. Calculation Manager. Member Formulas. Validation Rules Editor. Data Integration.

Which two are primary use cases for an ASO reporting cube?. You want to create and execute complex Calculation Manager business rules. You want to report on Smart Lists. You want to save data for upper-level members. You want to report on new Planning data originating from any source, such as a data warehouse.

Which three tasks can you perform on the Dimensions page to manage dimensions in a Custom Planning application?. Delete dimensions. Clear dimension members. Set the order of precedence. Set the Evaluation Order. Select the dimension density.

Which three principles of assigning permissions to artifacts, rules, and folders are valid?. Users and Power Users can design artifacts. Users and Power Users can work only with members to which they have permissions. Users and Power Users can see and launch only rules to which they are assigned Launch permission. Users and Power Users have Write permissions to all dimension members and to all artifacts. Users who are assigned permissions to a folder can access the items in that folder, unless they are assigned more specific permissions.

Which is true about Implementing access permissions In Planning?. A member with Read access that has a parent with Write access to all its descendants results in an access level of Read for that member. If a user with group access has individual access permissions that conflict with those of a group to which the user belongs, then group access permissions take precedence. Planning roles can be assigned to members in all dimensions in all modules in the application. Users and groups are restricted from accessing applications by removing custom application and plan-type security.

Which three statements are true about importing metadata from a flat file into Planning?. Your import file must contain a list of metadata records. Each metadata record contains a delimited list of property values that matches the order designated in the header record. You can use the import file functionality to import more metadata or to perform incremental updates from the source system. When selecting to Clear members during import, any member not specified is deleted from the outline after importing the dimension unless it is an ancestor of a member that was specified, or is a base member of a shared member that was specified. You can rename or delete members of attribute dimensions during a metadata import. You can import data forms, dashboards, and infolets by loading a local import file or an import file from the Inbox server.

Which three are benefits of using Groovy rules?. You can use Groovy rules to perform complex procedural calculations in memory before submitting the results to the database. You can use Groovy rules to define member formulas that combine operators, calculation functions, and numeric constants to perform calculations on members in Dimension Editor. You can use Groovy rules to dynamically generate calculation scripts at run time based on contexts defined in the Groovy script. You can use Groovy rules to add validation checks for runtime prompt values before running calculations, add data validation checks before submitting data, and add error handling. You can use Groovy rules to dynamically calculate data and add validation checks before saving data on custom composite forms.

Which two are true regarding rent-free periods with IFRS 16 enabled?. Lease payments are set to zero. Calculations are based on a date range. Calculations are based on periods and payment frequency. Lease payments are set to the index rate.

Which step does NOT need to be completed to manage the configuration of Key Performance Indicators (KPIs) in Planning Financials?. Adding KPIs to the hierarchy. Reviewing KPIs in the hierarchy. Verifying enabled KPIs. Adding KPIs to the alternate hierarchy. Adding KPIs in Configure: Financials.

In Financials, you can leverage out-of-the-box calculations to aggregate and prepare actual, plan, and forecast data. Which calculation rule would you run to update reports or analyze data at various levels of the business hierarchy?. Prepare Plans. Calculate Actuals. Prepare Forecast. Rollup.

Which two are use cases for Smart Push?. Allow users to run Smart Push in forms to move data from source aggregate storage cubes. Allow the application to schedule when to synchronize data. Allow users to update data in a reporting cube after saving data in forms. Allow users to update data in another cube on demand.

Which three are use cases for data maps?. To push data from a planning cube to a reporting cube. To create a replicated partition between cubes. To integrate data between Planning modules. To integrate data between custom plant es and Planning modules. To allow users to drill back to the data in a different cube.

Which two tasks can you perform with approvals?. Ensure that the plan data meets data validation rules. View reviewers' remarks through annotations. Continue to change plan data even after promoting the approval unit, as long as you were the original owner. Override validation rules to promote approval units.

Which dimension must members be Imported Into to configure Additional Earnings in the Benefits and Taxes wizard?. Pay Type. Component. Property. Account.

Which Mass Update form In Workforce allows you to update employee properties, job properties, or salary-related Information?. Process Updated Data. Synchronize Defaults. Synchronize Definitions. Process Data and Synchronize Defaults.

Apart from the artifact snapshot, which three Items can you Include when cloning environments?. Performance substitution variables. Stored snapshots and contents of the inbox and outbox. Smart View connection details. Data Management records. Application audit.

In which three ways can you create data maps that copy data using Smart Push?. Between two Planning instances. From Planning to Financial Consolidation and Close. From Tax Reporting Cloud to Planning. From Financial Consolidation and Close to Planning. From Planning to Tax Reporting Cloud.

Which three statements describe Intelligent Performance Management (IPM) offerings?. Quickly start your planning process and improve the accuracy of your forecasts with powerful and automated predictive capabilities. Harness the power of data science by performing what-if analysis on a trained ML model that has been imported into a Planning application. Assess the impact organizational projects and initiatives have on overall corporate resources, and ensure they align with short and long-term financial targets. View and interact with high-level, essential information generated from different sources to help you quickly assess where to direct your attention. Reduce time spent in data analysis with financial pattern recognition on which you can evaluate and take action.

Which type of Insight helps to show a pattern that overstates or understates the forecast?. Prediction. Forecast Anomaly. Variance Analysis. Forecast Variance and Bias.

With Machine Learning, which type of prediction would you define to predict revenue using several input variables such as price, promotions, industry market size, and climate?. Source Prediction. Dimension Prediction. Multivariate Prediction. Forecast Prediction.

With Machine Learning, which type of prediction would you define to predict product volume based on historical time series data using the same dimension, measure, and slice of data?. Forecast Prediction. Univariate Prediction. Dimension Prediction. Source Prediction.

Given these two use cases: ·         Create a starting point for subsequent versions and replicate your First Pass version to a Second Pass version, and make your changes to it. ·         Save your baseline version data for your records and future analysis. Which Planning Service Administrator-only feature or component can you use to perform tasks for these use cases?. Copy Versions. Version Management. Version Mapping. Task Manager.

In Strategic Modeling, which three benefits of Simulations help Improve forecast accuracy?. They allow you to assess the likelihood of meeting target goals. They allow you to calculate the model a maximum of three times by using random scenarios created from input assumptions. They allow you to see how key uncertain inputs affect your bottom line. They limit you to performing a simple and error-prone what-if analysis by entering best guess estimates one cell at a time for uncertain input accounts. They allow you to assign a range of possible values to uncertain inputs and analyze how that uncertainty affects related accounts.

What can help you optimize your decision-making by performing automated what-lf analysis In Strategic in Modeling?. Model Change Management. Consolidations. Simulations. EPM Automate.

Which three are required when enabling Flexible Account Mapping in Workforce?. For Mapping Level, specify whether the mapping should be done at the Global level (the same mapping for every entity) or at the Entity level. Specify whether Mapping Drivers should be based on Grade or on Defaults for the application. Map Salary and Merit from Workforce to the same account in Financials and Projects. Enable Financials and the Financials Expense planning option to enable this feature. Enable Flexible Account Mapping only when you bring your own chart of accounts in Financials.

Which statement Is true about configuring Projects with Capital?. Strategic Modeling must first be enabled. If capital projects are enabled, Capital must also be configured. Workforce must also be configured. All modules must be enabled.

How many days until all files and snapshots that you create or upload to an environment are deleted?. 30 days. 60 days. 1 day. 90 days.

Which 2 statements are true when administrators assign permissions to artifacts?. Users and Power Users can work only with members to which they have permission. Only Power Users can design forms, dashboards, and infolets. If you have inherited read permissions and assigned write permissions, the inherited permissions take precedence. Power Users are automatically granted Write permissions to all dimension members to all forms, dashboards, and infolets. Users and Power Users can view or enter data only into forms to which they have permissions.

Which four job types can be scheduled in Planning?. Create Snapshot. Import Data and Export Data. Refresh Database. Merge Data Slices. Promote Planning Unit. Data Map.

When copying data between two Planning instances, what 3 tasks must you complete?. Associate the data map with a form. Define an EPM Connection to the source instance. Define a data map with Remote Cube as the target. Enable cross-POD mapping on the Smart Push card. Define an EPM Connection to the target instance.

Which are 3 benefits of using EPM Enterprise Cloud Service over EPM Standard Cloud?. Deploy more than one supported business process in the same instance. With Free Form Planning, you can create applications with no dimensional requirements or an Essbase outline file. Enable preseeded configurable content including dimensions, models, forms, rules, dashboards, infolets, and reports for Strategic Modeling. Custom Planning allows a high degree of business process customization to support business requirements. Use the Groovy scripting language to create or customize business rules.

Which 4 statements are true for the Optimize Dimension Feature?. Optimizing dimension order is available only for Financials and Workforce, and only for the provided BSO cubes that are created when you enable and configure. The new optimized dimension order is maintained even if you enable additional features or other modules. Optimizing dimension order is available only for BSO cubes in Custom Planning applications. Optimize dimension order in your test environment before performing it in the production environment. Before you optimize dimension order, refresh the database and then back up the application and download the snapshot. Optimizing dimension order is available only for Financials and Projects, and only for the provided BSO cubes that are created when you enable and configure.

If you are using your own chart of accounts and want to use dashboards that graphically depict total results, you must add your accounts under the appropriate parent. Which 4 parent members do you add your own chart of accounts to as shared members if you want to include them in predefined dashboards?. OFS_Financial Integrations. OFS_Total Operating Expenses. OFS_Cash. OFS_Rollup Data. OFS_Total Revenue. OFS_Total Cost of Sales.

Which 3 methods can be used to import data from BSO cube to an ASO cube?. XWRITE business rule. Data Maps. Valid Intersections. Planning Import and Export. Data Integration.

When designing with the new Reports for EPM Cloud, which statement is true about what dimensions are displayed on the Global Point of View within a report?. Dimensions selected by a report viewer for the Global Point of View, are saved for all viewers. Only one dimension is in the Global Point of View. Dimensions not defined in a row, column, or page are displayed in the Global Point of View. All dimensions are displayed in the Global Point of View.

In Data Management, what are the steps you need to perform to synchronize the application metadata in the target application?. In Data Management, navigate to Target Application and select your Planning application. Click Refresh Metadata. In Data Management, navigate to Target Application and select your Planning application. Click Refresh Members. In Data Management, navigate to Application Dimensions and click Refresh Dimensions. In Data Management, navigate to Import Format and select your Planning application. Click Refresh Dimensions.

What are 2 ways you can affect the promotional path of an approval unit hierarchy?. Use data validation rules to determine whether a change in the approval unit promotional path is necessary. Modify owners and reviewers for approval units and their descendants. Create a task list with a task to skip a user in the promotional path. Use the Approvals Audit feature to view data tasks performed by users and freeze that task for the user.

In Financial Reporting Web Studio, what are 4 reusable objects or templates can you use when designing multiple dynamic reports?. Data queries. Text and images. Charts. Hidden sheets. Row and column templates. Grids.

For “Modules” and “Custom” application types, which statement is true about the Currency Dimension?. The Currency dimension contains a single member called “Local” and other members representing reporting currencies. The Currency dimension contains a section for input currencies and a section for reporting currencies. The Currency dimension is not provided with any content, and is set-up as a custom dimension. The Currency dimension contains a list of currencies and exchange rate types.

A company wants to capitalize the expenses from their project initiatives. Which is NOT a capability within Projects or Capital to fulfill the business requirements?. Within Capital, the ability to view capitalized asset values and associated depreciation. Within Projects, the ability to calculate depreciation on capital assets. Within Capital, the ability to change resource utilization by project and asset. Within Projects, the ability to allocate project expenses either partially or in full to one or more assets.

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 2 actions must they take to ensure that the Project dimension is shared and the data integrated correctly across all three modules?. In Financials, rename one of the custom dimensions to “Project” and enable it. 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 Projects, ensure that the Employee driver-based expense is enabled.

A Department Manager requires access to all accounts in their own department, but only a certain amount in all other departments. With the usual metadata security, the Service Administrator would have access to all accounts across all departments. By enabling this type of security, the Service Administrator can control the intersection of all accounts with the Manager's department and only the specific account in the other departments. Which security feature can Service Administrators set to enforce this?. Cell-level Security. Grid-level Security. Account-level Security. Evaluation Order.

What does a navigation flow allow you to do?. Track begets and review status, process issues, and approval unit ownership using approval units. Set the flow of business rules in a predetermined sequence. Customize the clusters and cards that a user can access. Guide users through the planning process by listing tasks, instructions, and end dates.

You want to share detailed benefits data from Workforce with Financials. Which statement describes the steps you must take?. Enable and configure Financial and Workforce. When enabling Workforce, create a custom Benefits dimensions 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, select a financial account to map the benefit to. For Compensation Data 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 in a Gracian 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.

Which migration category is required to restore dimensional security?. Reporting. Calculation Manager. Groups and Memberships. Core.

Which 2 statements are true regarding the creation and management of business rules in module-based Planning?. Pre-defined business rules for modules may be modified, but may be ignited 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.

Which 2 statements correctly describe security assignments for Planning?. All user, group, and artifact permissions are assigned through Oracle Cloud Identity Console. Predefined roles to perform Planning functional activities are assigned directly in Planning. Single sign-on and access to environments is controlled by Oracle Identity Management. Global application roles, and artifact dimension access are assigned through Oracle Cloud Identity.

What 3 features do you need to enable in order to perform indirect cash flow statement planning?. Revenue. Balance Sheet. Cash Flow Statement. Expense. Income Statement.

In Module-based Planning, you can configure the time frame and granularity for plans and forecast for each module. You can have different time frame and granularity for each module and for each year. When configuring Financials, in which component do you configure time frame and granularity for plans?. Valid Intersections. Seasonal Management. Manage Time Periods. Planning and Forecast Preparation.

To enable Strategic Modeling business cases to be a data push target, what are two data mapping types are supported for Strategic Modeling?. Strategic Modeling Scenario Rollup to Strategic Modeling Model. Planning to Strategic Modeling Scenario Rollup. Strategic Modeling Scenario Rollup to Strategic Modeling Scenario Rollup. Strategic Modeling Model to Strategic Modeling Scenario Rollup.

Which 2 are benefits of enabling Use Database Suppression in Smart Push?. It suppresses rows, or columns, or both that contain No Data/ Missing or Zero, but not both. It automatically merges comments, attachments, and supporting detail when mapping a database for reporting. It helps eliminate the impact on query thresholds and improving wait times. It allows you to load large amounts of data from an aggregate storage cube without using the missing block and row suppression options. It enables you to apply a row suppression at the database level instead of the application Level.

What is the correct sequence of steps for enabling each Planning module?. Enable the module, configure the module, run post configuration tasks. Enable the module, refresh the database. Configure the module, refresh the database. Run pre-configuration task, enable the module, configure the module.

Which tasks do you perform using a sequence of commands in EPM Automate to import metadata into Planning?. Upload the file to the inbox/outbox. Use a job to import the metadata, and refresh the cube. Perform a migration and Specify the local metadata file in the EPM Automate command. Specify the path to the local file in the import metadata command, run the import, and refresh the cube. Upload the file to the Inbox/Outbox, and Perform a migration using that file.

In Workforce, which option can you enable which allows you to set a date by which existing employees must be hired to be eligible to receive merit, and allows you to specify the month in which merit should start?. Merit Assumptions. Merit Rates. Merit Month. Workforce Assumptions.

What does a navigation flow allow you to do? Choose the best answer. Promote a plan to your supervisor. Display report variances by geography. Run multiple business rules in a predetermined sequence. Customize the clusters and cards that a user can access.

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.

Which 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. geRun pre configuration tasks, enable the framework, configure the framework.

Which option is true when implementing security in Enterprise Planning and Budgeting Cloud (EPBCS)? (Choose one option.). 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.

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.

Which two client requirements align with using an ASO plan type alongside the module-based 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 actuals history for reporting purposes but only requires prior year history for planning purposes. Due to sparse dimensionality, aggregation times are slow in the application. The client has 10 dimensions in the application and needs to report at each intersection.

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.

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.

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.

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.

A company has enabled Financials and would now like to make changes to the Initial configuration. Which three changes can be made?. Enabling Expense. Enabling Income Statement. Disabling already enabled features. Adding custom dimensions. Enabling Rolling Forecast. Removing custom dimensions.

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.

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.

Which three are predefined Workforce business rules? (Choose three.). Transfer. Plan Departure. Promote Employee. Change Job. Remove Existing Employee.

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 questions 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.

Which card allows you to enable modules? (Choose the best answer.). Valid Intersections. Data Maps. Overview. Settings. Configure.

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 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.

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.

Which two methods can be used to push data between cubes? (Choose two.). Data Management. Import Data. Data Maps. Copy Data.

Which two roles can be set for Strategic Modeling? Choose two. Analyst. Forecaster. Planner. Modeler.

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.

Which three metadata artifacts can be exported to a flat file? (Choose three.). Exchange Rate Tables. Dimensions. Smart Lists. Linked Reporting Objects. Data Entry Forms.

If the HSP_VIEW dimension exists in the cube, what feature has been enabled? (Choose the best answer.). Rolling Forecast. Intercompany Eliminations. Multicurrency. Sandboxes.

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.

Which three accounts in Workforce leverage the Component dimension for driver and trend-based calculations? (Choose three.). Revenue. Balance Sheet. Expense. Cash Flow.

What three tasks can you perform in the Data Management Workbench? (Choose three.). Export. Validate. Maintain Process Tables. Import. Delete Integration.

After loading Workforce data from external systems, which statement describes actions you can take to make adjustments to loaded data and then calculate compensation expenses? Choose the best answer. In Workforce, change properties such as salary grade and FTE, and then calculate salary, benefits, additional earnings, and taxes based on assumptions in Planning. Change loaded salary information in Workforce and then run the data map for Compensation Data to calculate the updated benefits. Change loaded benefit information in Workforce such as options for medical benefits and then launch the compensation data business rule to calculate the updated benefit data. In Workforce, if you change both the selected benefit option and the rate, when compensation expenses are calculated, the value will be based on the benefit option's default value.

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.

When defining data load mappings in Data Management, what are the available types of member mappings? (Choose the best answer.). Explicit, Range, In, Multi Dimension, As. Explicit, Range, In, Multi Dimension, Like. Explicit, Range, In, Ignore, Like. Explicit, Between, In, Multi Dimension, Like.

Which three can be automated with EPM Automate? (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.

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.

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.

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.

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. 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.

Several users continuously use custom-created formulas in Excel to supplement their Planning form inputs. What is another design alternative to reduce offline. Cell commentary. Reports. Ad hoc forms. Smart forms. Smart push.

To assign Workforce resources to initiatives, which default custom dimension is required in the Map/Rename Dimensions section? (Choose the best answer.). Project. Program. Elective. Measure.

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.

What three actions can you perform on the data displayed in the Data Integration Workbench? (Choose three.). Re-register or modify the data source system. Open loaded data in Microsoft Excel. Apply a filter using Equal and a specific value. Apply a filter using Contains and a specific value. Drill-through to source from specified data cells.

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 Manage.

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.

When loading Salaries into Workforce, which Property should the values be loaded to?. OWP_Gross Earnings. OWP_Salary Basis. OWP_Value. OWP_Expense Amount.

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.

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_Load. OFS_Integration. OFS_Calculated. OFS_Systems.

What type of Insight provides information of a hidden trend?. Forecast Variance and Bias. Prediction. Anomaly. Variance Analysis.

Which option describes Intelligent Performance Management (IPM)?. Checks when conditions are met in forms and generates messages when (specified ). Analyzes past data and predicted data, helping you find patterns in data. Enables users to keep their work private (from other non administrators) as they develop their plans. Display high-level aggregated information for quick consumption at a glance.

You can open an Expense form and a Revenue dashboard side by side without opening them in multiple pop-up windows. Which Redwood Experience Planning feature enables you to open forms and dashboard without opening them in multiple pop-up windows?. Navigation Tabs. Dashboards 2.0. Infolets. Dynamic Tabs.

Which card in the Application cluster allows you to enable modules?. Tools. Enable Features. Cube editor. Settings. Configure.

Which statement if true about the Currency dimension for Multidimension application types?. It is not provided with any content, and is set up as a custom dimension. It contains a single member called Local and other members representing reporting currencies. It contains a list of currencies and exchange rate types. It contains a section for input currencies and another for reporting currencies.

For which three applications types can you create and edit Groovy Rules?. Reports. Module (Enterprise). Hybrid. Module (Standard). FreeForm. Custom.

Which item CANNOT be pushed between cubes using data maps?. Data change history. Supporting detail. Comments. Attachments.

Which two are features of FreeForm applications?. In FreeForm applications, you can use cross-cube data maps and Smart Push. Approvals support is not available because this feature requires the provided Scenario and Version dimensions. FreeForm applications support Groovy scripts for custom functions. Governors are applicable at the cube level.

Which two statements are true about importing data from a job?. You select data load files from the inbox. You can specify an error file to provide information about rejected records. You must refresh the database after importing data. You must select the Include Metadata option to improve data import performance. You select the data file locally.

Which two can be used to push data between cubes?. Import Data. Copy Data. Data Integration. Data Maps.

What is the business benefit of defining invalid intersections?. It eases the definition process in uses cases where you only need to …. It enables you to quickly define Deny Read access for a select few cell combinations. It allows you to prevent data from being loaded via Data Management for a select few cell combinations. It eases the definition process in use cases when you need to quickly ...

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. Pay Type. Property. Component. Account.

Which two describe Oracle EPM guidelines for implementing Insights?. For future data, create a new insight by leveraging templates that include …. For future data, first run predictions in a test environment to ensure there is not impact on production data. For historical data, there should be at least twice the amount of historical data as the number of prediction periods. For historical data, create Insights job using the lowest level of Period members possible so that the greatest amount of historical data can be used.

Which three are valid considerations when migrating Reports from Financial Reporting?. You may have to modify certain elements after the report has been migrated creating a report that is equivalent to the original report. Migrating from Financial Reporting always automatically produces a report that is equivalent to the original report. If the Financial Reporting page axis member selection contains multiple prompts, the member selection will be migrated to multiple prompts in Reports. There are differences between the two solutions, and not all elements exists in both solutions. The system will convert as many elements of the original report into the Reports equivalent as possible.

Which four dimensions are enabled for access permissions by default?. Entity. Version. Account. Period. Scenario. Years.

Which module do you enable and configure if you want to develop plans and forecasts with driver or trend based income statement, balance sheet, and cash flow planning, or simply plan revenue and expenses?. Projects. Financials. Strategic Workforce. Capital.

Which two statements describe types of insights that can be configured?. Detect outlier values that vary widely from other values. Either use a prebuilt forecasting method or a freeform formula that you build. Reveal hidden bias in forecasts submitted by planners by analyzing historical data. Assign a range of possible values to inputs that are uncertain and analyze how that uncertainty affects related accounts.

From which two locations can you export data files?. Repository. Local. Outbox. Workspace.

Which two are benefits of insights?. Reduces time spent in data analysis. Improves forecast accuracy and reliability, enhancing forecast effectiveness with informed decision making. Combines a set of rich financial forecasting and modelling features with built in on the fly scenario analysis and modelling capabilities. Enables users to view and interact with high level information generated from different sources.

Which task can you perform when creating a strategic model from an existing model?. Select a file from which to import the chart of accounts. Keep the same time structure as the existing model. Select a file from which to import account groups. Choose which reports to include.

What is the purpose of selecting the project benefits option when enabling projects?. Plan detailed project revenue for contract projects. Plan detailed project expenses for projects. Help justify the need for projects and plan nonfinancial benefits. Track the workforce expense benefits calculated on each contract project.