study

1. You are creating a multicurrency Enterprise Profitability and Cost Management application. Which required dimensions are added by default when you create the application?. Years, Period, Scenario, PCM_Balance, PCM_Rule, Entity, Account, Currency. Years, Period, Scenario, Version, PCM_Balance, PCM_Rule, Entity, Account, Currency. Years, Period, Scenario, PCM_Balance, PCM_Rule, Account, Currency. Years, Period, Scenario, Version, PCM_Balance, PCM_Rule, Account, Currency.

2. You are designing a product dimension where products are aggregated in a hierarchy by type. You also need to organize the same products into a hierarchy that is aggregated by brand using shared members. Which dimension design is both valid and follow best practice design recommendations?. Set the dimension to Multiple Hierarchies; create Product by Type as a Stored hierarchy at Gen2; create Product by Brand as a Dynamic hierarchy at Gen2. Set the dimension to Stored; create Product by Type and Product by Brand hierarchies at Gen2. Set the dimension to Dynamic; create Product by Type and Product by Brand hierarchies at Gen2. Set the dimension to Multiple Hierarchies; create Product by Type and Product by Brand as Stored hierarchies at Gen2.

3. Which two are reasons to group rules into a rule set?. To apply the same rule sequence to multiple rules. To apply the same calculation option to similar rules. To apply the same allocation destination to multiple rules. To apply the same rule set context to multiple rules.

4. You are Migrating an application from Profitability and Cost Management to Enterprise Profitability and Cost Management. Which two application objects can you migrate?. Model Views. Dimensions. Rules. Data Grants.

5. For which tow purposes are data forms used in Enterprise profitability and Cost Management applications?. To support rule balancing, profit curve reports, and trace diagrams. For designing allocation and custom calculation rules. For data entry and analysis, and building dashboards and infolets. To Support reports in financial Reporting Web Studio.

6. You are designing an application with Actual, Plan, Forecast, and What-if scenarios. Actual and Plan data follow the same business logic for data transformation. Forecast and What-if data both have different business logic for data transformation. How many models do you need to create?. Three. One. Four. Two.

7. What does defining a model context enable a developer to do?. Select a fixed set of POV members to be used for all model calculations. Avoid making repetitive selections at the rule set or rule level for dimensions that use the same member for all rules in the model. Filter the scope of allocations and custom calculations at runtime to specific members of dimensions. Define the sequence in which the rule sets for the model should run.

8. Which two statements explain why it is a best practice to validate your models before you calculate them?. It helps identify potential issues with calculation performance before you calculate. It helps identify rules that have incorrect driver locations or allocation offsets defined. It helps identify rule sequencing errors in your allocation waterfall. It helps identify rules that are affected by changes in dimension metadata.

An allocation rule evenly allocates data form the Corp HQ entity to the Marketing, Sales, and Finance entities. The following image represents the starting point of the data below the allocation. pcm input 3000 pcm net balance 3000 ocm remainer 3000 Which image accurately represents the system´s placement of data across the PCM_Balance dimension the allocation is complete?. pcm input 3000 pcm allocation in, 1000 marketing,1000 sales, finance 1000 pcm allocation out 3000 pcm netbalance, 1000 marketing,1000 sales, finance 1000 pcm allocation offset amount 3000 pcm remainer 3000, 1000 marketing,1000 sales, finance 1000. pcm input 3000 pcm adjustment in, 1000 marketing,1000 sales, finance 1000 pcm adjustment out 3000 pcm netbalance, 1000 marketing,1000 sales, finance 1000 pcm allocation offset amount 3000 pcm remainer, 1000 marketing,1000 sales, finance 1000. pcm input 3000 pcm adjustment out in 3000 pcm allocation out, 1000 marketing,1000 sales, finance 1000 pcm netbalance, 1000 marketing,1000 sales, finance 1000 pcm remainer, 1000 marketing,1000 sales, finance 1000. pcm input 3000 pcm allocation in, 1000 marketing,1000 sales, finance 1000 pcm allocation out 3000 pcm netbalance, 1000 marketing,1000 sales, finance 1000 pcm remainer, 1000 marketing,1000 sales, finance 1000.

