ID_PBC_EM

2. Which of the following delivered components cause quick implementation in Planning and Consolidation? 3 correct answers. A. Report Templates. B. Input Schedule Templates. C. Cost Center Planning Model. D. Sample Logic.

1. What benefits does BPC offer to a corporation? 2 correct answers BPC440. A. It gives the IT department control over budgeting and planning functions. B. It integrates with the Microsoft Office Suite including Word, Excel, and PowerPoint. C. It enables compliance with IFRS and SOX. D. It enables you to drill through to the SAP-ECC system for reporting.

3. Which of the following could be some examples of the impact of implementing SAP BPC? 3. A. Streamline the planning, budgeting and forecasting process. B. Increase the involvement of IT with the planning, budgeting and forecasting process. C. Increase the business user productivity. D. Full integration with the MS Office suite of products. E. Increase the business user’s integration with the data model.

4. What tasks are accomplished during full optimization in BPC for Net Weaver? 2. A. Creating a copy of the Multi Provider for the BPC Application. B. Closing the open request after posting 50,000 records. C. Updating DB statistics for the Info Cube. D. Compressing and indexing the Info Cube. E. Executing a data model analysis and alerting if the data model can be improved.

5. Performance is critical to the BPC application. The use of light and full optimization is possible. What activity is unique to a full optimization? 1. A. Zero compression during elimination. B. Check the data model. C. Close the open request. D. Update data statistics for the cube.

6. For which users does the system prevent saving templates to the company folder? 2. A. For a non admin user with the Manage Template task. B. For a non admin user without the Manage Template task. C. For a user with the Primary Admin default function task. D. For a team leader with the Manage Template task. E. For a team leader without the Manage Template task.

7. A user tries to connect to a model using the excel interface of the EPM Add-in. However, the model is not available. What could be the issue? 1. A. The Task profile is assigned to the user’s team. B. The data access profile is assigned to the user’s team. C. The task profile is not assigned to the user’s team. D. The data access profile is not assigned to the user’s team.

8. When a user tries to log in to a Model using BPC for Excel, the Model does not appear in the list of available Models the user just created. What is the problem? 1. A. The user is not created correctly. B. The Model is not created correctly. C. The member access profile is not correct. D. The task profile is not correct.

9. Which is a true affirmation? 1. A. Only user with System Admin rights can create a new model, Dimension, business rules table, work status. B. Only user with Admin rights can create a new model, Dimension, business rules table, work status. C. Only user with Primary Admin rights can create a new model, Dimension, business rules table, work status.

10. Which user account do you need to log onto SAP BPC version for Netweaver? 1. A. CMS. B. ECC. C. Windows AD. D. BW.

11. What determines the user access to BPC Applications? 2. A. Profile SAP_ALL. B. Secured dimensions. C. Member access profile. D. User/team assignment.

12. Which default function task type always includes Environment maintenance? 1. A. Administration. B. Primary. C. System. D. Secondary.

13. Which objects do not get transported in SAP BusinessObjects Planning and Consolidation for NetWeaver? 1. A. MultiProviders. B. Business Rules. C. Roles. D. Journal Templates.

14 Which of the following options can you use for drill through? 1. A. URL based on the context model. B. RFC connection based on the selected cell. C. URL based on the selected cell. D. RFC connection based on the context model.

15 For which scenario is it impossible to use the work status? 1. A. To track the progress of a planning process. B. To lock a step in a Business Process Flow. C. To allow or disallow a user to modify data. D. To lock a region of data in a Model.

16 How do you control inserting records into the database in BPC? 1. A. Via Work Status. B. Via Business Rules. C. Via Distributor and Collector. D. Via Audit.

17 What actions are possible with work status? 2. A. Using it only with entity and time type dimensions. B. Bypassing it while executing a data management package. C. Linking it to multiple hierarchies for an Application. D. Launching it from the content library.

18 User1 is the parent owner and user2 is the child owner. What happens when user2 sets a work status? 3. A. If it is set to "Manager", user1 can post a journal. B. If it is set to "All", only user1 and user2 can post a journal. C. If it is set to "Locked", neither can post a journal. D. If it is set to "Manager", user2 can post a journal. E. If it is set to "Both", user1 and user2 can post a journal.

19. What settings are possible for restricting data access for a given work state? 2. A. Administrator. B. Reviewer. C. Owner. D. Manager. E. Assistant.

20 The dimension type that is required for effecting currency translations is… 1. A. Currency Type. B. Flow Type. C. Entity Type. D. Rate Type.

21. What DIM is same for all models in consolidation setup? 1. A. Category & time. B. Category, entity, time. C. Category, group, time. D. Category, group, Time, Entity.

22 The Ownership Account contains? 2 BPC440. A. Percentages. B. Methods. C. Parent Positions. D. Entity. E. Rates.

23 Which of the following are valid for a BPC Dimension? 2. A. Equivalent to a BW Characteristic. B. Equivalent to a BW Dimension. C. Contains three types of master data. D. Can have multiple hierarchies.

24 Which of the following can you say about members of a dimension? 3. A. Members with no children are called Base-level Members. B. Members with children are Parents. C. Parents members have a calc value of NO. D. Members have properties that can be used in reporting.

25 What dimensions can be referenced to each other? 2. A. Time to Category. B. Flow to Account. C. Account to Rate. D. Intco to Entity. E. Currency to Entity.

26 What value for the property DATASRC_TYPE in the datasource dimension allows you to identify system postings? 1 BPC440. A. L - Level. B. A - Automatic. C. I - Input. D. M - Manual.

27 Which property is optional for account type dimensions? 1. A. SCALING. B. ICMATCH. C. RATETYPE. D. ACCTYPE.

