Which of the following delivered components cause quick implementation in Planning and Consolidation? Three answers Report Templates Input Schedule Templates Cost Center Planning Models Sample Logic.
Which of the following could be some examples of the impact of implementing SAP BPC? 3 Streamline the planning, budgeting and forecasting process Increase the involvement of IT with the planning, budgeting and forecasting process Increase the business user productivity Full integration with the MS Office suite of products Increase the business user’s integration with the data model .
What tasks are accomplished during full optimization in BPC for Net Weaver? 2 Creating a copy of the Multi Provider for the BPC Application Closing the open request after posting 50,000 records Updating Data Base statistics for the Info Cube Compressing and indexing the Info Cube Executing a data model analysis and alerting if the data model can be improved.
Performance is critical to the BPC application. The use of light and full optimization is possible. What activity is unique to a full optimization? Zero compression during elimination Check the data model Close the open request Update data statistics for the cube.
For which users does the system prevent saving templates to the company folder? 2 For a non admin user with the Manage Template task For a non admin user without the Manage Template task For a user with the Primary Admin default function task For a team leader with the Manage Template task For a team leader without the Manage Template task.
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? 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 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? 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 affirmation? Only user with System Admin rights can create a new model, Dimension, business rules table, work status Only user with Admin rights can create a new model, Dimension, business rules table, work status Only user with Primary Admin rights can create a new model, Dimension, business rules table, work status.
Which user account do you need to log onto SAP BPC version for Netweaver? 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.
Which default function task type always includes Environment maintenance? Administration Primary System Secondary.
Which objects do not get transported in SAP BusinessObjects Planning and Consolidation for NetWeaver? MultiProviders Business Rules Roles Journal Templates.
Which of the following options can you use for drill through? URL based on the context model RFC connection based on the selected cell URL based on the selected cell RFC connection based on the context model.
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 allow or disallow a user to modify data.
How do you control inserting records into the database in BPC? Via Work Status Via Business Rules Via Distributor and Collector Via Audit.
What actions are possible with work status? 2 Using it only with entity and time type dimensions Bypassing it while executing a data management package Linking it to multiple hierarchies for an Application Launching it from the content library.
User1 is the 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.
What is the dimension type that is required for effecting currency translations? Currency Type Flow Type Entity Type Rate Type.
What DIM is same for all models in consolidation setup? Category & time Category, entity, time Category, group, time Category, group, Time, Entity.
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.
Which of the following can you say about members of a dimension? Three correct answers Members with no children are called Base-level Members Members with children are Parents Parents members have a calculate 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 Interco to Entity Currency to Entity.
Which property is optional for account type dimensions? SCALING ICMATCH RATETYPE ACCTYPE.
Which implementation step is mandatory to set up an on-the-fly KPI calculation? Add the "Formula" property to the account member. Execute a data management package. Update the "system_constants" file. Add the library file "mdxlib.lgl" to the options sheet of the account member.
What limitations exist for dimension properties in BPC 10.0 for NetWeaver? Properties with more than 60 characters cannot be used for dimension 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 hierarchy to a dimension? Maintain the dimension property. Refresh the dimension members. Maintain the dimension members. Process the dimension.
What is the maximum length? 3 ID dimension -> 16 caracteres ID dimension property -> 20 caracteres Dimension member -> 32 caracteres Dimension property name -> 40 caracteres.
What is best business practice to execute multiple iterations of a budgeting process in BPC? Create a separate dimension. Create a separate property. Create a separate dimension member. Create a separate application.
Processing a dimension does the following. 3 Validate Dimension member formulas. Validate Hierarchy. Update member data into BW. BW Attribute change run. .
How do hierarchies in BPC for Microsoft differ from those in BPC for NetWeaver? They must be balanced. They are limited to a total of 12 per dimension. They are kept as separate dimensions in the database. They are time dependent.
How do you model cost center rollups by profit center when planning is done by cost center? With a profit center property in the cost center dimension With a user defined dimension for the profit center With a profit center hierarchy by cost center With a cost center hierarchy by profit center.
What implementation step is required to add a new hierarchy for a dimension member? Insert 'PARENTH2' column after 'PARENTH1' within the dimension member sheet. Insert the hierarchy name into the 'APPROVALORG' web application parameter. Insert the hierarchy name to the 'TOPDOWN' web application parameter. Insert 'PARENTH2' into the dimension property list.
What are valid MDX expansion options? 3 ANY BEFORE LEAVES AFTER SELF.
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. .
Which of the following are required when writing data via an excel template? 2 Parent members can be written to the InfoCube Only base-level members can be written to the InfoCube The page key range must contain base-level members for all dimension 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? Switch template to an input schedule Activate member recognition in the sheet options Switch type from report to input form Activate as input form in the sheet option.
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.
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? Select apply to local member default format Select apply for calculated member default format Select apply for imputable member default format Select apply for changed member default format.
Where stored the Comments? Cube DSO Real time cube Table.
Which steps 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. Check in the input form for the pop-ups to appear.
Only one is correct. There can be 1 driver dimension or 1 model There can be only 1 driver dimension for 1 model There can be n driver dimensions for N Models There can be max 5 driver dimensions for a single model.
Every Environment has a two 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.
What step is required when setting up Finance or Consolidation Model compared to other Models? Select copy options Select source Model // Select source Application Select Model options // Select Application options Modify Application.
Which dimension type is optional for a model? Audit type Category type Time type Account type.
What program can you use to validate the consistency of an environment after copying the standard environment? UJA_DATA_CHECKER UJA_COPY_APPSET UJA_APPSET_INFO UJT_CHECK_TABLE_ENTRIES.
Which of the statements below are correct in regards to BW? 2 InfoCubes are made up of Fact and Dimension tables. A BW Dimension table is exactly the same as an Business Planning and Consolidation Dimension. BW Characteristics have three potential types of master data. There are two main types of InfoObjects: Catalogs and InfoAreas. .
What is BW object equivalent to a BPC Model? Infocube Infoobject DSO Infoarea Table.
What object in SAP BW is an equivalent to an Application in SAP BPC for NetWeaver? 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? 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? Financial Processes Data Management Reporting Management System Administrative.
You want to use a data manager package to load data from an InfoProvider in BPC for NetWeaver. What is supported? 2 Loading data from an InfoCube, but not from a DataStore Object Using JavaScript in the transformation files Mapping only one key figure to the target data although source data has multiple key figures Selecting data pertaining to specific master data values to load.
Which of the following is possible in the data loading process in BPC for NetWeaver? Using multiple conversion files for a single dimension without additional coding Using the download function to move files from the local hard drive to the data file folder Using a transformation file without a conversion file Using Visual Basic 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? Package 1,2,4 and 5 ran Package 1,2 ran, packages 4 and 5 did not ran Packages 1 and 2 were rolled back, package 4 and 5 ran Packages 1 and 2 were rolled back, package 4 and 5 did not ran.
A step is re-opened? What is the next step status? Open Re-open Pending Delayed Approved.
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? Enter ACCPAY in the external column and %EXTERNAL% in the internal column. Enter ACCPAY in the internal column and *SKIP in the external column. Enter ACCPAY in the external column and *SKIP in the internal column. Enter ACCPAY in the internal column and %EXTERNAL% in the external column.
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? 0 700 -1 701 .
Which folder must store the conversion files? Company Drive Wizard Books.
You want existing records to be deleted first before writing new records. What option do you choose while running a data management package? Merge Replace and Clear Clear Clear and Append.
Which of the following are required for an import? Conversion Flat File Transformation Dynamic Template.
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 CURRENCY = %RPTCURRENCY_SET% RATEENTITY = %ENTITY_SET% ACCOUNT = %ACC_SET% Rate type is missing TCURR table is missing.
What is missing in the script logic on the screenshot in BPC for NetWeaver?
*RUN_PROGRAM CURR_CONVERSION
CATEGORY = %C_CATEGORY_SET%
TID_RA = %TIME_SET%
RATEENTITY = GLOBAL
ENTITY = %ENTITY_SET%
*ENDRUN_PROGRAM Logic for entity type dimension Keyword %CURRENCY_SET% Logic for account type dimension Logic for currency type dimension.
Which dimension type is optional for a model? A-Account T-Type D- Audit C-Category.
You execute the following Script Logic, Logic1.lgf by running a data manager package, without transferring any further parameters and without using default logic.
What is the scope of the calculation?
*WHEN ACCOUNT
*IS ACCOUNT1
*REC (FACTOR=1.5, ACCOUNT=ACCOUNT2)
*ENDWHEN
*COMMIT
Only input schedule ACCOUNT1 and ACCOUNT2 Only current view All data within the database.
What value is assigned to the ACCOUNT3 with the following Script Logic?
*WHEN ACCOUNT
*IS ACCOUNT1, ACCOUNT2
*REC (FACTOR=1, ACCOUNT=ACCOUNT3)
*ENDWHEN
*COMMIT
Sum of ACCOUNT1 and ACCOUNT2 Difference of ACCOUNT1 and ACCOUNT2 Quotient of ACCOUNT1 and ACCOUNT2 Product of ACCOUNT1 and ACCOUNT2.
What transaction code allows you to access the 'system_constants.lgf' and 'MDXlib.lgf' files in BPC for NetWeaver? UJFS UJ00 UJKT UJR0.
To what is the term 'ROUND' in the script logic of the attached figure referring? Parameter used in the BAdI Filter value in the BAdI Technical name of the BAdI Enhancement spot of the BAdI.
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? TREND FORECAST SPREAD WEIGHT.
Which function do you use to display a dimension name? EPMDimensionOverride EPMDimensionProperty EPMDimensionList EPMDimensionType.
A KPI should be calculated centrally, on-the-fly, and be available to all reports. Which implementation option do you choose? Worksheet Logic Business Rules Dimension Member Formulas Script Logic.
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? [NOTRANS] [AS_IS] [COPYLC] [END].
All configurations in UJ_VALIDATION is _____Specific. Model Environment Dimension DSO (DataSource Object).
What is a restriction for BPC validation rules in BPC for NetWeaver? A BPC validation rule cannot use a BAdI implementation. Multiple BPC validation rules cannot be applied to multiple dimension members of a dimension. Multiple BPC validation rules cannot refer to the same dimension member. A BPC validation rule cannot refer to multiple driver dimensions.
Where are the archived reports stored in BW? Cube SAO Write DSO Real Time cube Tables.
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.
For which dimension type can you activate a data audit trail for a model? Entity Time Account Category .
Where do you set up the data audit for transactional data? BPC Admin BPC excel interface Web Admin parameters at environment level Web Admin parameters at model level.
Where do you set the data audit to capture transactional data changes? At Appset level in Admin Console At Appset level in Web Admin At Application level in Admin Console At Application level in Web Admin.
What interfaces can you use during the step Define Action when setting up a BPF? Manage Books, BPC Web, BPC for Word BPC Administration, BPC for Excel, BPC for Word Data Audit, BPC for Excel, BPC for PowerPoint Journal, BPC for Excel, BPC for Word.
What are the required dimensions to create the BPF instances? Time Time and category Category Entity, category and Time.
What are the Out of the Box solution for loading the transaction data load? 2 Load transaction data from SAP NetWeaver BI using an Open Hub destination that provides flat files to data manager (Delta Load) Load transaction data from SAP NetWeaver BI InfoCubes directly using data manager custom process type (Delta Load) Load transaction data via flat file via SAP NetWeaver BI dataflow . Load transaction data via UD Connect (SAP NetWeaver BI dataflow) Load Transaction Data via Flat File using BPC Data Manager.
What solution for uploading transactional data into BPC for NetWeaver requires customer-specific process types? Loading data in delta mode from a BW InfoCube using BPC Data Manager Loading data from a flat file using BPC Data Manager Loading data from a DataStore Object using BPC Data Manager Loading data in delta mode from BW using an Open Hub destination that provides flat files for BPC Data Manager.
What are the Out of the Box solution for loading the master data load? 2 Load Master Data from SAP ERP directly into BPC, version for SAP NetWeaver Load Master Data from SAP NetWeaver BI Characteristics Directly Using Data Manager Flat file by Data Manager Flat File in BW.
What solution for uploading master data into BPC for NetWeaver requires customer-specific process types? Loading data directly into the dimension member sheet Loading data via a flat file using BPC Data Manager Loading data via a flat file using SAP BW Loading data from a SAP BW InfoObject into a BPC dimension using BPC Data Manager.
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.
Where all the data is integrated? Model Dimension Property Members.
What option do we have to undo up to the last five changes in a report? Undo/Back Exclude Revert Change.
I want to record data in a report without entering the data of the base member but when executing it, it gives me an error and it does not allow it. How can I solve that? 2 Member selector en el EPM Context Change Work sheet Expand to see the childrens Include the base members and children.
How do I access the selector member? From the organization of rows and columns EPM context Sheet option EPM Pane.
How do I manage the EPM Pane? From the Member selection From the organization of rows and columns Sheet option Business rules.
|