10. Which two statements are true when defining source and destination for allocation rules?. You can select members from any dimension, even those included in the rule context. The member you can select for the destination are limited to the dimensions that you selected for the source. When you select a parent member for the destination, data is allocated to the level 0 member under the parent. You can specify the amount to allocate from the source.

11. You are creating a rule set for allocation rules. On the Description tab, you select Use Model Context. Which statement is true when defining a rule in the rule set?. You can override the model context selections by selecting different source or destination members. When you select Use Rule Set Context, the member selections defined in the model context are automatically applied. You can selectively apply contexts by selecting Use Rule Set Context, Use Model Context, or both. You can go to the Rule Context tab and edit any model or rule set contexts applied to the rule.

12. You are creating an allocation rule where the allocation source includes all children of Parent1. For the source, you select Parent1 instead of its Children individually. Which two are benefits of referencing the parent-level member?. You create many source-to-destination associations with a few keystrokes. The allocation data is stored at a less granular level, improving performance. You do not need to create as many model Context definitions. You do not need to build separate allocation rules for each child.

13. You are creating a rule to allocate IT costs to entities based on the headcount for each entity. The application includes a custom called Product. Rule Set Context: Product: NoProduct Allocation source definition: Account: IT Cost; Entity: Corporate HQ Allocation destination definition: Account: IT Cost; Entity: Descendants of Entity Disregarding the system and POV dimensions, this data file shows where headcount data is loaded to the application: Product, Entity, Account, Amount NoProduct, Entity1, Headcount, 150 NoProduct, Entity2, Headcount, 90 NoProduct, Entity3, Headcount, 75 NoProduct, Entity4, Headcount, 120 Which dimension members should you select for the driver location on the Driver Basis tab when you define the allocation rule?. Headcount. NoProduct, Corporate HQ, Headcount. Entity1, Entity2, Entity3, Entity4. NoEntity, Headcount.

14. When you access the validation tab in an allocation rule, which two conditions would create an error message and disable the rule?. A member name referenced in the rule has been either deleted or changed in dimension management. You selected the same upper-level member for a dimension in both the source and destination. You do not have a member selected for one of your source or destination dimensions. You used an upper-level or calculated member in your driver definition.

15. When defining the allocation destination for a dimension, which option essentially means that there is no allocation movement on the dimension?. Current member. Same as Source, Same Dimension. Same as Source, Different Dimension. Segmented Calculation.

16. Which two are steps to create an allocation rule?. Populate the source and destination dimensions. Populate the allocation formula. Select the calculation option for the rule. Populate the driver basis dimensions.

17. As an implementer, you are assessing clients’ reporting, analysis, and processing needs. Which two use cases would be a good fit for implementing an Enterprise Profitability and Cost Management application?. A client who wants to track costing for IT projects, services, consumer chargebacks, and showbacks. A client who needs to analyze their strategic profitability by looking at multidimensional profit and loss reporting and cost contribution detail. A client who wants to apply Monte Carlo simulations to general ledger data for What-if analysis and planning. A client who needs to plan sales quotas from the top down, using best practice methods built into out-of-the-box forms, calculation, and dashboards.

18. You discover that your input data for a POV needs to be replaced with a new data set. Which two are valid options to clear input data from the calculation cube?. On the Application Overview page, create an Import Data job for the new data set. Select Clear Data Before Import in the dialog box. On the Calculation Control page, clear data from a selected POV. Select Input Data in the dialog box. On the Calculation Control page, run a model calculation against one or more POVs. Select Clear Calculated Data in the dialog box. On the Application Overview page, create a Clear Cube job. Define the area to clear using the POV and the PCM_Input member.

19. Which two statements are true about selecting a processing range for your model calculation that only calculates a portion of the model?. The "Start from selected rule" option ends with the last rule in the same rule set as the selected rule. Calculating only a subset of the model can aid you in testing your rules and rule sets. Ruleset range selections are based on the rule set names, not their sequences. You need to keep in mind any upstream or downstream dependencies in your waterfall setup.