28 Which implementation step is mandatory to set up an on-the-fly KPI calculation? 1. A. Add the "Formula" property to the account member. B. Execute a data management package. C. Update the "system_constants" file. D. Add the library file "mdxlib.lgl" to the options sheet of the account member.

29 What limitations exist for dimension properties in BPC 10.0 for NetWeaver? 1. A. Properties with more than 60 characters cannot be used for dimension member formulas. B. No more than 20 properties can be created for a given member. C. Property size can only be increased, not decreased. D. Properties cannot be deleted once they are created.

30 How can you add a property other than a hierarchy to a dimension? 1. A. Maintain the dimension property. B. Refresh the dimension members. C. Maintain the dimension members. D. Process the dimension.

31 What is the maximum length? 3. A. ID dimension -> 16 caracteres. B. ID dimension property -> 20 caracteres. C. Dimension member -> 32 caracteres. D. Dimension property name -> 40 caracteres.

32 What is best business practice to execute multiple iterations of a budgeting process in BPC? 1. A. Create a separate dimension. B. Create a separate property. C. Create a separate dimension member. D. Create a separate application.

33 Processing a dimension does the following. 3. A. Validate Dimension member formulas. B. Validate Hierarchy. C. Update member data into BW. D. BW Attribute change run.

34 How do hierarchies in BPC for Microsoft differ from those in BPC for NetWeaver? 1. A. They must be balanced. B. They are limited to a total of 12 per dimension. C. They are kept as separate dimensions in the database. D. They are time dependent.

35 How do you model cost center rollups by profit center when planning is done by cost center? 1. A. With a profit center property in the cost center dimension. B. With a user defined dimension for the profit center. C. With a profit center hierarchy by cost center. D. With a cost center hierarchy by profit center.

36 What implementation step is required to add a new hierarchy for a dimension member? 1. A. Insert 'PARENTH2' column after 'PARENTH1' within the dimension member sheet. B. Insert the hierarchy name into the 'APPROVALORG' web application parameter. C. Insert the hierarchy name to the 'TOPDOWN' web application parameter. D. Insert 'PARENTH2' into the dimension property list.

37 What are valid MDX expansion options? 3. A. ANY. B. BEFORE. C. LEAVES. D. AFTER. E. SELF.

38 How do you allow data entry and posting in a BPC Excel sheet? 1. A. Add a row to show the variance of the plan. B. Use a hierarchical structure for member values. C. Set the workbook option to 'Refresh automatically'. D. Use base members.

39 Which of the following are required when writing data via an excel template? 2. A. Parent members can be written to the infocube. B. Only base-level members can be written to the infocube. C. The page key range must contain base-level members for all dimension not in the rows and columns. D. The workbook option must be set to input schedule.

40. How do you change an EPM report from read only to read/write using EPM office Add-in Excel? 1. A. Switch template to an input schedule. B. Activate member recognition in the sheet options. C. Switch type from report to input form. D. Activate as input form in the sheet option.

41. What steps are required to save new members from the member sheet to the database of the admin console? 2. A. Maintain dimension members. B. Process dimension. C. Save to server. D. Change the flag 'Take system off-line'. E. Maintain dimension property.

42 When you enter a new value into a cell manually, you want the cell color to switch to a different color. How do you configure the formatting sheet to achieve this? 1. A. Select apply to local member default formula. B. Select apply for calculated member default formula. C. Select apply for imputable member default formula. D. Select apply for changed member default formula.

43 Comments are stored in 1. A.Cube. B.DSO. C.Real time cube. D.Table.

44 Which step is required to store a comment to a filled cell in an Excel pop-up in BPC for Net Weaver? 2. A. Save the Excel workbook locally. B. Enable comments in the Model parameters. C. Assign a keyword. D. Enable comments in the Environment parameters. E. Marcar en el input form para que salga el popup.

45 Only one is correct. 1. A. There can be n driver dimension or 1 model. B. There can be only 1 driver dimension for 1 model. C. There can be n driver dimensions for N Models. D. There can be max 5 driver dimensions for a single model.

46 Transaction data is described by 1. A. Infocube. B. Dimension. C. Appset. D. Dimension Members. E. Calculated KF’s.

47 Every Environment has a 2 character Environment Prefix stored in a table called UJA_APPSET_INFO. This prefix can be used in the technical name of 3. A. InfoArea. B. InfoObject. C. InfoObject Catalog. D. InfoCube. E. Multiprovider.

48 What step is required when setting up Finance or Consolidation Model compared to other Models? 1. A. Select copy options. B. Select source Model // Select source Application. C. Select Model options // Select Applicaton options. D. Modify Application.

49 Which dimension type is optional for a model? 1. A. Audit type. B. Category type. C. Time type. D. Account type.

50 What dimension types are mandatory for the Model type Financial? 2. A. Subtable. B. Category. C. Intercompany. D. Time. E. Audit.

51 Which application type is optional in BPC for consolidation of investments and currency translation? 1. A. Financial. B. Ownership. C. Rate. D. Consolidation.

52 Which dimension type can be used to track opening and closing balance? 1 BPC440. A. Intercompany. B. Audit. C. Category. D. Subtable (Flow). E. Group.

53 What program can you use to validate the consistency of an environment after copying the standard environment? 1. A. UJA_DATA_CHECKER. B. UJA_COPY_APPSET. C. UJA_APPSET_INFO. D. UJT_CHECK_TABLE_ENTRIES.

54 Which of the statements below are correct in regards to BW? 2. A. InfoCubes are made up of Fact and Dimension tables. B. A BW Dimension table is exactly the same as an Business Planning and Consolidation Dimension. C. BW Characteristics have three potential types of master data. D. There are two main types of InfoObjects: Catalogs and InfoAreas.

