N1

Which two statements are true about managing Points of View (POVs)?. (A). You can archive POVs, but you cannot delete them. (B). A POVs status is automatically changed to Calculated when you calculate the POV. (C). When you add a new POV, the status Is automatically set to Draft. (D). Global rules and rule sets are not associated with a specific POV. (E). All POVs are data POVs, even If the data set Is empty.

Which Is a valid set with report objects, when designing reports in Financial Reporting Web Studio?. (A). Tables, Charts, Text, KPIs. (B). Grids, Charts, Profit Curves, Text. (C). Text, Charts, Grids, Images. (D). Charts, KPIs, Profit Curves. Tables.

Which Is an INCORRECT way to execute a data load rule In Data Management?. (A). Execute option on the Data Load Rule screen. (B). Run Integration option on the Workflow lab. (C). Batch Execution option on the Workflow tab. (D). Import Source option on the Data Load Workbench screen.

What Is the maximum number of screens a Dashboard can display at one time?. (A). 8. (B). 9. (C). 6. (D). 4.

Which three are valid functions of logic accounts In Data Management?. (A). Logic accounts allow the mapping of a source account based on its value (conditional mapping). (B). Logic accounts can perform arithmetic operations on source values (arithmetic mapping). (C). Logic accounts determine how the source fields are stored In the Data Management staging tables (storing mapping). (D). Simple logic groups enable you to derive logic items front any combination of dimensions (derived mapping). (E). Logic accounts allow the mapping of one source account to multiple target accounts (statistical mapping).

Which three are valid statements about Locations In Data Management?. (A). A location can be assigned to more than one data load rules. (B). A location can be assigned to more than one Import format. (C). You can create duplicate locations with the same source system and application combination. (D). Different locations can use the same import format. (E). A location may have more than one source system.

Which system report verifies that all required source and driver data Is included for allocation and custom calculation rules?. (A). Rule Data Validation Report. (B). Rule Documentation Report. (C). Model Validation Report. (D). Rule Execution Statistics Report.

Which statement Is FALSE about Dimension Management In Profitability and Cost Management?. (A).You can manually edit Business, Attribute, and Point of View dimensions. (B). System dimensions ore not displayed In Dimension Management. (C). Profitability and Cost Management uses dimensions and members created In Oracle Essbase. (D). Dimensions are imported using flat files or the Data Management feature.

Which two statements are true about Period and Category Mapping definitions In Data Management?. (A). Period mappings define the mapping between ERP calendars and Profitability and Cost Management years and periods. (B). If the source category matches the target category in Data Management (e.g. "Actual" to "Actual"), then a category mapping definition Is not required. (C). You use source level period mapping when you have multiple target applications and various source systems with different period types. (D). Period and category mappings are defined separately from data load member mapping.

Which two statements are true about allocation offset for allocation rules?. (A). Offsets are written to the Allocation Offset member of the Balance dimension, in combination with the other dimension members defined for the offset. (B). Defining an allocation offset Is optional“. (C). The offset location defines the member to hold any unallocated data from the source. (D). By default, offsets are written to the source.

Which two are valid statements about the Balance and Rule dimensions?. (A). Rule names are assigned as aliases to the rule number members In the Rule dimension. (B). Data is loaded to the member Input in the Balance dimension. (C). Data Is loaded to the member Input In the Rule dimension. (D). The Balance dimension is considered a POV dimension. (E). Data for the members Allocation In and Allocation Out are populated by Profitability and Cost Management rules.

Which two are valid ways to delete a dimension member?. (A). importing a dimension structure into the application. (B). using EPM Automate. (C). using the Dimension Management feature. (D). using Smart View.

Which three are valid statements about batch processing in Data Management?. (A). Batches can be executed from EPM Automate. (B). Service Administrators can configure security to limit which batches users can run. (C). Batch processing combines one or more data load rules In a batch so you can run multiple data load rules In one step. (D). Batch processing combines one or more dimension builds In a batch so you can run multiple dimension builds in one step. (E). Batch processing does not support parallel loading of data files.

Assume the computer hardware supports parallel calculation. Given these two rule sets, in what order will the rules be calculated? Rule set A Rule 1 seq 1 Rule 2 seq 2 Rule 3 seq 2 Rule set B Rule 4 seq 1 Rule 5 seq 1 Rule 6 seq 2. (A). Rule 1, Rule A, and Rule 5 will run In parallel; then Rule 2, Rule, 3, and Rule 6 will run in parallel (Two separate calculation steps). (B). Rule 1; then Rule 2 and Rule 3 will run in parallel; then Rule 4 and Rule 5 will run in parallel; then Rule 6 (four separate calculation steps). (C). Rule 1, Rule A, and Rule 5 will run in parallel while Rule 2, Rule 3, and Rule 6 also run in parallel (one calculation step). (D). Rule 1; then Rule 4 and Rule 5 will run in parallel; then Rule 2 and Rule 3 will run in parallel; then Rule 6 (four separate calculation steps).