20. On the Calculation Control page, you select three POVs and then click Calculation Model. Which two statements are true?. The calculations are run in the order that you selected the POVs. The system runs calculations for all three POVs concurrently as a batch job. The calculation uses the same processing and ranges for all POVs. You can select different models to run for each POV.

21. Which two types of insights into your model calculation can you understand by looking at the Rule Balancing page?. How much unallocated data remains in a particular slice of your cube. That one or more of your rules didn’t allocate the amount that you expected. That driver is missing for one or more of your rules. The calculation performance statistics for each rule listed.

22. You design a model with a final stage that allocates financial data out to market-facing dimensions of Customer and Product. These are the largest dimensions in the application so you know that the final allocation stage will cause an explosion of data points. What can you do to minimize this effect?. In your final allocation, be sure to reference parent members for dimensions where detail levels are not required in the final analysis. Include a custom calculation rule before the final stage that clears calculated data from earlier rules. Create rules to pool data in dimensions where detail levels used in previous allocation steps are no longer required. In your final allocation, leave out references to dimensions where detail levels are not required in the final analyzes.

23. You run your allocation waterfall and find that your data has expanded to trillions of data cells, many hundreds of times larger than the original data. This, in turn, is slowing performance and creating data sets that are too large to export to your external system in a single step. Which three are best practice application design strategies that can minimize these effects?. Restrict your dimensions to only those that are represented in the source (input) data. Avoid using multiple dimensions with very large member counts. Reduce your dimension count by using UDAs and attribute dimensions where possible. Combine all dimensions into more. Limit the number of members in your dimensions as much as possible.

24. Best practice recommendations for application design include both keeping the number of dimensions as small as possible and adding placeholder dimensions for future growth. How are these recommendations both valid and without contradiction?. Placeholder dimensions are not considered in the total dimension count for the application. Placeholder dimensions have only one member, so they have little impact on performance or data scale. Data is not indexed across placeholder dimensions, so they don’t affect data scale unless you enable them. You don’t reference placeholder dimensions in rules, so they don’t affect calculation performance.

25. In addition to a rule set name, which two components are required to create rule set?. Model context. Rule set context. Rule set calculation option. Sequence.

26. You have a rule set that includes these rules to allocate administrative costs  Allocate HR admin to IT and Finance  Allocate IT admin to HR and Finance  Allocate Finance admin to HR and IT Which two option indicate the type of allocation these rules and the calculation option you should use for the rule set, respectively?. Type: Recursive allocation. Execution method: Iterative. Execution method: Reciprocal. Type: Reciprocal allocation.

27. You want to export all level 0 data from your Enterprise Profitability and Cost Management cubes. Which export option offers the best performance?. A data integration using Standard Mode. A data integration using Quick Mode. An export data job that references all level 0 members. A data map that queries all level 0 members.

28. You are designing data forms to use on the Rule Balancing page. Which two Statements are true?. The Rule Balancing page displays columns for specific members of the PCM_Balance dimension, regardless of your member selections in the form desing. Whatever member selections you make for the dimensions in the data form POV, you can override them on the Rule Balancing page. The row dimension for Rule Balancing forms is defined as the level 0 descendants of the PCM_Rule dimension. Data POV dimensions (Period, Years, Scenario, Version) go in the data form POV section, all other non-system dimensions go in the Page section.

29. You are migrating a Profitability and Cost Management application to Enterprise Profitability and Cost Management. You ran a full migration, including data, which created an application on your Enterprise Profitability and Cost Management instance. However, the migration completed with errors. After modifying and validating your migration template, you upload the modified template to your Profitability and Cost Management inbox, overwriting the original migration template. Which two additional steps are required before repeating a full migration?. Delete the migrated data file from your Enterprise Profitability and Cost Management application inbox. Delete the migrated data file from your Profitability and Cost Management application inbox. Remove the application from your Enterprise Profitability and Cost Management instance. Delete the first migration snapshot from your Profitability and Cost Management application inbox.