55 What is BW object equivalent to a BPC Model? 1. A. Infocube. B. Infoobject. C. DSO. D. Infoarea. E. Table.

56 What object in SAP BW is an equivalent to an Application in SAP BPC for NetWeaver? 1. A. A real-time InfoCube that contains transactional data. B. A basic InfoCube that contains transactional data. C. A DataStore Object that contains transactional data. D. A MultiProvider that creates a join of different data tables.

57 SAP guidelines recommend that you make what changes directly in SAP BW on BPC-generated objects? 1. A. Switch case sensitivity off. B. Change the data lengths of characteristics. C. Change no objects at all. D. Switch hierarchies to time dependent.

58 Which package group is customer-specific in SAP BusinessObjects Planning and Consolidation for NetWeaver? 1. A. Financial Processes. B. Data Management. C. Reporting Management. D. System Administrative.

59 You want to use a data manager package to load data from an InfoProvider in BPC for NetWeaver. What is supported? 2. A. Loading data from an InfoCube, but not from a DataStore Object. B. Using JavaScript in the transformation files. C. Mapping only one key figure to the target data although source data has multiple key figures. D. Selecting data pertaining to specific master data values to load.

60 Which of the following is possible in the data loading process in BPC for NetWeaver? 1. A. Using multiple conversion files for a single dimension without additional coding. B. Using the download function to move files from the local hard drive to the data file folder. C. Using a transformation file without a conversion file. D. Using Visual Basic Script in the Data Manager.

61 After running a data manager package link with 5 packages, you notice that package 3 failed. What happened to the other packages? 1. A. Package 1,2,4 and 5 ran. B. Package 1,2 ran, packages 4 and 5 did not ran. C. Packages 1 and 2 were rolled back, package 4 and 5 ran. D. Packages 1 and 2 were rolled back, package 4 and 5 did not ran.

62 Which of the following objects are required when executing an upload of data into BPC using a data manager process? 2. A. Conversion file. B. Script logic. C. Transformation file. D. Transformation rule. E. Process chain.

63 Which of the following tasks can be performed as a background job Via process chain? 1. A. Copy Model. B. Modify Model. C. Optimize Model. D. Copy Environment.

64 Which parameter in the options list of a transformation file is available only in BPC for the SAP NetWeaver technology platform? 1. A. DELIMITER. B. SELECTION. C. VALIDATERECORDS. D. AMOUNTDECIMALPOINT.

65 A transformation file has the option CONVERT_INTERNAL = NO. The records pertaining to account 0] ACCPAY should not be loaded through your data management package. How do you configure the conversion file? 1. A. Enter ACCPAY in the external column and %EXTERNAL% in the internal column. B. Enter ACCPAY in the internal column and *SKIP in the external column. C. Enter ACCPAY in the external column and *SKIP in the internal column. D. Enter ACCPAY in the internal column and %EXTERNAL% in the external column.

66 A data load of a data management package shows an error message stating that the number of rejected records is 700. To which value do you need to set the MAXREJECTCOUNT in the transformation file so that the data is loaded regardless of the number of rejected records? 1. A. 0. B. 700. C. -1. D. 701.

67 Which section of the transformation file would be used to assign BW Characteristics to BPC Dimensions? 1. A. Options. B. Mapping. C. Conversion. D. External and Internal.

68 Which folder must store the conversion files? 1. A. Company. B. C: Drive. C. Wizard. D. Books.

69 Which data management option is required to load transaction data from a file to an SAP BusinessObjects Planning and Consolidation Application? 1. A. Run the data management package. B. Organize the package list. C. Download the data file. D. Maintain data management.

70 In SAP BusinessObjects Planning and Consolidation for NetWeaver, the language texts are missing. How do you fix this issue? 1. A. Import transaction data. B. Load data from the InfoProvider. C. Refresh dimension members. D. Import master data descriptions.

71 You want existing records to be deleted first before writing new records. What option do you choose while running a data management package? 1. A. Merge. B. Replace and Clear. C. Clear. D. Clear and Append.

72 What are the Out of the Box solution for loading the master data load? 2. A. Load Master Data from SAP ERP directly into BPC, version for SAP NetWeaver. B. Load Master Data from SAP NetWeaver BI Characteristics Directly Using Data Manager. C. Flat file by Data Manager. D. Flat File in BW.

73 What are the Out of the Box solution for loading the transaction data load? 2. A. Load transaction data from SAP NetWeaver BI using an Open Hub destination that provides flat files to data manager (Delta Load). B. Load transaction data from SAP NetWeaver BI InfoCubes directly using data manager custom process type (Delta Load). C. Load transaction data via flat file via SAP NetWeaver BI dataflow . D. Load transaction data via UD Connect (SAP NetWeaver BI dataflow). E. Load Transaction Data via Flat File using BPC Data Manager.

74 What activities are possible while running a data management package in BPC for NetWeaver? 3. A. Loading data from Info Providers. B. Importing master data attributes. C. Importing master data hierarchies. D. Importing transaction data. E. Importing master data descriptions.

75 What solution for uploading master data into BPC for NetWeaver requires customer-specific process types? 1. A. Loading data directly into the dimension member sheet. B. Loading data via a flat file using BPC Data Manager. C. Loading data via a flat file using SAP BW. D. Loading data from a SAP BW InfoObject into a BPC dimension using BPC Data Manager.

76 What solution for uploading transactional data into BPC for NetWeaver requires customer-specific process types? 1. A. Loading data in delta mode from a BW InfoCube using BPC Data Manager. B. Loading data from a flat file using BPC Data Manager. C. Loading data from a DataStore Object using BPC Data Manager. D. Loading data in delta mode from BW using an Open Hub destination that provides flat files for BPC Data Manager.

