How do you control inserting records into the database in BPC? Via Work Status Via Business Rules Via Distributor and Collector Via Audit.
What steps are required to save new members from the member sheet to the database of the admin console? 2 Maintain dimension members. Process dimension. Save to server. Change the flag 'Take system off-line'. Maintain dimension property.
How do you allow data entry and posting in a BPC Excel sheet? Add a row to show the variance of the plan. Use a hierarchical structure for member values. Set the workbook option to 'Refresh automatically'. Use base members.
For which scenario is it impossible to use the work status? To track the progress of a planning process To lock a step in a Business Process Flow To allow or disallow a user to modify data To lock a region of data in a Model.
Which of the following tasks can be performed as a background job Via process chain? Copy Model Modify Model Optimize Model Copy Environment.
Which of the following delivered components cause quick implementation in Planning and Consolidation? 3 Report Templates Input Schedule Templates Cost Center Planning Model Sample Logic.
What information is needed when you configure the interface between EPM OfficeAdd-In Excel and Bex Query to enable the BW drill through? 3 The FILTER_IOBJNM and FILTER_VALUE parameters. The URL of the BEx Query. The technical field names of the dimension. The OKCODE parameter. The technical names of the InfoObjects. .
How do you configure the Data Manager package to execute a specific logic script file? Define the logic script file as a variable in package parameters. Define the logic script file in the process chain. Define the logic script file in the package link Define the logic script file in the advanced package settings. .
Which data management option is required to load transaction data from a file to an SAP BusinessObjects Planning and Consolidation Application? Run the data management package. Organize the package list. Download the data file. Maintain data management.
The dimension type that is required for effecting currency translations is… Currency Type Flow Type Entity Type Rate Type.
Which step is required to store a comment to a filled cell in an Excel pop-up in BPC for Net Weaver? 2 Save the Excel workbook locally. Enable comments in the Model parameters. Assign a keyword. Enable comments in the Environment parameters. Enable the input form to allow the pop up appear.
What determines the user access to BPC Applications? 2 Profile SAP_ALL Secured dimensions Member access profile User/team assignment.
Transaction data is described by…… Infocube Dimension Appset Dimension Members Calculated KF’s.
Which of the following objects are required when executing an upload of data into BPC using a data manager process? 2 Conversion file Script logic Transformation file Transformation rule Process chain.
What is BW object equivalent to a BPC Model? Infocube Infoobject DSO Infoarea Table.
Which of the following are valid for a BPC Dimension? 2 Equivalent to a BW Characteristic Equivalent to a BW Dimension Contains three types of master data Can have multiple hierarchies.
Where do you set the data audit to capture transactional data changes? At Environment level in Admin Console At Environment level in Web Admin At Model level in Admin Console At Model level in Web Admin.
What settings are possible for restricting data access for a given work state? 2 Administrator. Reviewer Owner Manager.
Which section of the transformation file would be used to assign BW Characteristics to BPC Dimensions? Options Mapping Conversion External and Internal.
A step is re-opened? What is the next step status? Open Re-open Pending Delayed Approved.
You reopen a step in a business process flow. What will to status of the next step be? A.reopened B.rejected C.Correct D.delayed .
Where do you change a BPC report to an input schedule? A. In the PageKeyRange B. In the EVDRE report C. In the Web Admin parameter D. In the workbook options .
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.
You want existing records to be deleted first before writing new records. What option do you choose while running a data management package? A. Merge B. Replace and Clear C. Clear D. Clear and Append.
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.
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.
Where do you set up the data audit for transactional data? A. BPC Admin B. BPC excel interface C. Web Admin parameters at environment level D. Web Admin parameters at model level.
What is the consequence in BPC for Net Weaver when updating the web admin parameters without entering the required parameters? A. Warnings B. Nothing C. Crashes D. Errors.
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. .
A KPI should be calculated centrally, on-the-fly, and be available to all reports. Which implementation option do you choose? A. Worksheet Logic B. Business Rules C. Dimension Member Formulas D. Script Logic.
Which calculation uses script logic exclusively? A. Elimination B. Currency Translation C. Allocation D. Reclassification e. Ownership calculation.
Which parameter in the options list of a transformation file is available only in BPC for the SAP NetWeaver technology platform? A. DELIMITER B. SELECTION C. VALIDATERECORDS D. AMOUNTDECIMALPOINT.
Which of the following steps are mandatory if you want to perform a transport from the development system. 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 Transport Collector. .
How do you change an EPM report from read only to read/write using EPM office Add-in Excel? 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.
Which is a true affirmation? 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.
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 .
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.
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.
Which dimensions can you use to configure the “carry-forward business rule”? 3 A. Flow B. Time. C. DataSource D. Account E. Entity .
Currency translation calculations typically work as follows: 2 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. A. Opening balance is bought in at the END rate plus the change in the END rates multiplied by the closing LC value.
What benefits does BPC offer to a corporation? 2 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.
What Application option do you have to select when you create a Model/Application to make intercompany eliminations? A. Account Transformation B. Validation Rules C. Balance Carry Forward D. Automatic Adjustment.
Which settings do you need to make for the Source Account to calculate the annual net income (ANI) for the liability account?
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.
Which 2 functions can be used using script logic and business rules? 2
A. Carry Forward B. Validation C. Automatic adjustments D. Currency Translation.
Which of the following tasks can you perform using the Consolidation Monitor? 2
A. Run ownership calculation B. Run currency translation C. Run controls D. Run consolidation E. Run Data Manager packages.
Which rule type is required if you want to perform consolidation of investment? Elimination and adjustment US Eliminations Intercompany Bookings Account-based Calculation.
1Which of the following application options are common between Finance and Consolidation Models? 3
Currency Conversion Calculation Intercompany Booking Intercompany Elimination Controls US Elimination Opening Balance.
What needs to be run before ownership elimination?
Account transformation Carry forward Currency translation Intercompany booking.
Which properties are required to carry out currency translation for legal consolidation? 2
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.
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 .
What components are needed to run business rules? 3 Business Rule Dimension Logic Conversion File Data Manager Package Script Logic.
What is entered in the group account when you configure AR/AP intercompany eliminations and adjustment business rule?
the intercompany AR account the intercompany AP account the same value as in the destination minority account the offset account .
Identify the 3 different types of Logic. 3
Stored Output Front-End Models Rate type On the fly.
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? Currency dimension - CURRENCY TYPE property Account dimension - ACCTYPE property Account dimension - RATETYPE property Entity dimension - FX_TYPE property.
How many types of BW master date are there? 3
Hierarchies Attributes Units of measure Text.
How to set a work status in the consolidation monitor. 2
Only refresh Choose an entity and click work status Click refresh to see the update status Changes in data Choose work status.
The Ownership Account contains? 2
Percentages Methods Parent Positions Entity Rates.
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? A web report An input schedule An excel report A journal.
How to use a consolidation monitor? 3
Business contents Control status Work status Consolidation status Administration.
What are the steps required to configure controls? 3
Work status Create control sets Managerial drill Enable work status for the model Assign security task for control.
Which of the following values can you use in the destination flow to configure the currency translation business rule? 2
Base level members Blank Descendents Property values.
When using US eliminations, which dimensions must you include in the model? 2 Entity Group Time Flow.
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/Application? Same as in the destination account column Same as in the source account rate type column Same as in the source flow column Same as in the formula column.
When validating the 'FXTrans.LGF' file, you get a validation error stating that the currency dimension is missing a property. What property is missing? PARENT_GROUP GROUP_CURRENCY STORE_GROUP_CURR CURRENCY_TYPE.
What dimensions are used to configure the carry forward business rule? 3 Time dimension Flow dimension Entity dimension DataSource dimension Account dimension.
What is entered in the destination group account when replacing the US elimination business rule with the automatic adjustment business rule?
Intercompany accounts receivable account Same value as in the destination minority account Value of the ELIMACC property of account dimension
Intercompany accounts payable account.
Running control could include the following steps. Identify them. 2 Hyper links Contents Review Control data Dimensions Run Control.
In order to maintain master data from the BPC Web Client. 3
The planning InfoProvider is included in a BPC Embedded Model The Characteristic is included in a planning InfoProvider The Characteristic must be persistent The Characteristic is included in a ADSO.
Which application type is optional in BPC for consolidation of investments and currency translation?
Financial Ownership Rate Consolidation.
What value for the property DATASRC_TYPE in the datasource dimension allows you to identify system postings?
L - Level A - Automatic I - Input M - Manual.
Which dimension type can be used to track opening and closing balance? Intercompany Audit Category Subtable (Flow) Group.
How to reset the consolidation status?
Changes in master data All over changes Dim list changes Set up changes.
Which business rules are used in the consolidation monitor? 3
Account-based calculations US eliminations Eliminations and adjustments Currency translation Global definitions.
What dimension property is required for consolidation of investments?
FIRST_CONS_DATE in the groups dimension INTCO in the entity dimension ENTITY in the groups dimension OWNER in the entity dimension.
For which calculation do you have to use a different implementation method than Business Rules?
Automatic adjustment Account transformation Allocation Currency conversion.
What does a consolidation model contains? 2
Only contents Accounts Proactive data Balance sheet data Income statement.
How many journal templates are in a model. N no of journal templates. Only one journal template per model. Based on the no of dimensions Journal templates are app set specific.
Which of the following business Rules can you use in a financial model? method-based multipliers method s Elimination and adjustment Automatic Adjustment Currency translation.
What DIM is same for all models in consolidation setup?
Category & time Category, entity, time Category, group, time Category, group, Time, Entity.
|