30. Your customer needs their Enterprise Profitability and Cost Management application to group customers by business type for allocations. They also need to group customers by geographical regions for some but not for allocations. Which two dimensions design option follow best practice recommendations for managing data scalability and performance?. Create one stored dimension and one attribute dimension: a stored Customer dimension hierarchy organized by business type and an attribute dimension with the Region. Create one dimension with multiple hierarchies. The first hierarchy is stored and organizes customers by business type, and the second hierarchy is stored and uses shared. Create two stored dimensions: a stored customer dimension hierarchy organized by business type and stored Region dimension hierarchy with geographical regions. Create one dynamic dimension with multiple branches, The first branch organizes customer by business type, and the second branch uses shared members to organize customers by region.

You are migrating a Profitability and Cost Management application to Enterprise Profitability and Cost Management. In your Profitability and Cost Management application, your Scenario dimension includes a member named Working, and you have no Version dimension. This member name conflicts with a default member in the Version dimension in Enterprise Profitability and Cost management. In which two ways can you address this issue in the migration template?. Add a mapping in the <Version_dimension> section that maps the working scenario to the working version. Add a mapping to rename the conflicting member in the <rename_member_mapping> section. Include the Scenario dimension in the <duplicatemenberprefixes> section to append a prefix to the configuration. Leave the <version_dimension> section blank to create the Enterprise Profitability and Cost Management application without a version dimension.

32. Which two items can you define when creating multiple rule sets at the same time?. Calculation option. Rule set context. Rule set name. Sequence.

33. You want to change multiple rules using a Mass Edit action. Which action is unavailable on the Mass Edit tab?. Replace members in rules. Delete rules. Copy rules to a different rule set or model. Enable and disable rules.

34. Which two statements are true about model calculations?. Reversing an adjustment requires creating a reverse adjustment. Calculations do not change your input data. You can clear or recalculate rules an unlimited number of times. You can run calculations for only one POV at a time.

35. Which statements is true about the PCM_Balance and PCM_Rule dimensions?. Data for the members [Allocation In] and [Allocation Out] are populated by allocation rules. The PCM_Balance dimension is considered a POV dimension. Data is loaded to the member [input] in the PCM_Rule dimension. Rule names are assigned as aliases to the rule number members in the PCM_Rule dimension.

36. You The Concurrent Threads Application option supports up to 5 concurrent threads. Assume that the concurrent threads option is set to 2. Given these two rule sets, in what order will the rules be calculated? Rule Set A, Sequence = 1, Calculation Option = Parallel o Rule 1: Sequence = 1 o Rule 2: Sequence = 2 o Rule 3: Sequence = 2 Rule Set B, Sequence = 2, Calculation Option = Parallel o Rule 4: Sequence = 1 o Rule 5: Sequence = 1 o Rule 6: Sequence = 2. Rule 1, Rule 4, and Rule 5 will run in parallel, while Rule 2, Rule 3, and Rule 6 also run in parallel (one calculation step). Rule 1, Rule 4, and Rule 5 will run in parallel; then Rule 2, Rule 3, and Rule 6 will run in parallel (two separate calculation steps). Rule 1 will run, then Rule 4 and Rule 5 will run in parallel; then Rule 2 and Rule 3 will run in parallel; then Rule 6 will run (four separate calculation steps). Rule 1 will run, then Rule 2 and Rule 3 will run in parallel; then Rule 4 and Rule 5 will run in parallel; and then Rule 6 will run (four separate calculation steps).

37. After successfully completing a migration of your Profitability and Cost Management application to Enterprise Profitability and Cost Management, which two task must you complete in Enterprise Profitability and Cost Management?. Import data integrations created in Profitability and Cost Management. Create the reporting cube (PCM_REP). Create data forms to support rule balancing, data entry, and analysis. Set up security, including metadata and data access, user group assignments, and user role assignments.

38. Your creating Points of View (POVs) from the Calculation Control Page for an Enterprise Profitability and Cost Management application that uses a monthly frequency. Selections Years:FY21, FY22 Period: YearTotal Scenario: Actual, Forecasat Version: Working Given these selections, how many POVs will you create?. 24. 4. 48. 12.

39. Which of these Point of View (POV) states is invalid?. Published. Draft. Archived. Final.

40. Which two statements are true about the Result dimensions in a custom calculation rule?. You can select any dimension for the Result dimension (Including POV dimensions and those definied in the model or rule set context). In combination with the target dimension selections, it defines the intersections where formula results are written. By default, the Account dimension is selected for the Result dimension. It provides the context for the calculation formula (you write the formula for a level 0 member of the result dimension).