77 Which of the following are required for an import? 1. A. Conversion. B. Flat File. C. Transformation. D. Dynamic Template.

78 What is missing in this code? *RUN_PROGRAM CURR_CONVERSION CATEGORY = %C_CATEGORY_SET% TID_RA = %TIME_SET% RATEENTITY = GLOBAL ENTITY = %ENTITY_SET% *ENDRUN_PROGRAM. A. CURRENCY = %RPTCURRENCY_SET%. B. RATEENTITY = %ENTITY_SET%. C. ACCOUNT = %ACC_SET%. D. Rate type is missing. E. TCURR table is missing.

79 When validating the 'FXTrans.LGF' file, you get a validation error stating that the currency dimension is missing a property. What property is missing? 1. A. PARENT_GROUP. B. GROUP_CURRENCY. C. STORE_GROUP_CURR. D. CURRENCY_TYPE.

80 What is missing in the script logic on the screenshot in BPC for NetWeaver? 1. A. Logic for entity type dimension. B. Keyword %CURRENCY_SET%. C. Logic for account type dimension. D. Logic for currency type dimension.

81 Which dimension type is optional for a model? 1. A. A-Account. B. T-Type. C. D- Audit. D. C-Category.

82 You execute the following Script Logic Logic1.lgf by running a data manager package, without transferring any further parameters and without using default logic. 1 *WHEN ACCOUNT *IS ACCOUNT1 *REC (FACTOR=1.5, ACCOUNT=ACCOUNT2) *ENDWHEN *COMMIT What is the scope of the calculation?. A. Only input schedule. B. ACCOUNT1 and ACCOUNT2. C. Only current view. D. All data within the database.

83 What value is assigned to the ACCOUNT3 with the following Script Logic? 1 *WHEN ACCOUNT *IS ACCOUNT1, ACCOUNT2 *REC (FACTOR=1, ACCOUNT=ACCOUNT3) *ENDWHEN *COMMIT. A. Sum of ACCOUNT1 and ACCOUNT2. B. Difference of ACCOUNT1 and ACCOUNT2. C. Quotient of ACCOUNT1 and ACCOUNT2. D. Product of ACCOUNT1 and ACCOUNT2.

84 What transaction code allows you to access the 'system_constants.lgf' and 'MDXlib.lgf' files in BPC for NetWeaver? 1. A. UJFS. B. UJ00. C. UJKT. D. UJR0.

85 You use the DESTINATION_APP keyword in your script logic. If the source model contains fewer dimensions that the target, which operator do you use to derive the missing dimensions? 1. A. *XDIM_MEMBERSET. B. *ADD_DIM. C. *SKIP_DIM. D. *RENAME_DIM.

86 To what is the term 'ROUND' in the script logic of the attached figure referring? 1. A. Parameter used in the BAdI. B. Filter value in the BAdI. C. Technical name of the BAdI. D. Enhancement spot of the BAdI.

87 For the budgeting process, you need to extrapolate a base amount across 12 months with a growth factor of 3%. What modeling function do you use? 1. A. TREND. B. FORECAST. C. SPREAD. D. WEIGHT.

88 Which function do you use to display a dimension name? 1. A. EPMDimensionOverride. B. EPMDimensionProperty. C. EPMDimensionList. D. EPMDimensionType.

89 A KPI should be calculated centrally, on-the-fly, and be available to all reports. Which implementation option do you choose? 1. A. Worksheet Logic. B. Business Rules. C. Dimension Member Formulas. D. Script Logic.

90 Which settings do you need to make for the Source Account to calculate the annual net income (ANI) for the liability account? 1 BPC440. A. Revenue and Cost, Destination Account = ANI, reverse sign. B. Expense, Destination Account = Revenue and ANI, reverse sign. C. Revenue and Cost, Destination Account = ANI, do not reverse sign. D. Expense, Destination Account = Revenue and ANI, do not reverse sign.

91 What components are needed to run business rules? 3 BPC440. A. Business Rule. B. Dimension Logic. C. Conversion File. D. Data Manager Package. E. Script Logic.

92 Which 2 functions can be used using script logic and business rules? 2 BPC440. A. Carry Forward. B. Validation. C. Automatic adjustments. D. Currency Translation.

93 Which of the following application options are common between Finance and Consolidation Models? 3 BPC440. A. Currency Conversion. B. Calculation. C. Intercompany Booking. D. Intercompany Elimination. E. Controls. F. US Elimination. G. Opening Balance.

94 Which of the following are standard business rules? 3 (esta no tiene mucho sentido) BPC440. A. Currency Conversion. B. Account Transformation. C. Intercompany Booking. D. Automatic Adjustment. E. Carry-forward. F. US Elimination.

95 For which calculation do you have to use a different implementation method than Business Rules? 1 BPC440. A. Automatic adjustment. B. Account transformation. C. Allocation. D. Currency conversion.

96 Which fields are required to eliminate the investment when using the All Formula? 2 BPC440. A. Source Account. B. Destination All Account. C. Destination Group Account. D. Destination Equity Account. E. Destination Minority Interest.

97 What is entered in the destination group account when setting the AR/AP intercompany elimination business rule with the automatic adjustment business rules? 1 BPC440. A. Same value as in the destination minority account. B. Intercompany accounts receivable account. C. Intercompany accounts payable account. D. PLUG account.

98 What dimensions are used to configure the carry forward business rule? 3 BPC440. A. Time dimension. B. Flow dimension. C. Entity dimension. D. DataSource dimension. E. Account dimension.

99 What currency type dimension is required for consolidation of investment? 1 BPC440. A. RPT currency. B. groups. C. input currency. D. transaction currency.