You want to limit the slices of data your users can view or work with. Which two security mechanisms can you use?. (A). Security filters. (B). Service roles. (C). User groups /acces groups. (D). Application roles. (E). Data grants.

Which two statements are true about allocation tracing?. (A). You can trace allocation inputs and outputs both forward and backward. (B). You select the rule you want to trace In the trace parameters. (C). Allocation traces can be performed across multiple business dimensions simultaneously. (D). It is a graphical representation of how allocations flow in and out of application elements.

Which set of dimensions Is required for Profitability and Cost Management applications?. (A). Two system dimensions (Balance and Rule), at least one Business dimension, at least one POV dimension. (B). Three system dimensions (Balance, Rule, and Drivers), at least two Business dimensions, at least one POV dimension. (C). Three system dimensions (Balance, Rule, and Drivers), at least one Business dimension, at least one POV dimension. (D). Two system dimensions (Balance and Rule), at least one Business dimension, at least one POV dimension, at least one Attribute dimension, at least one Alias dimension. (E). Two system dimensions (Balance and Rule), at least one Business dimension, at least one POV dimension, at least one Alias dimension.

Which set of items do you need to define for a custom calculation rule?. (A). Result dimension, target range, formula. (B). Source, destination, offset, formula. (C). Target range, formula, offset contex. (D). Source, target range, destination, formula.

Which two statements are TRUE about cloning snapshots?. (A). You cannot clone a snapshot to a target In a different Identity Domain from the source. (B). You can select any snapshot from the source environment to clone to the target environment. (C). After cloning, the daily maintenance start time of the target environment Is reset to that of the source environment. (D). The cloning process deletes any existing application and uploaded files from the target environment.

Which role is required to create and manage user accounts for Profitability and Cost Management?. (A). Service Administrator. (B). Identity Domain Administrator or Security Administrator. (C). Identity Domain Administrator or Service Administrator. (D). Identity Domain Administrator. (E). Security Administrator.

Which are valid parts of an Analysis View Definition?. (A). a Row Dimension and multiple Column Dimensions and a Rule Set. (B). a Row Dimension and a Column Dimension and a range of Rule Sets. (C). a Row Dimension and multiple Column Dimensions. (D). a Row Dimension und a Column Dimension und a Rule Set. (E). a Row Dimension and a Column Dimension.

22 Your business process includes a series of allocations where administrative costs are allocated from HR to TT and Finance, from IT to Finance and HR, and from Finance to HR and IT. Which calculation option should you select for the rule set that Includes these allocations?. (A). Iterative Execution. (B). Circular Execution. (C). Batch Execution. (D). Serial Execution. (E). Parallel Execution.

Which two are required steps In creating an allocation rule?. (A). Assign the rule sequence number,. (B). Create at least one global context. (C). Create a rule set for the rule. (D). Create a rule set context.

Which statement Is FALSE about this EPM Automate command?. (A). It will fail if the user does not have the Service Administrator role. (B). It will load data from profitdata1.txt data then run all rules in rule1, txt. (C). It will fall If ruiei.txt and profitdatai.txt are not uploaded to the profitinbox first. (D). It will clear data from the slice of the database referenced in the data file and leave other data intact.

You update the name of a member that Is used In a number of allocation rules. After deploying the changes to the database, what step can you take next to update your rules?. (A). The system automatically propagates the name change to your allocation rules; no additional step is necessary. (B). Use the Find and Replace tool In the Manage Rules screen to replace the member In all rules that use It. (C). On the Mass Edit tab of the Designer screen, create and run a job to replace the member in all rules that use it. (D). Use the ReplaceMember command In EPM Automate to replace the member In all rules that use It.

What are two ways to create custom reports on the data In Profitability and Cost Management?. (A). Import report templates from the Download link in the Settings menu and customize them for your application. (B). Create forms In Profitability and Cost Management that can be displayed in dashboards. (C). Create queries In Profitability and Cost Management that open in Smart View when you run them. (D). Create formatted reports in Financial Reporting Web Studio.

You are creating a rule to allocate IT costs to entitles based on the Headcount for each entity. There are three business dimensions In the application (Product, Entity, and Account). The allocation source definition: Account: IT Cost; Product: NoProduct; Entity: Corporate HQ The allocation destination definition: Account: IT Cost; Product: NoProduct; Entity: Descendants of Entity Disregarding the system and POV dimensions, this data file shows where Headcount data is loaded in the application: Which business dimension members should you select for the driver location on the Driver Basis tab when you define the allocation rule?. (A). NoProduct, Headcount. (B). Headcount. (C). Entity1, Entity2, Entity3, Entity4. (D). NoProduct, Corporate HQ, Headcount.