41. In the following formula, which two tuples can you use as input for the NONEMPTYTUPLE clause to ensure correct calculation results?. ([Unit Cost]) := NONEMPTYTUPLE (?) ([TotalExpense], [PCM_NetBalance]) / ([Units], [PCM_NetBalance], [CostPool]);. ([Units], [PCM_NetBalance],[CostPool]). ([TotalExpense], [PCM_NetBalance]). ([Unit Cost]). ([PCM_Adjustment In], [Unit Cost]).

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

43. You want to calculate entity2´s IT Costs value as 125% of entity1´s input IT Cost value. Consider the following custom calculation rule definitions Rule Definition 1 Result dimension: Balance Formula: [Adjustment In]:= ([Input]), [Entity1], [NoRule])*1.25; Target dimensions: Entity; Entity2; Account: IT Cost Rule Definition 2 Result dimension: Account Formula: [IT Cost]:= ([Input], [Entity1], [NoRule], [IT Cost])*1.25; Target dimensions: Entity; Entity2; Balance: Adjustment In Rule Definition 3 Result dimension: Entity Formula: [Entity2]:= ([Input], [Entity1], [NoRule])*1.25; Target dimensions: Account: IT Cost; Balance: Adjustment In Which option indicates a valid calculation rule definition or definitions?. 1 and 2. 1,2, and 3. 1 and 3. 1 Only.

44. You have a custom calculation rule with the following formula that usually works but sometimes produces incorrect results. Why? ([STAT1120]) := NONEMPTYTUPLE ([STAT1130]) ([STAT1130]) + ([STAT1140]);. The input for the NONEMPTYTUPLE clause should be the same as the result tuple ([STAT1120]) on results can be incorrect. If SAT1130 has no value but STAT1140 does, the NONEMPTYTUPLE clause causes the calculation to be skipped. If the NONEMPTYTUPLE clause does not use a member of the PCM_Balance dimension, results can be incorrect. If STAT1140 has no value but STAT1130 does, The NONEMPTYTUPLE clause causes the calculation to be skipped.

45. You are setting up an Enterprise Profitability and Cost Management application instance. Which two statements are true about the application environment?. The PCM_CLC and PCM_REP cubes are created by default when you create the application. You can configure the cubes in the application as either Block Storage (BSO) or Aggregate Store (ASO). All cubes in the application must have the same dimensions. Changes to dimensions must be deployed to the application´s cubes before running allocation.

46. You are testing your model calculations. You run a calculation for a POV, which creates a calculation record on the calculation Analysis page. You then make some changes to some of the rules in the model. When you select the calculation record and use the Rerun Calculation action, which version of the model is used in the calculation?. You can select which version of the model you want to use. The model snapshot from the calculation record is used. The current version of the model is used. You cannot rerun this calculation after changing the model.

47. Which two statements are true about the calculation Analysis page?. Only one calculation record per POD is listed. Calculation records do not include EPM Automate or REST API processes. You can delete selected calculation records. You can rerun a selected calculation with the same parameters.

48. You run a model calculation and receive warnings for multiple rules with missing source or driver data. Which troubleshooting option will allow you to verify the source and driver data for all of the rules in the calculation using a single step?. Run the calculation again, with the Capture Diagnostics Data processing option selected. Run the calculation again, with the Capture Essbase Debug Scripts processing option selected. Run the Export Input Data Job to export source and driver data to a flat file for investigation. Run the Rule Data Validation report, with source data and driver data both selected.

49. You are troubleshooting your model calculations using Calculation Statistics report. Which of these questions cannot be answered by looking at this report. How many Essbase calculation scripts are generated for each rule?. Which rules are taking the longest to run?. How many potential source intersections must be scanned for allocations??. Does source and driver data exist for allocation rules??.

50. You run a model calculation for the current month, and it takes five times longer to run than the previous month. Which diagnostic report should you run to investigate the reason?. The Compare with Current Model report. The Calculation Statistics report. The Compare Model Snapshot report. The Calculation Statistics Comparison report.