100 What dimension property is required for consolidation of investments? 1 BPC440. A. FIRST_CONS_DATE in the groups dimension. B. INTCO in the entity dimension. C. ENTITY in the groups dimension. D. OWNER in the entity dimension.

101 What is entered in the destination group account when replacing the US elimination business rule with the automatic adjustment business rule? 1 BPC440. A. Intercompany accounts receivable account. B. Same value as in the destination minority account. C. Value of the ELIMACC property of account dimension. D. Intercompany accounts payable account.

102 What Application option do you have to select when you create a Model to make intercompany eliminations? 1 BPC440. A. Account Transformation. B. Validation Rules. C. Balance Carry Forward. D. Automatic Adjustment.

103 Your customer wants to use a unique business rule to translate currency for selected entities. Which property do you set for the selected entities to meet this requirement? 1 BPC440. A. GROUP_CURRENCY. B. RATETYPE. C. CURRENCY_TYPE. D. FX_TYPE.

104 Your customer wants to load certain accounts with both local and reporting currencies without doing a currency translation. Which expression in the formula of the business rule for currency conversion can you use to achieve this? 1 BPC440. A. [NOTRANS]. B. [AS_IS]. C. [COPYLC]. D. [END].

105 Currency translation calculations typically work as follows: 2 BPC440. A. Opening balance is bought in at the END rate plus the change in the END rates multiplied by the closing LC value. B. The change is bought over at the average rate plus the difference between the END and AVG rate multiplied by the LC. C. The closing balance is valued at the LC times the END rate. D. Translation differences can be written to separate flow members. E. Translation differences are also written to the journal document DSO.

106 What value is used in the destination flow column of the currency conversion business rule when there is no sub table type dimension in the Model? 1 BPC440. A. Same as in the destination account column. B. Same as in the source account rate type column. C. Same as in the source flow column. D. Same as in the formula column.

107 The exchange rate is defined as 1 EUR = 1.4 USD. In the Finance Application, the values are incorrectly calculated based on the inverse ratio. What dimension will you look at to fix the problem? 1 BPC440. A. Account. B. RptCurrency. C. InputCurrency. D. Groups.

108 A customer wants to use special exchange rates for only 2 out of 160 entities when doing currency translation. What dimension and what property do you use for that? 1 BPC440. A. Currency dimension - CURRENCY TYPE property. B. Account dimension - ACCTYPE property. C. Account dimension - RATETYPE property. D. Entity dimension - FX_TYPE property.

109 Which properties are required to carry out currency translation for legal consolidation? 2 BPC440. A. DIMLIST in the account type dimension. B. FX_DIFFERENCE_ONLY in the category type dimension. C. RATETYPE in the account type dimension. D. STORE_GROUP_CUR in the currency type dimension. E. CURRENCY in the entity type dimension.

110 Which properties are required to carry out currency translation for legal consolidation (models)? 2 BPC440. A. CURRENCY in the entity type dimension. B. RATETIPE in the account type dimension. C. RATE_YEAR in the category dimension. D. RATE_ PERIODIC in the category dimension.

111 Data is loaded only in the 'F_OPE' flow/subtable. When executing the currency translation for the first time, the CTA_ACT in F_CTA is empty. What is the problem with the logic? 1 BPC440. A. The user needs to execute the task one more time. B. The formula is incorrect and needs to be modified. C. The logic is correct but the system is doing something wrong. D. The data is not available for F_TMP3 flow.

112 You want to enable users to resolve the “out of balance” issue when blocking controls fail. When you configure the controls, what do you attach to the blocking controls? 1 BPC440. A. A web report. B. An input schedule. C. An excel report. D. A journal.

113 All configurations in UJ_VALIDATION is _____Specific 1. A. Model. B. Environment. C. Dimension. D.DSO (DataSource Object).

114 While setting up validations in UJ_VALIDATIONS, we configure 2. A. Value ranges. B. Use non-existing members. C. Only = sign. D. We can include multiple values.

115 You can turn validations on or off by 3. A. Journals. B. Manual Planning. C. BPF. D. Data Manager.

116 Which of the following is/are true with regards to validations? 3. A. All validations configuration can be transported. B. Validations integrate with Activity Audit. C. Authorization is controlled by access to task profiles. D. Last changed date and time is stored in tables. E. Authorization is controlled by access to transaction code S-TRANS.

117 What is a restriction for BPC validation rules in BPC for NetWeaver? 1. A. A BPC validation rule cannot use a BAdI implementation. B. Multiple BPC validation rules cannot be applied to multiple dimension members of a dimension. C. Multiple BPC validation rules cannot refer to the same dimension member. D. A BPC validation rule cannot refer to multiple driver dimensions.

118 Where is archived audit data stored in BPC for the SAP NetWeaver technology platform? 1. A. In a flat file. B. In a BW InfoCube. C. In a BW table. D. In a DataStore Object.

119 Where are the archived reports stored in BW? 1. A. Cube. B. SAO. C. Write DSO. D. Real Time cube. E. Tables.

120 Where do you set up the data audit for transactional data? 1. A. BPC Admin. B. BPC excel interface. C. Web Admin parameters at environment level. D. Web Admin parameters at model level.

121 For which dimension type can you activate a data audit trail for a model? 1. A. Entity. B. Time. C. Account. D. Category.

122 Where do you set the data audit to capture transactional data changes? 1. A. At Environment level in Admin Console. B. At Environment level in Web Admin. C. At Model level in Admin Console. D. At Model level in Web Admin.

123 Where do you set the data audit to capture transactional data changes? 1. A. At Appset level in Admin Console. B. At Appset level in Web Admin. C. At l Application level in Admin Console. D. At Application level in Web Admin.