Which two system level settings are not also user level settings In Data Management?. (A). Global POV profile settings. (B). the level of detail displayed In logs. (C). File character set. (D). The column delimiter value when exporting member mappings. (E). Whether archived files are copied or moved to the archive location.

Assume that the proper data permissions have been assigned In Profitability and Cost Management. Which two actions can you perform In Smart View?. (A). Display Analysis Views and Profit Curves that you created in Profitability and Cost Management in an Excel spreadsheet. (B). Create reusable Smart Queries to use for ad hoc reporting and analysis In Excel. (C). Update driver data in Excel and submit the changes back to Profitability and Cost Management. (D). Update dimension members and properties In Excel and submit the changes back to Profitability and Cost Management.

After running a calculation, you are evaluating the results In the Rule Balancing screen. What can you do to Investigate the data In more detail?. (A). Click on either Allocation in or Allocation Out to open an Allocation Trace. (B). Click on a value to drill down to more detail in the Rule Balancing screen. (C). Click on a rule number to open a report showing the entire allocation flow. (D). Click on a value to open a context sensitive query in Smart View.

Which Is NOT a key quality of the Models Interface In Profitability and Cost Management?. (A). Setting up the flow of funds through the financial system. (B). Managing and running reports. (C). Managing rules and rule sets. (D). Point and click model administration and calculation.

Which two statements are true about the Simple Workflow mode in Data Management?. (A). It provides a performance Improvement when processing large volumes of data. (B). You can view data in the Workbench after loading. (C). It limits data movement between staging tables. (D). It is the default mode for processing data. (E). Drill down Is supported.

Which three statements are valid about data load mappings In Data Management?. (A). Data Management processes mappings from left to right with Explicit processed first. (B). Special characters * and ? can only be used in the Source Value expression. (C). Mappings can be imported from Excel. (D). Data load mapping definitions for every dimension are required In Data Load Mappings except for Period and Category. (E). If the source member matches the target member exactly, no mapping definition Is required for that dimension.

Which two statements are true about model validation?. (A). You cannot deploy the application if model validation returns Invalid conditions. (B). Model validation validates rules, rule sets, and dimensions. (C). Running a model validation displays an error table with Information about Invalid conditions. (D). After the application is deployed, it can detect invalid model artifacts if changes are made to dimensions.

Which types of dimensions do you use to define model views?. (A). Business dimensions only. (B). Business dimensions, POV dimensions. (C). Business dimensions, POV dimensions. System dimensions. (D). POV dimensions. System dimensions.

Given the following possible actions: 1. Register a Source System 2. Register a Target Application 3. Create an Import Format 4. Define a Location 5. Create a Point of View 6. Define mappings for Period and Category 7. Define mappings for all dimensions 8. Define mappings for only those dimensions requiring mappings 9. Create a Data Load Rule What are the required steps in Data Management to create a data Integration for Profitability and Cost Management?. (A). 1,2,3,4,8,0. (B). 1,2,3,4,5,6,7,9. (C). 1,2,3,4,5,6,8,9. (D). 1,2,3,4,6,8,9. (E). 1,2,3,4,6,7,9.

Which three components are required to create a valid rule set?. (A). Using Global Context defined in POV. (B). Rule Set execution method. (C). Rule Set Name. (D). Sequence. (E). Defined rule set context.

Which two are valid statements about Profitability and Cost Management application requirements?. (A). Changes to Profitability and Cost Management dimensions must be deployed to the underlying Essbase database before running allocations. (B). You must have access to a separate instance of Oracle Analytics Cloud (Essbase) to use as the underlying data storage for Profitability and Cost Management. (C). You can configure the underlying Essbase database as either a Block Storage (BSO) type or Aggregate Storage (ASO) type. (D). Applications must have a Point of View with Year, Period, and Scenario dimensions. (E). An EPM Cloud service instance can support only one Profitability and Cost Management application at a time.

Which statement Is FALSE about Analysis Views?. (A). They can be viewed by any user of the application. (B). You can add formatting to the report results. (C). You can export their data to Excel for further processing. (D). You can use them as the basis for dashboards.

Which Is NOT a valid Point of View (POV) state?. (A). Archived. (B). Final. (C). Published. (D). Draft.

Which type of application Is created In Profitability and Cost Management?. (A). Management Ledger **. (B). Financial. (C). Standard. (D). Cost. (E). Detailed.

Your data file is not In a native Essbase format. Which Is the valid way to toad It to Profitability and Cost Management?. (A). Execute the LoadData command In EPM Automate, run a data load in Data Management, load the file through the Profitability and Cost Management UI in Database management. (B). Execute the LoadData command In EPM Automate, load the file through the Profitability and Cost Management UI in Database management. (C). Execute the LoadData command In FPM Automate, run a data load In Data Management. (D). Run a data load In Data Management, load the file through the Profitability and Cost Management UI in Database management. (E). Run a data load in Data Management.

