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 The task profile is assigned to the user’s team The data access profile is assigned to the user’s team The task profile is not assigned to the user’s team The data access profile is not assigned to the user’s team.
When a uses tries to log in to a Model using BPC for Excel, the Model does not appear in the list for available Models the user just created. What is the problem? 1 The user is not created correctly The Model is not created correctly The member access profile is not correct The task profile is not correct.
Which is a true information? 1 Only user with System Admin rights can créate a new model, dimensión, business rules table, work status. Only user with Admin rights can créate a new model, dimensión, business rules table, work status. Only user with Primary Admin rights can créate a new model, dimensión, business rules table, work status.
Wich user account do you nedd to log onto SAP BPC versión for Netweaver? 1 CMS ECC Windows AD BW.
What determines the user access to BPC Applications? 2 Profile SAP_ALL Secured dimensions Member access profile User/Team assignment .
For which scenario is it imposible to use the work status? 1 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 región of data in a Model.
How do you control interface récords into the database in BPC? 1 Via work status Vis business rules Via Distributor and collector Via Audit.
What do you have to créate to capture the data from multiple planning iterations? 1 properies dimensions models members.
User1 is a parent owner and user2 is the child owner. What happens when user2 sets a work status? 3 If it is set to “Manager”, user1 can post a journal If it is set to “All”, only user1 and user2 can post a journal if it is set to “Locked”, neither can post a journal if it is set to “Manager”, user2 can post a journal if it is set to “Both”, user1 and user2 can post a journal .
What settings are possible for restricting data access for a given work state? 2 Administrator Reviewer Owner Manager Assistant.
Which of the following are valid for a BPC Dimensions? 2 Equivalent to a BW Characteristic Equivalent to a BW Dimension Contains three types of master data Can have multiple hierarchies.
Which of the following can you say about members of dimensión? 3 Members with no children are called Base-level Members Members with children are Parents Parents members have a calc value of NO Members have properties that can be used in reporting.
What dimensions can be referenced to each other? 2 Time to Category Flow to Account Account to Rate Intco to Entity Currency to Entity.
Wich property is optional for account type dimensions? 1 SCALING ICMATCH RATETYPE ACCTYPE.
What limitations exist for dimensión properties in BPC 10.0 for Nerweaver? 1 Properties with more than 60 characters cannot be used for dimensión member formulas. No more than 20 properties can be created for a given member Property size can only be increased, not decreased Properties cannot be deleted once they are created.
How can you add a property other than a hierarchie to a dimensión? 1 Maintain the dimensión property Refresh the dimensión member Maintain the dimensión members Process the dimensión.
What is the maximum length? 3 ID dimensión > 16 caracteres ID dimensión property > 20 caracteres Dimension member > 32 caracteres Dimension property name > 40 caracteres.
What are valid MDX expansión options? 3 ANY BEFORE LEAVES AFTER SELF.
You execute the following script logic logic1.lgf by running a data manager package, whitout transfering any further parameters and without using default logic.
*WHEN ACCOUNT
*IS ACCOUNT1
*REC(FACTOR=1.5,ACCOUNT=ACCOUNT2)
*ENDWHEN
*COMMIN
What is the scope of the calculation? 1 Only current view ACCOUNT1 and ACCOUNT2 All data within the database Only input Schedule .
What activities are posible while running data management package in BPC for Netweaver? 3 Importing master data hierarchies Importing master data descriptions Importing master data atributes Importing transaction data Loading data from InfoProvides.
What steps are required to save new members from the member sheet to the database of the admin console? 2 Maintain dimensión members Process dimensión Save to server Change the flag “take system off-line” Maintain dimensión property.
There are three types of versións available in Business Process Flow Templates. 3 Draft Deployed Pro-active BOPC Inactive.
Only one is correct. 1 There can be n driver dimensión or 1 model There can be only 1 driver dimensión for 1 model There can be n driver dimensión for N models There can be max 5 driver dimensions for a single model.
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 InfoArea InfoObject InfoObject Catalog InfoCube Multiprovider.
Which dimensión type is optional for a model? 1 Audit type Category type Time type Account type.
What is BW object equivalent to a BPC Model? 1 InfoCube InfoObject DSO InfoArea Table.
What object in SAP BW is an equivalent to an Application in SAP BPC for Netweaver? 1 A real-time InfoCube that contains transactional data A basic InfoCube that contains transactional data A DataStore Object that contains transactional data A MultiProvider that creates a join of different data tables.
SAP guidelines recommend that you make what changes directly in SAP BW on BPC generated objects? 1 Switch case sensitivity off. Change the data lengths of characteristics Change no objects at all. Switch hierarchies to time dependent.
Which package group is customer-specific in SAP BusinessObjects Planning and Consolidation for Netweaver? 1 Financial Processes Data Management Reporting Management System Administrative.
Which of the following is possible in the data loading process in BPC for Netweaver? 1 Using a multiple conversión files for a single dimensión without additional coding Using the download function to move files from the local hard drive to the data file folder Using transformation file without a conversión file Using Visual Basics Script in the Data Manager.
After running a data manager package link with 5 packages, you notice that package 3 failed. What happened to the other packages? 1 Package 1,2,4 and 5 ran Package 1,2 ran, packages 4 and 5 did not ran Packages 1,2 were rolled back, package 4 and 5 ran Packages 1 and 2 were rolled back, package 4 and 5 did not ran.
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.
Which of the following task can be performed as a background job via process chain? 1 Copy a model Modify model Optimize Model Copy Environment.
Which parameter in the options list of a transformation file is available only in BPC for the SAP Netweaver technology platform? 1 DELIMITER SELECTION VALIDATERECORDS AMOUNTDECIMALPOINT.
A data load of a data management package shows an error message stating that the number of rejecter record 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 or rejecter récords? 1 0 700 -1 701.
Which section of the transformation file would be used to assign BW Characteristics to BPC Dimensions? 1 Options Mapping Conversion External and Internal.
Which data management option is required to load transaction data from a file to an SAP BusinessObjects Planning and Consolidation Application? 1 Run the data management package Organize the package list Download the data file Maintain data management.
You want existing récords to be deleted first before writing new récords. What option do you choose while running a data management package? 1 Merge Replace and Clear Clear Clear and Append.
You need to configure work status to help control planning process while implementing BPC Standard. Which steps are required? 2 Enable data locking for the model Maintain the manager property in the owner dimensión Define a hierarchie in the owner dimensión Maintain the reviewer property in the owner dimensión.
What value is assigned to the ACCOUNT3 with the following Script logic? 1
*WHEN ACCOUNT
*IS ACCOUNT1, ACCOUNT2
*REC (FACTOR=1, ACCOUNT=ACCOUNT3)
*ENDWHEN
*COMMIN
Sum of ACCOUNT1 and ACCOUNT2 Difference of ACCOUNT1 and ACCOUNT2 Quotient of ACCOUNT1 and ACCOUNT2 Product of ACCOUNT1 and ACCOUNT2.
You are testing script logic to perform a loop over months. You save Budget data for month 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 %COUNTERS%=1,2,3,4,5,6,7,8,9,10,11,12
*REC(EXPRESSION=%VALUE%/12*2,TIME=TMVL(%COUNTER%,%TIME_SET%),CATEGORY=FORECAST)
*NEXT
*ENDWHEN
When this script logic executed, What months receive data? 1
2019.01 to 2019.12 2018.07 to 2019.06 2019.01 to 2019.06 2018.07 to 2018.12.
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? 1 MultiProvider InfoCube InfoObject Advanced DataStore Object.
What are the implementation factors required to start a Project 3 Timeline Scope Project objetives Layoff.
All configuration in UJ_VALIDATION is _________ Specific. 1 Model Environment Dimension ADSO (DataSource Object).
Where do you set up the data udit for transactional data? 1 BPC Admin BPC Excel interface Web Admin parameters at environment level Web Admin parameters at model level.
For which dimensión type can you actívate a data audit trail for a model? 1 Entity Time Account Category.
What interfaces can you use during the step Define Action when setting up a BPF? 1 Manage Books, BPC Web, BPC for Word BPC Administration, BPC for Excel, BPC for Word Journal, BPC for Excel, BPC for Word Data Audit, BPC for Excel, BPC for PowerPoint.
What are the required dimensions to créate the BPF instances? 1 Time Time and Category Category Entity, Category and Time.
Who is notified when a step is completed using BPF? 1 BPF Reviewer BPF Manager BPF Owner BPF User.
Who is notified when an activity is submitted in the BPF? 1 Reviewer Manager Performer Owner.
A step is re-opened? What is the next step status? 1 Open Re-open Pending Delayed Approved.
You are working in a BPC Standard system. Which or the following dimensión types can be used as reference dimensions for referential integrity? 2 Audit Subtables Entity Time.
What dimensión types are mandatory for the Application type Financial? 2 I-Intercompany T-Time S-Subtable D-Audit C-Category.
During testing your notice that account descriptions are misssing. How do you resolve this issue? 1 Import master data descriptions Refresh dimensión members Import transaction data Import master data hierarchies.
Which calculation uses script logic exclusively? 1 Elimination Currency Translation Allocation Reclassification.
How do you configure the Data Manager package to execute a specific logic script file? 1 Define the logic script files as a variable in package parameters Define the logic script files in the process chain Define the logic script files in the package link Define the logic script files in the advanced package settings.
Which of the following steps are mandatory if you want to perform a transport from the development system. 2 Run a full optimization Run the transport-create request (UJBPCTR) transaction Run the transport-create request (UJBPCTR) transaction Select Planning and Consolidation objects in BW Transport Collector.
Which object in BW is equivalent to a model in SAP business ObjectPlanning and Consolidation for Netweaver 10.X? 1 Virtual Provider real-time InfoCube standard InfoCube multiProvider.
You want to be able to insert comments in an Excel popup in SAP BusinessObjects Planning and Consolidation versión for Netweaver. What do you have to enable? 2 The Enable Comments indicator in model features Model parameters in Customizing (SPRO) Environment parameters in Customizing (SPRO) The Show as Microsoft Excel Comments checkbox.
List the key features of business process flows, from the following. 2 Characteristics Logic Benefits Margin Cost.
Which is not a part of Developmental Process? 1 Manage a Drill Business Content Naming conventions Data Flow.
What are the two deployment scenarios? 2 Dispatch only Services only Development to production Only production.
Find out Step which is no taking part in the Information Gathering Process. 1 Presentations Enabling EPM Preparations Matching.
What actions are possible with work status? 2 Launching it from the content library Linking it to multiple hierarchies for an Application Using it only with entity and time type dimensions Bypassing it while executing a data management package.
Which of the following functions do you use to load data from a flat file to a model? 1 Data Preview Run Package Organize Package Download data.
Script logic can be broken in to 3 components. List them 3 Multiple settings Scoping Body/code Volume Writing the record.
You are working in a BPC Standard system and you want to check the member combinations for incoming transaction data. Which step is mandatory? 1 Implement Badi Configure controls Activate the validations for the environment Assign a driver dimensión to the validation rule.
Which objects do not get transported in SAP BusinessObjects Planning and Consolidation for Netweaver? 1 MultiProvides Business Rules Roles Journal Templates.
What do you do when you maintain dimensions data manually and want to return to the previous unsaved values? 1 Choose back Choose revert Choose restore Choose display.
Name to folder that the users has access to depend his/her access account 1 Team None Membership Activity.
You are developing the following script logic to perform an allocation,
*RUNALLOCATION
*FACTOR USING/TOTAL
*DIM ACCOUNT WHAT=LEASECOST;WHERE=<<<;USING=SQUAREFOOTAGE;TOTAL0<<<
*DIM ENTITY WHAT=GLOBALOPS;WHERE=>>>;USING=>>>;TOTAL=BASE(EUROPE)
*DIM COSTCTR WHAT=CORPORATE;WHERE=BAS(SERVICES);USING=>>>;TOTAL=BAS(DIRECT)
*ENDALLOCATION
To which destination members is the above script logic writing the record? 3
DIRECT base members SERVICE base members LEASECOST SQUAREFOOTAGE base members EUROPE base members.
When you créate a new model from an existing model, which ítems can be copied? 2 Transaction data Journal templates Control definitions Data manager packages.
Which of the following conventions apply to dimensions property Ids? 2 they must contain less than 33 characters they must begin with a number they must contain less than 21 characters they must begin with a carácter.
What are the two modes transport supported? 2 Active mode Normal mode Deletion mode Inactive mode.
Find out the options uses to optimize your model for improvement in system performance 2 Charts and tables Pie charts Info graphics Full optimize Lite optimize .
You have business requirements to calculate 3 bonus amounts based on revenue.
Bonus account 1:10% of revenue
Bonus account 2:5% of revenue
Bonus account 3:2% of revenue
How do you proceed using script logic? 1
Use a scoping statement for the three bonus accounts Use a REC statement for each bonus account Use one WHEN statement and separate the bonus accounts the commas Use a WHEN statement for each bonus account.
Which of the following delivered task profiles allows you to maintain environment. 1 System Admin primary admin system security secondary admin.
The access rights you can assign to the sets of members are 3 Accept Denied Write Read only Follow.
Which the following steps are mandatory if you want to perform a transport from the development system to the production system (administration)? 2 Run a full optimiration Take the environment offline Run the transport créate request (UJBPCTR) transaction Select the planning and consolidation objects in the BW transport collector.
When does default logic run? 1 When bussiness rules are executed When data is refresh When data is sent from an input form When table -based logic is executed .
Which of the following options can you use to drill throught? 1 URL based on the context model RFC connection base don the selected cell URL based on the selected cell RFC connection base don the context model.
You have created an EPM containing “Time” in the columns and “Product” in the rows. You would like to leverage a function to display the hierarchie level for a given producto in a rows. Wich EPM functions are used for this purpose? 2 EPM MemberPropierty EPM DimensionPropierty EPM DimensionPropiertyValues EPM LocalMember.
Which the following are required when writing data via an Excel template? 2 Parent member can be written to the infocube Only base-level members can be written to the infocube The page key rango must contain base-level members for all dimensión not in the rows and columns The workbook option must be set to input Schedule.
How do you change an EPM report from read only to read/write using EPM office Add-in Excel? 1 Switch template to an input Schedule Activate member recognition in the sheet options Switch type from report to input form Activate as input form to the sheet option.
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 Select apply to local member default formula Select apply for calculated member default formula Select apply for inputable member default formula Select apply for changed member default formula.
Which step is required to store a comment to a filled cell in a Excel pop-up in BPC for NetWeaver? 2 Save the Excel workbook locally Enable comments in the Model parameters Assign a keyword Enable comments in the Environment parameters Enable check in sheet options.
For the budgeting process, you need to extrapolate a base amount across 12 months with a growth factor to 3%. What modeling function do you use? 1 TREND FORECAST SPREAD WEIGHT.
Which function do you use to display a dimensión name? 1 EPMDimensionOverride EPMDimensionPropierty EPMDimensionList EPMDimensionType.
A KPI should be calculated centrally, on the fly, and be available to all reports. Which implementation option do you choose? 1 Worksheet Logic Business Rules Dimension Member Formulas Script Logic.
What information is needed when you configure the interface between EPM OfficeAdd-In Excel and BW Query to enable the BW drill through? 3 The FILTER_IOBJNM and FILTER_VALUE parameters The URL of the BW Query The technical field names of the dimensión The OKCODE parameter The technical names of the InfoObjects.
You want to specify a model and dimensión members that are used every time you créate WEB reports. Where do you set the values? 1 Workspace Preferences EPM Context Context default.
What is the Manage a drill through? 1 This allow a user to maintain a drill through parameter This allow users to view drill through a parameter This allow a user to run a drill through None.
A report has been created with products in the rows displayed in a hierarchie. You would like to display the product members and parents in different colors based on the relative position in the hierarchie. Which of the following options in the EPM add-in will allow you to accoumplish this? 2 Highlights Selectec Hierarchies Calculate parents and hierarchies Formatting on specific level Formatting on specific member/property.
What is the best business practice to execute multiple iterations of a budgeting process in BPC? 1 Create a separate dimensión Create a separate application Create a separate dimensión member Create a separate property.
You have two models: one for Expense, and another for Sales. Both models have the same Profit center dimensión. You would like users to perform reporting on both models as follows:
In column A: Expense Values
In column B: Profitcenters
In column C: Sales Values
Which methods can you use accomplish this requirements? 2
‘EPMRetrieveData’Formulas ‘Shared axis’ reporting The ‘repeatrow headers’property The ‘outerdimension’ option .
What does a Dynamic filter do? 1 Use members in a referenced cell as filter values ADD-IN None Just a process.
Select the correct word for – Where the system writes the result of spread. 1 Cell Destination Column Row.
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? 1 (ver cuadro video) Member and Children Member and Descendants Expand/Collapse on Single Members Keep/Execlude on Single Members.
You are formatting an EPM Report. Which of the following features are configured in the EPM formatting sheet? 2 Repeat row headers Hierarchie levels Data validation Indent Children.
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 both the revenue value and the comment in a InfoCube the revenue data in a infocube and the comment in a DataStore Obejct both the revenue value and the comment in a DataStore Obejct the revenue data in a InfoCube and the comment in other database table.
Identify three function category from the following 3 FPMXL client. Technical category BSNL PCL function EPM Functions EV Functions.
You want to use a specific default values when you add data manually from the web client. How can you achieve this? 1 select the “Use as Input Form” option specify the default members for data input select the “actívate Member recognition” option specify the default members for reporting.
You enter data using EPM Office Add-in Excel. When you attempt to save the data, you recieve an error message saying that the member you want to save is not a base level member . What could help you to resolve this issue? 2 change the calc property of the parent members to N change the header dimensions to base members restrict rows and columns to base members set the expand option to “member and children” .
What allows you to type the Dimension Member values in your worksheet 1 Status reports Profiles Formatting Member Recognition.
You are building an EPM report and would like to leverage local members. What can you use to maintain local members? 3 Report Editor Row axis Dimension member formulas Excel formulas Page axis.
Which function do you use to calculate variances? 1 EPMComparation EPMMemberoffset EPMExecuteApi EPMMemberProperty.
Select ítems required for Enabling the EPM Ad-in? 2 Disable Item Control panel All the above Microsoft Office Excel, Excel Option button Esc button.
You use an account by entity report and want to drill download on parents account for one entity at a time, as in the attached screenshot.
How to you achieve this drilldown behavior? 1 (ver cuadro)
Activate Expand/Collapse on Single Members Activate Keep/Exclude on Single Member.
You have development an EPM Input form and would like to ensure a validation of cells message box pop ups after a user saves data. How can you accomplish this? 2 Use “Sheet protection” Use data validation in the formatting sheet Use the dialog option when saving data Use a custom VBA macro.
Which dimensions or properties can you use to determine the rule type and source values in a currency transation business rule? 2 FLOW GROUP_CURRENCY RATETYPE CURRENCY.
The Ownership Account contains? 2 Percentages Methods Parent positions Entity Rates.
What value for the property DATASRC_TYPE in the datasource dimensions allow you to Identity system posttings? 1 L – Level A – Automatic I – Input M – Manual.
Your customer wants to use a unique bussiness rule to translate currency for selected entities. Which property do you set for the selected entities to meet this requirement? 1 RATETYPE FX_TYPE GROUP_CURRENCY CURRENCY_TYPE.
Which dimensión type can be used to track opening and dosting balance? 1 Intercompany Audit Category Subtable (Flow) Group.
What is missing in this code? 1
*RUN_PROGRAM CURR_CONVERSION
CATEGORY=%C_CATEGORY_SET%
TID_RA=%TIME_SET%
RATEENTITY=GLOBAL
ENTITY=%ENTITY_SET%
*ENDRUN_PROGRAM
CURRENCY=%RTCURRENCY_SET% RATEENTITY=%ENTITY_SET% ACCOUNT=%ACC_SET% Rate type is missing TCURR table is missing.
When validating the “FXTrans.LGF” file, you get a validation error stating that the currency dimensión is missing a property. What property is missing? 1 PARENT_GROUP GROUP_CURRENCY STORE_GROUP_CURR CURRENCY_TYPE.
What the components are needed to run bussiness rules? 3 Bussiness Rule Dimension Logic Conversion file Data Manager Package Script Logic.
You are working in a BPC Standard system. Which are unique settings of the ownership model? 2 Use as source data Parent child property Interco Member Enable comments.
What dimensión property is required for consolidation of investments? 1 FIRST_CONS_DATE in the groups dimensión INTCO in the entity dimensión ENTITY in the groups dimensión OWNER in the entity dimensión.
What application option do you have to select when you créate a Model to make intercompany eliminations? 1 Account Transformation Validation Rules Balance CarryForward Eliminations and Adjustment.
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 dimensión will you look at to fix the problem? 1 Account RPLCurrency InputCurrency Group.
A Customer wants to use special Exchange rates for only 2 out of 160 entities when doing currency translation. What dimensión and what property do you use for that? 1 Currency dimensión – CURRENCY TYPE property Account dimensión – ACCTYPE property Account dimensión – RATETYPE property Entity dimensión – FX_TYPE property.
Which properties are required to carry out currency translation for legal consolidation? 2 DIMLIST in the account type dimensión FX_DIFFERENCE_ONLY in the category type dimensión RATETYPE in the account type dimensión STORE_GROUP_CUR in the currency type dimensión CURRENCY in the entity type dimensión.
You want enable users to resolve the “out of balance”. Issue when blocking controls fall. When you configure the controls, what do you attach to the blocking controls? 1 Account based-calculations EPM Excel Reports EPM Excel Input Forms A Journal.
Which business rules are used in the consolidation monitor? 3 Account-based calculations US Eliminations Eliminations and Adjustments Currency translation Global definitions.
You are 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 Grant authorization to the user for view the controls for the next period Change work status in the consolidation monitor for the next period Assign the control level to the following period Assign the control set to the following period.
Company D owns 91% of A, 51% of B, and 49% of C. Which company can use the equity method? 1 B C A D.
What needs to be run before intercompany eliminations? 1 Account transformation Carry forward Currency Translation Intercompany booking.
You are in BPC 11.0 How many journal templates are in a model? 1 Only multiple journals template per model Only one journal template per model Based on the no of dimensions Journal templates are app set specific.
Which of the following journal parameters are available for a model? 2 Enforce Balance Journal Balanced by entity Balanced by currency Allow journals to be reopened.
Which rule type is required if you want to perform consolidation of investments? 1 Account-based Calculations . US Eliminations Eliminations and Adjustments Intercompany bookings.
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 Positive revenues values Negative expense values Positive expense values Negative revenue values.
For which of the following models you have créate at least two “drivers” type model? 1 Standard Ownership Consolidation Financial.
Which of the following tasks can you perform using the consolidation monitor in BPC Standard? 2 Run ownership calculation Run currency translation Run account based reclasification Run consolidation Run data manager packages.
Which properties are required to carry out currency translation for legal consolidation? 2 MD FX_SOURCE_CATEGORY RATE_PERIOD REPORTING.
A customer wants to load certain accounts with both local and reporting currendes without doing a currency translation. What expresión in the formula of the business rule for currency conversión would leave the reporting currency value unchanged? 1 [AS_IS] [NOTRANS] [COPYLC] [END].
What are the steps required to configure controls? 3 Work status Create control sets Manaregial Drill Enable Work Status for the model Assign security task for control.
Which hierarchy is used in the consolidation model? 1 Group Hierarchie Entity Hierarchie Intercompany-based Hierarchie Ownership-based Hierarchie.
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 Ownership_System calculation PCTRL – Percent Control Consolidation_system calculation POWN – Percent Ownership PCON – Percent Consolidation.
Which of the following business Rules can you use in a financial models? 1 method-based multipliers methods Elimination and adjustment Currency translation.
What is entered in the group account when you configure AR/AP intercompany eliminations and adjustment business rule? 1 the intercompany AR account the intercompany AP account the same value as in the destination minority account the offset account [ELIMACC].
Running control could include the following steps. Identity them. 2 Hyper links Contents Review the control results Dimensions Run controls.
What does a consolidation models contains? 2 Only contests Accounts Proactive data Balance sheet data Income statement.
Which dimensión type can you use for the context when you use the control monitor in a Financial model? 2 Currency Group Entity Time.
Which fields are required to eliminate the investement when using the All formula? 2 Source account Destination Equity Account Destination Minority Interest Destination Group Account Destination All Account.
When executing the ownership calculation you receive an error message. You there for analyze the group/entity structure in the attached screenshot. Which method type is missing in the consolidation method? 1 (ver cuadro) G – Global P – Proportional H – Holding E – Equity.
After running consolidation, you notice that the elimination offset account is wrong. What property could have the incorrect value? 1 TYPELIM DIMLIST_ACC ACCTYPE ELIMACC.
What dimensión and value does the Method based multiplier determine? 1 Source Flow Debit Flow Source account Debit account.
The consolidation monitor displays a black screens for the current period although the previous period has been displayed property. What is missing? 1 Trial balance date Master data Ownership data Exchange rate data.
You select a parent in the detalled 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? 1 Control status Control level Breakdown dimensión The reshold level.
You are working in BPC Standard. Which dimensions must be identical in all models that use the Exchange Rate Model? 2 Account Time Currency Category.
You are using BPC Standard 11.0. Which of the following do you define in the US Elimination Business Rule? 2 source Audit Entity dimensión Multipliers Source accounts .
You are working in BPC Standard. Which of the following dimensión type are required for an ownership type model? 3 Group Intercompany Audit Currency Account.
The Account type dimensión consists of three properties? What are they? 3 Up list Account type Mid list Dim list Rate list.
Which the following model-specific business rules requires the environments-specific business rules? 1 Eliminations and adjustments Currency translation US Elimination Account-based calculations.
Which dimensión can you use to configure the Balance Carry Forward business rule? 3 Account Entity Currency Audit trail datasource Flow.
Which data source types are processed by the Balance Carry Forward rule? 2 Level Input Automatic Manual.
You need to calculate ownership using these values. Company D owns 70% of company A and 10% of company B. Company A owns 50% of company B. Using the group share method, what percentage ownership does company D have of company B? 1 45% 35% 10% 60%.
You have automated owership eliminations by using the BPC business rules and ownership data. You requirement is to use the same rule for both purchase and equity subsidiaries. The ownership is one of the subsidiares went from 45 to 55 percent. What changes should you make in the ownership manager for this subsidiary? 1 Method is changed to New PCON is changed to 55 Method is changed to “Holding”.
You are configuring consolidation for BPC Standard. Which dimensión must be the same for consolidation, rate and ownership models? 2 Time Category Account Entity.
Which components does BPC Embedded Consolidation use in a Replicated Scenario? 2 Exchange Rate InfoProvider VirtualProvider as the Consolidation InfoProvider CompositeProvider as the Consolidation InfoProvider Exchange Rate TCURR tables.
You are working in BPC 11.0 Embedded. Which design parameters are available for a journal Template? 2 Allow journals to be Reopened Enforce Balanced journal Enable Auto Reverse Enable Ungrouping.
You need to run a planning sequence while data is being saved. Which object do you attach the planning sequience to? 1 Advanced DataStore Object Composite Provider Planning Query Process chain.
You are working whith BPC Embedded in a replicated scenario. You need to créate a local Provider. Aside from the Native SAP Hana table. Which other objects are system generated? 2 Workspace External calculation view Agregation Level BW Query.
You want to hardcode a query to run only for the country value “Germany”. Where in the BW Query do you specify “Germany” as a “Fixed Value”? 1 Free characteristics conditions Dependencies Filter.
In Analysis for Office you have an input -ready query with accounts in the rows and all periods (months) of 2019 as well as the total for 2019 in the columns. You have a value of “1200” for “100” for JAN to DEC. You lock the cells for JAN and FEB and enter “1500” for 2019. When you recalculate the data. What happens? 2 The total will be changed to 1700 The non-locked cells will update to 100 The non-locked cells will update to 150 The total remains as 1500.
Which tasks can you perform using the Consolidation Monitor in BPC Embedded?3 Run reclassification Run controls Run planning function Run ownership calculation Run US Eliminations.
You are configuring comments in BPC Embedded. Which objects are required? 2 A system-generated data table A CompositeProvider Characteristics as Key figure An ADSO.
When 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 accomplish this? 1 Use the “SAPSetData” formula Select the “Recalculate” button Switch to “Display Mode” Select the “Smart Copy” button.
What is an advantage of BPC Optimized compared to Classic ERP Planing? 1 Reconciled data Optimized data loads Contaings an Enterprise Data Warehouse Summanzed data.
You are working in BPC Standard. Which of the following calculation options is HANA optimization? 1 Business Rules Local member formulas Dimension member formulas Consolidation logic.
You are using BPC Standard. You want to calculate revenue as a product of the units sold and Price per unit and save the results in the database. How can you achieved this? 1 Use Business Rules Use the dimensión member formulas Use the worksheet logic Use the data manager package.
You are working in a BPC Optimized system and you are setting up data retraction. Which of the following SAP S/4 HANA core tables does retraction book to? 1 FAGLBSAS_BAK COSP ACDOCP.
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 Method is changed to “holding” Method is changed to New PCON is changed to 55 PCON is changed to 100.
You are using BPC 11.0 for SAP BW/4 HANA. From which object can you créate an agregation level? 3 AdvancedDataStore Objects InfoCubes MultiProviders CompositeProviders LocalProviders.
To run a script logic file in a data manager package, where do you assign it? 1 In the REPLACEPARAM property In the TASK MODIFYSCRIPT setting In the SELECTION property In the SELECTION property.
You CANNOT view the final data in Real Time Consolidation. What could be the issue? 2 The data needs to be validated The process needs to be submitted The work state needs to be complete The entity needs to be aproved.
You need to work with BPC Embedded environments. What are your options? 2 Change the status Create to schatch Change the description Copy with reference.
You are using BPC Embedded in the BPC Web Client, a user can Access Environment #1 but not environment #2. What change is required for the user to Access Environment #2? 1 Assign an Analysis Authorization to the Environment Add the user to the BPC Team Add the user to the “RSBPC_ID” authorization object Assign a data Access profile to user .
You are using SAP BPC Optimized for SAP S/4 HANA. Which InfoProvider stores the comment entered Input-ready query? 1 Real-time InfoCube DataStore Object CompositeProvider VirtualProvider.
Your customer needs a blank input template that allows user to enter producto groups as needed and plan revenue for them. The BW Query has product in the columns and product in the free characteristics. When the BW Query is inserted into Analysis for Office, all data rows are blank. How is the BW Query configured? Product group is set to display based on “Characteristics Relationships” The query is set to “Disaggregate to All Valid Combinations” Revenue is set to “Disaggregate Difference to Entered Value” The query has "New lines on every level" selected.
A user has measures containing plan and actual data within the columns of a crosstab. How can you créate Dynamic variance using standard Analysis for Office features? 2 Use a new line rule type Use an MS Excel formula Use a VB script Use the calculation from the Analysis ribbon.
You are working in BPC Embedded. What options do you have for modeling persistent data? 2 InfoObject CompositeProvider AdvancedDataStore Object MultiProvider.
Which the following tasks can you perform using a data manager package delivered by SAP? 3
Load transaction data from a BW InfoProvider Load master data and texts from a BW InfoObject Execute a BAdI Export master data to SAP ECC Export transaction data to a flat file.
38.- You are working in BPC Optimized System. You need a planning function to copy actual data to plan data. Which of the following characteristics must be included in the fields to change? 1 InfoProvider Client Version Fiscal Year.
How can characteristic relationships be used? 3 The check combinations based on S/4 HANA data To disaggregate base don reference data To distribute data based on valid combinations To delete data based on invalid combinations To derive data based on BW hierarchies.
How can an Aggregation Level be used? 3 As an InfoProvider for planning queries As an InfoProvider for characteristics relationships To determine the level of granularity To store summary data As an InfoProvider for consolidation models.
You are working in a BPC Embedded system. What object can you maintain immediately after creating an environment? 1 Dimension Report Team Business Process Flow.
Which InfoProvider can Access data from ACDOCA? 2 /ERP/SFIN_01 /ERP/SFIN_20 /ERP/SFIN_M01 /ERP/SFIN_R01.
You are working in BPC Standard system. Your customer has the following requirements:
.Report with key dates
.Enable comments at the account level
.Track data updates by account
.Calculate KPI son the fly
What do you configure in your account dimensión? 2
Enable dimensión member formulas Enable time depend hierarchies Enable data Audit Enable comments.
You are working in a BPC Standard system. For which of the following models do you have to créate to least two “Drivers and rates” type models? 1
Consolidation Financial Ownership Standard.
You are working in a BPC Embedded. Data Audit is enabled for a local provider. What fields are added to the local provider database table? 3 Audit Trail Time stamp Audit mode Source of data Request ID.
What can be used as a data source in Analysis for Office? 3 BW Query Crystal report Web Intelligence HANA calculation view Universe.
You are implementing a planning solution that uses BPC Embedded. When you run a planning function, you noticed that it is. How can you resolve this issue? 3
Active Deep HANA Integration Set the RSPLS_HDB_SUPPORT parameter to HDB_ON Set the RS_DEBUGLEVEL parameter to 2 Create a planning function that runs HANA SQL Active the BPC Embedded model.
You are working in a BPC Standard System. The users are complanning about a message that the system is offline. What might be the issue? 1
The InfoProvider is set to “load mode” A BPC Transport is in process The system is saving a new member to a dimensión The workbook is offline.
You are configuring work status in BPC Embedded environments with a Sales InfoProvider. The requirement is to determine the owners via a characteristic that is NOT contained in the InfoProvider. How can the work status “Locking Dimensions” be determined? 1 By using a reference dimensión By using a external dimensión By using a property By using a customer implementation.
Your are working in a BPC Embedded system. Which objects are needed to run a calculation on HANA SQL? 2 Native HANA table Function type method class Data foundation.
You need to develop a BW query for SAP BPC 11.0. What should you use? 1 Model Extension Tool BEx Query Designer BW Modeling Tool RTC Modeling Tool.
You are working in a BPC Embedded system. What options do you have when maintaining members and properties of local dimensións? 2 Add a member that does NOT exist in a global dimensión Update property values for global members Delete global members Enable time dependent properties.
Is the FOX formula is:
(key figure1,#(unit),USD(currency).variable for material group)=
(key figure2,PC(unit),#(currency).variable for material group)=
(key figure3,#(unit),USD(currency).variable for material group).
How is the planning function configured? 2 Key figure is a data declaration Material group is a data declaration Key figure is a field to change Material group is a field to change.
SAP BPC 11.0 is based on SAP BW/4 HANA. Which traditional BW InfoProviders were replaced with Advanced DataStore Object? 2 Multiprovider Virtualprovider Persistent Staging Area InfoCube.
What is the máximum length of a characteristic value in BPC Embedded? 1 1333 characters 255 characters 32 characters 250 characters.
Which steps are required to use data Access profiles in BPC Embedded? 2 Set the model dimensions to be authorization relevant Set a characteristics to be authorization relevant Assign authorizations to the user Assign authorizations to the environment.
You imported a transaction data file into an empty model using a data manager package. An hour later, a finance team member brings a new data file that needs to be imported. As you can see in the graphic, the new file has exactly the same récords , with two exceptions:
1. The value of the Benefic Account has increased from 1500 to 1600
2. There is a new record for the Direct Labor Account with a value of 160
Which options can you use to update the data so that the latest flat file and the model have the same data? 2 (ver cuadro) Replace and Clear Merge Append Replace.
To add custom dimensión automatically to BPC Optimized structures, what do you use? 1 Model extensión tool RTC Modeling tool Planning Application Kit BW Modeling Tool.
You are the Administrator on a BPC 11.0 for SAP BW/4 HANA system. You need to optimize an Advanced DataStore Object by activating the data. What happens when you do this? 2 Redundant récords are agregated Dimensions are optimized Delta integre is biggered Transaction sequence numbers are closed.
Which hierarchy is used in the consolidation monitor? 1 Entity Hierarchy Group Hierarchy Ownership-based Hierarchy Intercompany-based Hierarchy.
Where is archived Audit data stored in BPC for the SAP NetWeaver technology platform? 1 In a BW table In a BW InfoCube In a DataStore Object In a flat file.
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 a web report an input Schedule an Excel report a journal.
You want to use work status in Analysis for Office. Which steps are required? 2 Select the data región in the crosstab Link the model to the data source Link the model to the workbook Select the data región in the filter tab.
What step is required to configure data Audit for BPC standard? 1 Add a global parameter in Customizing (SPRO) Add a parameter to data manager package Activate the collection of data by model Activate the collection of data by environment.
You are working in BPC Standard and you need to use a BAdI to perform calculation. Which object is used to link the code to the script logic file? 1 BAdI Implementation BAdI Definition Filter Value Enahancement Implementation.
What is the maximun length of a dimensión member ID in SAP BusinessObject Planning and Cosolidation versión for NetWeaver? 1 255 characters 500 characters 32 characters 20 characters.
How to set a work status in the consolidation monitor. 2 Choose an entity and click work status Only refresh Click refresh to see the update status Choose work status Changes in data.
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 PCON-percent consolidation POWN_percent ownership PCON_SYS percent consolidation_system calculation POWN_SYS percent ownership_system calculation PCTRL percent control.
Which step is mandatory if you want to check the data integrity of the incoming récords? 1 Configuration control Activate the validations for the environment Assign driver dimension to the validation rule Implement a BAdI.
You need characteristics for Real Time Consolidation. Which characteristics are “Persistent”? Group Category Account Audit.
You are using BPC Embedded and want to plan on new members. You decide implement Master Data on the Fly and implement the method class. What are the function type parameters? 3 InfoProvider Property ID Parent ID InfoObject Member ID.
Currency translation calculations typically work as follows. 2 Opening balance is bought in at the END rate plus the change in the END rates multiplied by the closing LC value The change is bought over at the average rate plus the difference between the END and AVGT rate multiplied by LC The closing balance is valued at the LC times the END rate Translation differences can be written to separate Flow members Translation differences are also written to the journal document DSO.
Which of the following is/are true with regards to validations? 3 All validation configuration can be transported Validations integrate with Activity Audit Authorization is controlled by Access to tasks profiles Last changed data and time is stored in tables Authorization is controlled by Access to transaction code S-TRANS.
Which of the following are standard business rules? 3 Currency conversión Account transformation Intercompany booking Automatic Adjustment Carry Forward US Elimination.
|