124 What interfaces can you use during the step Define Action when setting up a BPF? 1. A. Manage Books, BPC Web, BPC for Word. B. BPC Administration, BPC for Excel, BPC for Word. C. Data Audit, BPC for Excel, BPC for PowerPoint. D. Journal, BPC for Excel, BPC for Word.

125 What are the required dimensions to create the BPF instances? 1. A. Time. B. Time and category. C. Category. D. Entity, category and Time.

126 Who is notified when a step is completed using Business Process Flow? 1. A. BPF Reviewer. B. BPF Manager. C. BPF Owner. D. BPF User.

127 Who is notified when an activity is submitted in the Business Process Flow? 1. A. Reviewer. B. Manager. C. Performer. D. Owner.

128 A step is re-opened? What is the next step status? 1. A. Open. B. Re-open. C. Pending. D. Delayed. E. Approved.

129 What is the consequence in BPC for Net Weaver when updating the web admin parameters without entering the required parameters? 1. A. Warnings. B. Nothing. C. Crashes. D. Errors.

130 What tasks can be done using the Web Administration? 2. A. Changing documents type but not document subtype. B. Activating but not deactivating auditing. C. Adjusting the version number of a report template. D. Setting up file types.

131 Which business rules are used in the consolidation monitor? 3 BPC440. A. Account-based calculations. B. US eliminations. C. Eliminations and adjustments. D. Currency translation. E. Global definitions.

132 What models do you need for Consolidation as mandatory application? 3 BPC440. A. Legal. B. Ownership. C. Rate. D. Intercompany Matching. E. Finance.

133 The legal application is set to YTD storage. What would a BPC report display compare to a database view? 2. A. If the measure is set to PERIODIC, both inventory and equity account would match. B. If the measure is set to YTD, an investment account would match but a liability account would not. C. If the measure is set to YTD, a goodwill account would match but minority interest would not. D. If the measure is set to PERIODIC, cash would match but not revenue. E. If the measure is set to YTD, both revenue and cash accounts would match.

134 You have created the controls and a user has tested them for the current period. However, the user does not see the controls for the following period in the controls monitor. How do you resolve this issue? 1 BPC440. A. Grant authorization to the user for view the controls for the next period. B. Change work status in the consolidation monitor for the next period. C. Assign the control level to the following period. D. Assign the control set to the following period.

135 Company D owns 91% of A, 51% of B, and 49% of C. Which company can use the equity method? 1. A. B. B. C. C. A. D. D.

136 What needs to be run before ownership elimination? 1 BPC440. A. Account transformation. B. Carry forward. C. Currency translation. D. Intercompany booking.

137 How many journal templates are in a model. 1 BPC440. A. N no of journal templates. B. Only one journal template per model. C. Based on the no of dimensions. D. Journal templates are app set specific.

138 What do you need to consider when using journals? 2 BPC440. A. Journal authorizations are only governed by the task 'create journals'. B. Journals are copied when you copy one environment to another. C. Journals are supported in the work status configuration. D. Journals can be posted either manually or automatically but not both.

139Which of the following journal parameters are available for a model? 2 BPC440. A. Enforce balance journal. B. Balanced by entity. C. Balanced by currency. D. Allow journals to be reopened.

140 You use the INC account type for revenue accounts and the EXP account type for expense accounts. What is displayed in a planning and consolidation report when incomes are stored as negative values and expenses are stored as a positive values (dimensions)? 2 BPC440. A. Positive revenue values. B. Negative expense values. C. Positive expense values. D. Negative revenue values.

141 For which of the followings models you have to create at least two “drivers” type model? 1. A. Standard. B. Ownership. C. Consolidation. D. Financial.

142 When using US eliminations, which dimensions must you include in the model? 2 BPC440. A. Entity. B. Group. C. Time. D. Flow.

143 Which of the following tasks can you perform using the Consolidation Monitor? 2 BPC440. A. Run ownership calculation. B. Run currency translation. C. Run controls. D. Run consolidation. E. Run Data Manager packages.

144 Which the following methods does the Shared Query Engine (SQE) use to retrieve data from database? 2. A. Axis query. B. Cell query. C. RSDRI query. D. MDX query.

145 When executing the ownership calculation you receive an error message. You therefore analyze the group/entity structure in the attached screenshot. Which method type is missing in the consolidations method? 1 BPC440. A. H – Holding. B. G – Global. C. P – Proportional.

146 A customer wants to load certain accounts with both local and reporting currencies without doing a currency translation. What expression in the formula of the business rule for currency conversion would leave the reporting currency value unchanged? 1 BPC440. A. [AS_IS]. B. [NOTRANS]. C. [COPYLC]. D. [END].

147 What dimension types are mandatory for the Application type Financial? 2. A. I–Intercompany. B. T–Time. C. S–Subtable. D. D–Audit. E. C–Category.

148 Which of the following options can you use for drill through? 1. A. URL based on the current view. B. RFC connection based on the selected cell. C. URL based on the selected cell. D. RFC connection based on the current view.

149 During testing you notice that account descriptions are missing. How do you resolve this issue? 1. A. Import master data descriptions. B. Refresh dimension members. C. Import transaction data. D. Import master data hierarchies.

150 What settings do you need for Source Account to calculate the liability account 'annual net income' (ANI)? 1. A. Expense, Destination Account = Revenue and ANI, do not reverse sign. B. Revenue and Cost, Destination Account = ANI, do not reverse sign. C. Revenue and Cost, Destination Account = ANI, reverse sign. D. Expense, Destination Account = Revenue and ANI, reverse sign.

151 The consolidation monitor displays a blank screen for the current period although the previous period has been displayed property. What could be the reason for this? 1. A. No exchange rate records exist. B. No master data exist. C. No trial balance exist. D. No ownership records exist.

