Process for importing flat file data. Select from the following choose the correct answer
- A . Storing files.
- B . BExecute planning
- C . Upload the file on to the server and preview the data.
- D . Data manager
What EV functions can support the posting process of an Input Schedule? There are 2 correct answers to this question.
- A . EVAPP
- B . EVSND
- C . EVDRE
- D . EVBET
- E . EVGTS
Which of the following interfaces can you use when you define actions using the business process flow templates. (3)
- A . EPM Office Add-in word
- B . Journals
- C . Planning and consolidation administration
- D . BWApllication server
- E . EMP Office Add-in Excel
Which of the following model-specific business rules requires the environment-specific business rules?
- A . Currency translation
- B . US Eliminations
- C . Eliminations and adjustments
- D . Account-Based Calculations
Which EV expansion option is used to return the current member and its dependents? Please choose the correct answer.
- A . EVDPS
- B . EVBAS
- C . EVDEP
- D . EVBSS
What does a Dynamic Filter do? (1)
- A . Just a process
- B . None
- C . Use members in a referenced cell as filter values.
- D . ADD-IN
Which of the following rules are based on business rules (models)? 3
- A . Account-based calculation
- B . Driver-based calculation
- C . Elimination and adjustment
- D . Allocation
- E . Currency translation
When you create a new model from an existing model, which items can be copied? Note: There are 2 correct answers to this question.
- A . Transaction data
- B . Data Manager packages
- C . Control definitions
- D . Journal templates
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 . Positive expense values
- C . Negative revenue values
- D . Negative expense values
Which of the following tasks can you perform using the Consolidation Monitor? 2 BPC440
- A . Run ownership calculation
- B . Run Data Manager packages
- C . Run controls
- D . Run currency translation
- E . Run consolidation
Script Logic and Calculations
You are testing script logic to perform a loop aver months
You save budget data for months 2018.01 to 2018.06.
*XDIM MEMBERSET CATEGORY-BUDGET *XDIM_MEMBERSET TIME- %TIME_SET% *XDIM_MEMBERSET P_COSTELEMENT = LABOR
‘WHEN P_COSTELEMENT *IS LABOR
"FOR %COUNTER%= 1.2.3.4.5.6,7 8.9.10, T1.12
*REC(EXPRESSION =
%VALUE%(12*2. TIME=TMVL(%COUMTER%.%TIME_SET%),CATEGORY=FORECAST)
*NEXT
*ENDWHEM
When this script logic executed, what months receive data?
- A . 2016.07 to 2018.12
- B . 2019.01 to 2019.06
- C . 2018.07 to 2019.06
- D . 2019.01 to 2019.12
What value for the property DATASRC_TYPE in the datasource dimension allows you to identify system postings? (1)
- A . L – Level
- B . I – Input
- C . A – Automatic
- D . M – Manual
58. 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 . PCON-Percent Consolidation
- B . PCTRL- Percent Control
- C . PCON_SYS – Percent Consolidation _System Calculation
- D . POWN_SYS- Percent Ownership_System Calculation
- E . POWN- Percent Ownership
Identify the action required for the value of Planning and Consolidation (1)
- A . Operations
- B . Marketing
- C . Analyze
- D . Directing
Which of the following steps are mandatory if you want to perform a transport from the development system to the production system(administration)? (2)
- A . run a full optimization
- B . select planning and consolidation objects in the BW transport collector
- C . take the environment offline
- D . run the transport-create request (UJBPCTR) transaction
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 . 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
You have automated ownership eliminations by using the BPC business rules and ownership data. Your requirement is to use the same rule for both purchase and equity subsidiaries. The ownership in one of the subsidiaries went from 45 to 55 percent .
What changes should you make in the ownership manager for this subsidiary? (1)
- A . PCON is changed to 55
- B . Method is changed to New
- C . Method is changed to ‘Holding’
- D . PCON is changed to 100
To acid custom dimensions automatically to BPC Optimized structures, what do you use?
- A . Model Extension Tool
- B . RTC Modeling Tool.
- C . Planning Application Kit
- D . BW Modeling Tool.
Which of the following application options are common between Finance and Consolidation Models? 3 BPC440
- A . Calculation
- B . Currency Conversion
- C . Opening Balance
- D . US Elimination
- E . Intercompany Booking
- F . Controls
- G . Intercompany Elimination
What benefits does BPC offer to a corporation? 2 correct answers BPC440
- A . It enables compliance with IFRS and SOX.
- B . It integrates with the Microsoft Office Suite including Word, Excel, and PowerPoint.
- C . It enables you to drill through to the SAP-ECC system for reporting.
- D . It gives the IT department control over budgeting and planning functions.
What dimensions are used to configure the carry forward business rule? 3 BPC440
- A . DataSource dimension
- B . Account dimension
- C . Time dimension
- D . Entity dimension
- E . Flow dimension
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 . [COPYLC]
- B . [END]
- C . [NOTRANS]
- D . [ASJS]
What step is required when setting up Finance or Consolidation Application compared to other Applications?
- A . Select Application options
- B . Select copy options
- C . Select source Application
- D . Modify Application
What value is used in the destination flow column of the currency conversion business rule when there is no subtable type dimension in the Application? (1)
- 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
What solution for uploading transactional data into BPC for NetWeaver requires customer-specific process types?
- 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 in delta mode from BW using an Open Hub destination that provides flat files for BPC ^ Data Manager
- D . Loading data from a DataStore Object using BPC Data Manager
What step is required to configure data audit for BPC standard?
- A . Activate the collection of data by environment
- B . Activate the collection of data by model
- C . Add a global parameter in Customizing (SPRO)
- D . Add a parameter to data manager packages.
A KPI should be calculated centrally, on-the-fly, and be available to all reports .
Which implementation option do you choose? (1)
- A . Dimension Member Formulas
- B . Worksheet Logic
- C . Script Logic
- D . Business Rules
In which section of the transformation file do you define the source InfoObject?
- A . Conversion
- B . Options
- C . Selection
- D . Mapping
Which fields are required to eliminate the investment when using the All Formula? (2)
- A . Destination All
- B . Destination Group Account
- C . Source Account
- D . Destination Equity Account
- E . Account
- F . Destination Minority Interest
Find out Step which is not taking part in The Information Gathering Process. (1)
- A . Matching
- B . Enabling EMP
- C . Preparations
- D . Presentations
You CANNOT view the final data in Real Time Consoliclation.
What could be the issue? (2)
- A . The work state needs to be complete.
- B . The entity needs to be approved.
- C . The process needs to be submitted.
- D . The data needs to be validated.
You are working in a BPC Standard system .
Which are unique settings of the ownership model? (2)
- A . Parent child property
- B . Enable comments
- C . Use as source data
- D . Non-lnterco Member
Which parameters are mandatory for a EVDRE function? There are 2 correct answers to this question.
- A . ExpandRange
- B . FormatRange
- C . KeyRange
- D . OptionRange
- E . Application
What implementation step is required to add a new hierarchy for a dimension member? (1)
- A . Insert the hierarchy name into the ‘APPROVALORG’ web application parameter.
- B . Insert the hierarchy name to the TOPDOWN’ web application parameter,
- C . Insert ‘PARENTH2’ column after ‘PARENTH1’ within the dimension member sheet.
- D . Insert ‘PARENTH2’ into the dimension property list.
What fields are required to eliminate the investment when using the ‘All Formula’? 2 BPC440
- A . Destination All Account
- B . Destination Equity Account
- C . Destination Minority Interest
- D . Destination Group Account
- E . Source Account
You are using BPC Embedded and want to plan on new members. You decide to implement Master Data on the Fly and implement the method class.
What are the function type parameters? Note: There are 3 correct answers to this question
- A . Parent ID
- B . InfoObject
- C . Member ID
- D . InfoProvider
- E . Property ID
Which of the following dimensions is automatically selected when you create a business process flow template? Please choose the correct answer.
- A . entity
- B . account
- C . time
- D . category
What Application option do you have to select when you create an Application to make intercompany eliminations? 1 BPC440
- A . Validation Rules
- B . Account Transformation
- C . Automatic Adjustment
- D . Balance Carry Forward
How can characteristic relationships be used? Note: There are 3 correct answers to this question
- A . To distribute data based on valid combinations.
- B . To delete data based on invalid combinations.
- C . To derive data based on BW hierarchies.
- D . To check combinations based on S/4HANA data.
- E . To disaggregate based on reference data.
Which step is mandatory if you want to check the data integrity of the incoming records? 1
- A . Implement a BAdi.
- B . Configuration controls.
- C . Activate the validations for the environment.
- D . Assign driver dimension to the validation rule.
You are working in a BPC Embedded system .
What object can you maintain immediately after creating an environment? (1)
- A . Report
- B . Dimension
- C . Business Process Flow
- D . Team
You are implementing a planning solution that uses BPC Embedded When you run a planning function, you notice that it is NOT optimized .
How can you resolve this issue? Note; There are 3 correct answers to this question
- A . Activate Deep HANA Integration.
- B . Create a planning function that runs HANA SQL.
- C . Activate the BPC Embedded Model.
- D . Set the RS_DEBUGLEVEL parameter to 2.
- E . Set the RSPLS_HDB_SUPPORT parameter to HDB_ON.
Which application type is optional in BPC for consolidation of investments and currency translation? 1 BPC440
- A . Consolidation
- B . Rate
- C . Ownership
- D . Financial
Find out the options uses to optimize your model for improvement in system performance: (2)
- A . Lite Optimize
- B . Full Optimize
- C . Pie charts
- D . Charts and tables
Which hierarchy is used in the consolidation monitor? 1 BPC440
- A . Entity Hierarchy.
- B . Ownership- based hierarchy.
- C . Intercompany-based hierarchy
- D . Group Hierarchy.
Select the correct word for- Where the system writes the result of spread. (1)
- A . Column
- B . Row
- C . Cell
- D . Destination
You are using BPC 11.0.
From which of the following objects can you import data using the "Load Transaction Data from BW infoProvider" data manager package?
- A . Advanced DataStore Object
- B . InfoObject
- C . InfoCube
- D . MultiProvider
What is entered in the destination group account when replacing the US elimination business rule with the automatic adjustment business rule? (1)
- A . Value of the ELIMACC property of account dimension
- B . Intercompany accounts receivable account
- C . Same value as in the destination minority account
- D . Intercompany accounts payable account
Identify three function category from the following (3)
- A . EPM functions
- B . PCL function
- C . FPMXL client. Technical Category
- D . EV Functions
- E . BSNL
Which EV functions can support the posting process of an Input Schedule? (2)
- A . EVCOM
- B . EVDRE
- C . EVGTS
- D . EVMNU
You use an account-by-product report and want to drill down on parent accounts for one product at a time as in the attached screenshot .
What do you need to select to achieve this drilldown behavior?
- A . ‘Keep I Exclude on Single Member’
- B . ‘Expand Collapse on Single Member1
- C . ‘Member and Descendants’
- D . ‘Member and Children1
Company D owns 91% of A, 51% of B, and 49% of C .
Which company can use the equity method?
- A . B.
- B . A.
- C . D.
- D . C.
Which step is required to store a comment to a filled cell in an Excel pop-up in BPC for NetWeaver? (1)
- A . Assign a keyword.
- B . Save the Excel workbook locally.
- C . Enable comments in the Application Set parameters.
- D . Enable comments in the Application parameters.
Which properties are required to carry out currency translation for legal consolidation? (2)
- A . RATE_PERIOD
- B . FX_SOURCE_CATEGORY
- C . REPORTING
- D . MD
You EPM Report is enabled to send data and comments. You type in a revenue value and a comment in the EPM report and save the data.
Where is the data stored? (1)
- A . The revenue data in a infocube and the comment in a DataStore Object
- B . Both the revenue value and the comment in a Infocube
- C . The revenue data in a infocube and the comment in another database table
- D . Both the revenue value and the comment in a DataStore Object
What rows are displayed in an EVDRE report for the MemberSet ‘SELF.DEP*? (1)
- A . The member as defined within the PageKeyRange and all its dependants
- B . The member as defined within the CurrentView and all its dependants
- C . The member as defined within the PageKeyRange and all its base members
- D . The member as defined within the CurrentView and all its base members
You insert an input-enabled query as a data source in Analysis for Office. You update values and would like to work with data in the planning buffer without storing data persistently in the database
Which standard Analysis for Office methods can you use to accomplish this?
- A . Select the ‘Smart Copy’ button.
- B . Select the’Recalculate" button.
- C . Use the "SAPSetData" formula.
- D . Switch to ‘Display Mode’.
You select a parent in the detailed section of the control definition .
Which option do you choose to ensure that the control will be executed for each member of the selected parent?
- A . Threshold Level
- B . Control Status
- C . Control Level
- D . Breakdown Dimension
A user has measures containing plan and actual data within the columns of a crosstab.
How can you create a dynamic variance using standard Analysis for Office features? Note: There are 2 correct answers to this question
- A . Use a New Line rule type
- B . Use an MS Excel formula.
- C . Use a VB script
- D . Use the Calculation from the Analysis ribbon.
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 . *RENAME_DIM
- B . *XDIM_MEMBERSET
- C . *ADD_DIM
- D . *SKIP_DIM
You have created an EPM report containing Time’ in the columns and ‘Product’ in the rows. You would like to leverage a function to display the hierarchy level for a given product in
the rows
Which EPM functions are used for this purpose? Note: There are 2 correct answers to this question.
- A . EPMLocalMember
- B . PMDimensionProperty
- C . EPMDimensionPropertyValues
- D . EPMMemberProperty
You are working with BPC Embedded in a replicated scenario. You need to create a Local Provider.
Aside from the Native SAP HANA table, which other objects are system generated? Note: There are 2 correct answers to this question.
- A . External calculation view
- B . Workspace
- C . BW Query
- D . Aggregation level
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
Which components does BPC Embedded Consolidation use in a Replicated Scenario? Note: There are 2 correct answers to this question.
- A . VirtualProvider as the Consolidation InfoProvider
- B . CompositeProvider as the Consolidation InfoProvider
- C . Exchange Rate InfoProvider
- D . Exchange Rate TCURR tables
What tasks are accomplished during full optimization in BPC for NetWeaver? (2)
- A . Executing a data model analysis and alerting if the data model can be improved
- B . Creating a copy of the MultiProvider for the BPC Application
- C . Updating DB statistics for the InfoCube
- D . Closing the open request after posting 50,000 records
- E . Compressing and indexing the InfoCube
Currency translation calculations typically work as follows: 2 BPC440
- A . The change is bought over at the average rate plus the difference between the END and AVG rate L’ multiplied by the LC.
- B . Translation differences can be written to separate flow members.
- C . Opening balance is bought in at the END rate plus the change in the END rates multiplied by the ‘―’ closing LC value.
- D . The closing balance is valued at the LC times the END rate.
- E . Translation differences are also written to the journal document DSO.
How to reset the consolidation status? (1)
- A . All over changes
- B . Set up changes
- C . Changes in master data
- D . Dim list changes
You use the INC account type for revenue accounts and the EXP account type for expense accounts.
What is displayed in an EPM report when revenues are stored as negative values and expends are stored as positive values? Note: There are 2 correct answers to this question
- A . Negative revenue values
- B . Positive expense values
- C . Negative expense values
- D . Positive revenue values
Which of the following values can you use in the destination flow to configure the currency translation business rule? (2)
- A . descencients
- B . base level members
- C . blank
- D . property values
Where do you change a BPC report to an input schedule? Please choose the correct answer.
- A . In the EVDRE report
- B . In the workbook options
- C . In the PageKeyRange
- D . In the Web Admin Dashboard
The Ownership Account contains? 2 BPC440
- A . Parent Positions
- B . D- Entity
- C . A. Percentages
- D . E. Rates
- E . B. Methods
Where do you set the data audit to capture transactional data changes? (1)
- A . At Application level in Admin Console
- B . At Appset level in Web Admin
- C . At Application level in Web Admin
- D . At Appset level in Admin Console
Which of the following delivered task profiles allows you to maintain environment? (1)
- A . secondary admin
- B . System Admin
- C . primary Admin
- D . system security
Which rlimension type can you use for the context when you use the controls monitor in a financial model? There are 3 correct answers to this question.
- A . E-Entity
- B . R-Currency
- C . G-Group
- D . T-Time
What activities are possible while running a data management package in BPC for NetWeaver?
- A . Importing master data hierarchies
- B . Importing master data attributes
- C . Importing transaction data
- D . Loading data from Info Providers
- E . Importing master data descriptions
Which object in BW is equivalent to a model in SAP business Object Planning and Consolidation for NetWeaver? (1)
- A . VirtualProvider
- B . multiProvider
- C . real-time infocube
- D . standard infocube
You are configuring comments in BPC Embedded .
Which objects are required? Note: There are 2 correct answers to this question.
- A . An AdavancedDataStore Object
- B . A Characteristics as key figure
- C . A system-generated data table
- D . A CompositeProvider
You are using BPC Standard 11.0 .
Which of the following do you define in the US Elimination Business Rule? (3)
- A . Entity dimension
- B . Multipliers
- C . Architecture
- D . Source audit
- E . Source accounts
What determines the user access to BPC Applications? (2)
- A . Member access profile
- B . User/team assignment
- C . Secured dimensions
- D . Profile SAP_ALL
Each Work Book contains two work sheets. Identify them: (2)
- A . Analysis
- B . Report contents
- C . One sheet contains the dynamic formatting
- D . Info graphics
- E . One sheet contains the template
What dimension and value does the Method Based Multiplier determine?
- A . Debit account
- B . Source flow
- C . Debit flow
- D . Source account
Which of the following journal parameters are available for a model? (2)
- A . Balanced by Currency
- B . Balanced by Entity
- C . Enforce Balanced Journal
- D . Allow Journals to be reopened
What dimension property is required for consolidation of investments? 1 BPC440 O D.
- A . OWNER in the entity dimension
- B . NTCO in the entity dimension
- C . ENTITY in the groups dimension
- D . FIRST_CONS_DATE in the groups dimension
What are the two modes of transport supported? (2)
- A . Deletion mode
- B . Normal mode
- C . Inactive mode
- D . Active mode
Which steps are required to use data access profiles in BPC Embedded? Note: There are 2 correct answers to this question.
- A . Set the mode! dimensions to be authorization relevant.
- B . Assign authorizations to the user.
- C . Assign authorizations to the environment
- D . Set a characteristic to be authorization relevant.
For which of the fallowings models you have to create at least two "drivers" type model?
- A . Financial
- B . Ownership
- C . Consolidation
- D . Standard
You need to run a planning sequence while data is being saved.
Which object do you attach the planning sequence to?
- A . Process chain
- B . Planning query
- C . CompositeProvider
- D . Advanced DataStore Object
Which dimensions can you use to configure the Balance Carry Forward business rule? Note: There are 3 correct answers to this question.
- A . Account
- B . Currency
- C . Entity
- D . Flow
- E . Audit Trail
Which tasks can you perform using the Consolidation Monitor in BPC embedded? (3)
- A . Run ownership calculation
- B . Run US Elimination
- C . Run controls
- D . Run reclassification
- E . Run planning function
What components are needed to run business rules? 3BPC440
- A . Conversion File
- B . Business Rule
- C . Data Manager Package
- D . Dimension Logic
- E . Script Logic