Which Is NOT Included In the Profitability and Cost Management analytics tools?. (A). Trace Allocations. (B). Analysis Views. (C). Key Performance Indicators (KPIs). (D). Sculler Analysis Graph Scatter Analysis Graph. (E). Rule Update Analysis.

You validate your Profitability and Cost Management application build but receive an error. Which three are possible reasons of the validation failure?. (A). You only had one dimension defined as a point of view dimension. (B). You did not have at least one member in all dimensions. (C). You did not Include at least one Business dimension. (D). After the main hierarchy was defined, the dimension contained alternate hierarchy with shared members. (E). A stored hierarchy contained members with member formulas.

You are creating a rule set for allocation rules. On the description tab, you select Use Global Context. Which two statements are true?. (A). You can override the global context dimension selections at the rule set level. (B). When you select Use Rule Set Context for a rule In this rule set, the dimension-member combinations defined In the Global Context section are also applied. (C). At the rule level, the Rule Context tab is where you can edit any default contexts applied to the rule. (D). On the Context tab for the rule set, you define default members for use In all rules added to the rule set.

Which two statements are true about the Rule Balancing table?. (A). The default model view Includes the top members across all business dimensions. (B). It shows the potential effects of an allocation before you run It. (C). It Includes the Initial Input value, as well as allocations In, allocations out, and offsets. (D). It shows information for all rules in the selected rule sets.

For which two of these purposes can you use model views?. (A). To create analysis views for specific slices of data. (B). To assign data grants to specific slices of data. (C). To filter the results when tracing allocations or performing rule balancing. (D). When mass editing rules, to limit the edits to a subset of the data. (E). When copying POVs, to limit the copy to a subset of the data.

Which three are steps to create an allocation rule?. (A). populate the driver basis dimensions. (B). select the execution method. (C). populate the allocation formula. (D). populate the destination dimensions. (E). populate the source dimensions.

Which custom calculation formula Is syntactically correct?. (A). [Adjustment In]= ([Input], [Rule]) * .15;. (B). [Adjustment In]= ([Input], (Rule]) * .15. (C). [Adjustment In]:= ([Input], [Rule]) * .15;. (D). [Adjustment In]:= [Input],[Rule] *.15. (E). (Adjustment In)= (Input, Rule) - .15;.

Which Is the correct EPM Automate command to add a file containing dimension metadata to the Data Management Inbox folder in Profitability and Cost Management?. (A)uploadMetadata. (B)UploadDimension. (C)AddFile. (D)UploadFile.

Which statement Is FALSE about data grants?. (A). They can be assigned to groups or individual users. (B). They can be assigned to Service Administrators or Power Users. (C). They are used to control what dimensions and members can be accessed by the assigned users. (D). They generate security filters in Essbase when the database is deployed.

Assume that the proper data permissions have been assigned In Profitability and Cost Management. Which two actions can you perform In Smart View ?. (A). Display Analysis Views and Profit Curves that you created in Profitability and Cost Management in an Excel spreadsheet. (B). Create reusable Smart Queries to use for ad hoc reporting and analysis In Excel. (C). Update driver data in Excel and submit the changes back to Profitability and Cost Management. (D). Update dimension members and properties In Excel and submit the changes back to Profitability and Cost Management.

Your Profitability and Cost Management Cloud application contains a product dimension with 150 products. You've received a dimension data file containing only a list of 10 new products that need to be added to the current product dimension. You use the file to import the new product members, using the Update Dimensions option in the Profitability Application Console. Which result describes what will happen?. (A). The dimension update fails with errors and no changes are made to the product dimension. (B). The 10 new members are appended to the bottom of the existing product dimension. (C). The product dimension is replaced by the contents of the update file; only the 10 new members reside in the product dimension after the update. (D). The 10 new members are merged Into the product dimension and sorted alphabetically.

Which three are valid ways to create Profitability and Cost Management applications?. (A). Import a backup snapshot from another instance of Profitability and Cost Management,. (B). Create a custom application with dimensions from Hal files. (C). Create a custom application from an Essbase outline file. (D). Create a custom application with no dimensions, then create and load dimensions in Data Management. (E). Migrate an exported on-premises Profitability and Cost Management application using a migration template file.

Which dimension Is required for a Profit Curve chart In the application?. (A). Point of View Dimensions. (B). Department Dimension. (C). Profit Dimension. (D). Profit Attribute Dimension.

Which two statements are true about dashboards?. (A). All users can create and edit dashboards. (B). Dashboards can be enabled and disabled. (C). Charts In dashboards are based on existing Analysts Views. (D). You can drag and drop chart tiles to change the dashboard layout.