152 You want to format your account members dynamically in an EVDRE report. In which column do you have to enter the value 'NUMBERFORMAT=ACCOUNT.FORMAT'? 1. A. PARAMETERS. B. CRITERIA. C. FORMAT. D. USE.

153 Where do you change a BPC report to an input schedule? 1. A. In the PageKeyRange. B. In the EVDRE report. C. In the Web Admin parameter. D. In the workbook options.

154 What fields are required to eliminate the investment when using the 'All Formula'? 2 BPC440. A. Source Account. B. Destination Group Account. C. Destination Equity Account. D. Destination Minority Interest. E. Destination All Account.

155 What Application option do you have to select when you create an Application to make intercompany eliminations? 1. A. Account Transformation. B. Validation Rules. C. Balance Carry Forward. D. Automatic Adjustment.

156 Which calculation uses script logic exclusively? 1. A. Elimination. B. Currency Translation. C. Allocation. D. Reclassification.

157 What step is required when setting up Finance or Consolidation Application compared to other Applications? 1. A. Select copy options. B. Select source Application. C. Select Application options. D. Modify Application.

158 What program can you use to validate the consistency of an application set after copying the standard application set? 1. A. UJA_DATA_CHECKER. B. UJA_COPY_APPSET. C. UJA_APPSET_INFO. D. UJT_CHECK_TABLE_ENTRIES.

159 Which dimension type is optional for an Application? 1. A. Data source type. B. Category type. C. Time type. D. Account type.

160 For which dimension can you activate a data audit trail for an Application? 1. A. Category. B. Account. C. Time. D. Entity.

161 What are the steps required to configure controls? 3 BPC440. A. Work status. B. Create control sets. C. Managerial drill. D. Enable work status for the model. E. Assign security task for control.

162 Which hierarchy is used in the consolidation monitor? 1 BPC440. A. Group Hierarchy. B. Entity Hierarchy. C. Intercompany-based hierarchy. D. Ownership- based hierarchy.

163 For which user does the system prevent saving templates to the company folder? 2. A. For a team leader with the Manage Template task. B. For a non admin user with the Manage Template task. C. For a user with the Primary Admin default function task. D. For a team leader without the Manage Template task. E. For a non admin user without the Manage Template task.

164 Which default function task type always includes Appset maintenance? 1. A. Administration. B. Primary. C. System. D. Secondary.

165 Which step is mandatory if you want to check the data integrity of the incoming records? 1 BPC440. A. Configuration controls. B. Activate the validations for the environment. C. Assign driver dimension to the validation rule. D. Implement a BAdi.

166 Your customer wants to load certain accounts with both local and reporting currencies without doing a currency translation. Which expression in the formula of the business rule for currency conversion can you use to achieve this? 1 BPC440. A. [NOTRANS]. B. [AS_IS]. C. [COPYLC]. D. 1.

167 How do you configure the Data Manager package to execute a specific logic script file? 1. A. Define the logic script file as a variable in package parameters. B. Define the logic script file in the process chain. C. Define the logic script file in the package link. D. Define the logic script file in the advanced package settings.

168 Which of the following steps are mandatory if you want to perform a transport from the development system to the …. 2. A. Run a full optimization. B. Run the transport-Create Request (UJBPCTR) transaction. C. Take the environment offline. D. Select Planning and Consolidation objects in BW Trasnport Collector.

169 You have defined the global definition in the business rules. Which of the following ownership accounts must contain data if you want to perform the ownership “calculation” 2 BPC440. A. POWN_SYS- Percent Ownership_System Calculation. B. PCTRL- Percent Control. C. PCON_SYS – Percent Consolidation _System Calculation. D. POWN- Percent Ownership. E. PCON-Percent Consolidation.

170 What information is needed when you configure the interface between EPM OfficeAdd-In Excel and Bex Query to enable the BW drill through? 3. A. The FILTER_IOBJNM and FILTER_VALUE parameters. B. The URL of the BEx Query. C. The technical field names of the dimension. D. The OKCODE parameter. E. The technical names of the InfoObjects.

171. Which of the following values can you use in the destination flow to configure the currency translation business rule? 2 BPC440. A. Base level members. B. Blank. C. Descendents. D. Property values.

172. Which of the following business Rules can you use in a financial models? 1. A. method-based multipliers. B. method s. C. Elimination and adjustment. D. Automatic Adjustment. E. Currency translation.

173 How to set a work status in the consolidation monitor. 2. A. Only refresh. B. Choose an entity and click work status. C. Click refresh to see the update status. D. Changes in data. E. Choose work status.

174 What is entered in the group account when you configure AR/AP intercompany eliminations and adjustment business rule? 1 BPC440. A. the intercompany AR account. B. the intercompany AP account. C. the same value as in the destination minority account. D. the offset account.

175 What are the components of Process Template Components? 3. A. Instance Dimensions. B. Flat file control. C. Process Monitors. D. Costs.

176 What are the sections related to EPM formatting sheet 2. A. Heading. B. Checkboxes. C. Editing. D. Data and Use column/ cells. E. Subtitle.

177 Find out the Environment models from the following. 3. A. Political Planning. B. HR Planning. C. Financial Reporting. D. Sales Planning. E. Social Responsibility.

178 Running control could include the following steps. Identify them. 2. A. Hyper links. B. Contents. C. Review Control data. D. Dimensions. E. Run Control.

179 What is an advantage of using Web reports over of EPM reports? 1. A. web reports use a thin client. B. web reports support multiple dimensions in the rows and columns. C. web reports can access data from multiple sources. D. web reports support EPM functions.

180 Which of the following steps do you need to follow to configure data audit? 1. A. add a parameter to Data Manager packages. B. add a global parameter in customizing (SPRO). C. activate the collection of data by model. D. activate the collection of data by environment.

181 Identify the 3 different types of Logic. BPC440. A. Stored Output. B. Front-End. C. Models. D. Rate type. E. On the fly.

182 How to use a consolidation monitor? 3. A. Business contents. B. Control status. C. Work status. D. Consolidation status. E. Administration.

183 Three types of parameters are used in BPC, identify them. 3. A. System Parameters. B. Conceptual parameters. C. Analytical parameters. D. Configuration parameters. F. Functional parameters.

184 What does a consolidation model contains? 2 BPC440. A. Only contents. B. Accounts. C. Proactive data. D. Balance sheet data. E. Income statement.

185 You want to be able to insert comments in an Excel popup in SAP BusinessObjects Planning and Consolidation version for NetWeaver. What do you have to enable? 2. A. The Enable Comments indicator in model features. B. Model parameters in Customizing (SPRO). C. Environment parameters in Customizing (SPRO). D. The Show as Microsoft Excel Comments checkbox.

186 Which is not a part of Developmental Process? Identify from the following. 1. A. Business Content. B. Manage a Drill. C. Naming conventions. D. Data Flow.

187 List the key features of business process flows, from the following. 2. A. Characters. B. Logic. C. Benefits. D. Margin. E. Cost.

188 You want to specify a model and dimension members that are used every time you create WEB reports. Where do you set this values? 1. A. Workspace. B. Preferences. C. EPM Context. D. Context default.

189 You want to use specific default values when you add data manually from the web client. How can you achieve this? 1. A. specify the default members for reporting. B. select the "Use as Input Form" option. C. specify the default members for data input. D. select the "activate Member recognition" option.

190 What are the two deployment scenarios? 2. A. Dispatch only. B. Services only. C. Development to production. D. Only Production. E. Targets only.

191 How to reset the consolidation status? 1 BPC440. A. Changes in master data. B. All over changes. C. Dim list changes. D. Set up changes.

192 Find out Step which is not taking part in The Information Gathering Process1. A. Presentations. B. Enabling EMP. C. Preparations. D. Matching.

193 Name the folder that the users has access to depend his/ her access account 1. A. Team. B. Membership. C. Activity. D. None.

194 Where do you activate the parameter that is used to automatically refresh the input form when you open it (input forms and report)? 1. A. EPM - User option. B. EPM - context options. C. EPM - sheet options. D. EPM - Command display options.

195 Which of the following rules are based on business rules (models)? 3. A. Allocation. B. Elimination and adjustment. C. Driver-based calculation. D. Account-based calculation. E. Currency translation.

196 Which prerequisites must be fulfilled if you want to display planning and consolidation data in dashboard designer? 2. A. Runtime connection must exist between the planning and consolidations system and the dashboard. B. An EPM must be created. C. A BPC data grid must be used in the dashboard. D. A list of models must be generated in the EPM report.

197 Which steps are mandatory if you want to implement the work status? 3. A. define the owner property in the owner dimension. B. define the reviewer property in the owner dimension. C. enable data locking in the model. D. enable data audit for the model. F. define the least one hierarchy in the owner dimension.

198 Which of the following dimension type can be used as reference dimension? 2. A. D Audit. B. S Subtables. C. G Group. D. T Time. E. E Entity.

199 Which dimension type can you use for the context when you use the control monitor in a Financial model? 2. A. R Currency. B. G Group. C. E Entity. D. T Time.

200 Which dimensions can you use to configure the “carry-forward business rule”? 3 BPC440. A. Flow. B. Time. C. DataSource. D. Account. E. Entity.

201 Which function do you use to calculate variances? 1. A. EPM Comparison. B. EPMExecuteAPI. C. EPMMemberOffset. D. EPMMemberProperty.

202 You want to set up a consolidation model. Which of the following dimensions should be the same for consolidation, rate and ownership models? 2. A. Data source. B. Category. C. Account. D. Entity. E. Time.

¿Qué herramienta utilizamos para pasar de una imagen a otra, entre las opciones? (solo 1 respuesta correcta). Cambiar a base member en el contexto. Keep /exclude. Expand/Collapse.

Se plantea la situación de ir a grabar datos en un report y no nos dejaba porque no se habían metido los datos en un base member, por lo que nos decía como podíamos solucionarlo (2 respuestas correctas): Expand para ver los childrens (estaba redactado de otra manera). Member selector en el EPM Context. Pepinillos en vinagre. Vacaciones en la Manga del Mar Menor.

¿qué opción tenemos para deshacer hasta los últimos 5 cambios en un report (1 respuesta correcta)?. Undo/Back. Exclude.

¿Dónde se integran todos los datos (1 respuesta correcta)?. Model. Dimension. Property. Members.

What values is assigned to the ACCOUNT 3 with the folllowing SCRIPT? WHEN ACCPOUNT IS AACOUNT 1=10, ACCOUNT 2 =20 REC (FACTOR 2, ACCOUNT =ACCOUNT 3) ENDWHEN COMMIT. 10. 20. 30. 60.

You select a parent in the detailed section of the control definition. Which of the following options do you choose to ensure that the control will be executed for each member of the selected parent? 1. Equation type. Control level. Breakdown dimension. Threshold tolerance.

You want to create a PD book that contains PDF files by cost center for the current year based on a EPM report, and publish it in the library. Which of the following steps are required when you create the publication template?. assign a time variable to the publication template. include the cost center dimension in the page axis in the publication template. assign the EPM report to the publication template. include the cost center dimension in the fixed keys in the publication template. assign the cost center to the variable members of the publication template.