Which of the following journal parameters are available for a model? Balanced by Entity Balanced by Currency Allow Journals to be reopened Enforce Balanced Journal.
You want to use specific default values when you add data manually from the web client. How can you achieve this? select the "activate Member recognition" option select the "Use as Input Form" option specify the default members for reporting specify the default members for data input.
You are working in a 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 fileds to change? Version Client Fiscal year InfoProvider.
Identify the action required for The value of Planning and Consolidation Marketing Operations Directing Analyze.
You are configuring comments in BPC Embedded. Which objects are required?
There are 2 correct answers to this question. A system-generated data table A Characteristics as key figure A CompositeProvider An Adavanced DataStore Object.
What is the maximum length of a characteristic value in BPC Embedded? 1333 characters 250 characters 32 Characters 255 characters.
What is a restriction for BPC validation rules in BPC for NetWeaver? Multiple BPC validation rules cannot be applied to multiple dimension members of a dimension. A BPC validation rule cannot refer to multiple driver dimensions. A BPC validation rule cannot use a BAdI implementation. Multiple BPC validation rules cannot refer to the same dimension member.
How to use a consolidation monitor
there are 3 correct answers to this question Business contents Administration Consolidation status Control status Work status.
How to reset the consolidation status? Dim list changes All over changes Changes in master data Set up changes.
What is entered in the group account when you configure AR/AP intercompany eliminations and adjustment business rule? the offset account the intercompany AP account the intercompany AR account the same value as in the destination minority account.
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 in delta mode from BW using an Open Hub destination that provides
flat files for BPC Data Manager Loading data from a flat file using BPC Data Manager Loading data from a DataStore Object using BPC Data Manager.
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?
There are 2 correct answers to this question. POWN SYS - percent ownership_system calculation PCON SYS - percent consolidation_system calculatiion PCTRL - percent control POWN - percent ownership PCON - percent consolidation.
When a user tries to log in to an Application using BPC for Excel, the Application does not appear in the list of available Applications the user just created. What is the problem? The member access profile is not correct. The user is not created correctly. The Application is not created correctly. The task profile is not correct.
You have created controls and a user has teasted 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? Assign the control set to the following period. Change the work status in the Consolidation Monitor for the following period. Grant authorization to the user to view the controls for the following period. Assign the control level to the following period.
Which of the following values can you use in the destination flow to configure the currency translation business rule?
There are 2 correct answers to this question. base level members property values blank descendents.
A report has been created with products in the rows displayed in a hierarchy. You would like to display the product members and parents in different colors based on the relative position in the hierarchy.
Which of the following options in the EPM add-in will allow you to accomplish this?
There are 2 correct answers to this question. Formatting on Specific Level Formatting on Specific Member/Property Highlight Selected Hierarchies Calculate Parents in Hierarchies.
Which of the following steps are mandatory if you want to perform a transport from the development system to the production system(administration)?
There are 2 correct answers to this question. select planning and consolidation objects in the BW transport collector run the transport-create request (UJBPCTR) transaction run a full optimization take the environment offline.
You are working in a BPC Standard system. For which of the following models do you have to create at least two "Drivers and Rates" type models? Consolidation Financial Standard Ownership.
You are the administrator on a BPC 11.0 for SAP BW/4HANA system. You need to optimize an Advanced DataStore Object by activating the data. What happens when you do this?
Note: There are 2 correct answers to this question. Delta merge is triggered. Redundant records are aggregated. Dimensions are optimized. Transaction sequence numbers are closed.
Which tool can you use in the EPM Office Add-in Excel to email a list of static files?
There are 2 correct answers to this question. portal publication distribution book publication worksheet generation.
You need to develop a BW query for SAP BPC 11.0. What should you use? BW Modeling Tool Model Extension Tool RTC Modeling Tool BEx Query Designer.
You select a parent in the detailed section of the control definition. Which of the following options do you choose to ensure that the control will be executed for each member of the selected parent? Breakdown Dimemsion Control Level Threshold Tolerance Equation Type.
What do you have to create to capture the data from multiple planning iterations? properties dimensions members models.
For which dimension type can you activate a data audit trail for a model? Time Entity Category Account.
Which of the following business Rules can you use in a financial models? method-based multipliers methods Elimination and adjustment currency translation.
How can characteristic relationships be used?
Note:There are 3 correct answers to this question. To derive data based on BW hierarchies. To disaggregate based on reference data. To distribute data based on valid combinations. To check combinations based on S/4HANA data. To delete data based on invalid combinations.
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 journal an input schedule an excel report a web report.
What rows are displayed in an EVDRE report for the Member Set 'SELF, DEP'? The member as defined within the PageKeyRange and all its base members The member as defined within the CurrentView and all its dependants The member as defined within the CurrentView and all its base members The member as defined within the PageKeyRange and all its dependants.
Which tasks can you perform using the Consolidation Monitor in BPC embedded?
Note: There are 3 correct answers to the question. Run reclassification Run ownership calculation Run planning function Run US Elimination Run controls.
Which implementation step is mandatory to set up an on-the-fly KPI calculation? Add the library file "mdxlib.lgl" to the options sheet of the account member. Update the "system_constants" file. Execute a data management package. Add the "Formula" property to the account member.
How can an Aggregation Level be used? To determine the level of granularity. As an InfoProvider for consolidation models To store summary data. As an InfoProvider for planning queries As an InfoProvider for characteristic relationships.
What transaction code allows you to access the 'system_constants.lgf' and
'MDXlib.lgf' files in BPC for NetWeaver? UJR0 UJ00 UJKT UJFS.
You are working in a BPC Embedded System.What Options do you have when
maintaining members and properties of local dimensions? Add a member that does NOT exist in a global dimension. Enable time dependent properties. Update property values for global members. Delete global members.
To what is the term 'ROUND' in the script logic of the attached figure referring? Enhancement spot of the BAdI Filter value in the BAdI Parameter used in the BAdI Technical name of the BAdI.
What information is needed when you configure the interface between EPM
office Add-In Excel and BEx query to enable the BW drill through? The OKCODE parameter The technical names of the InfObject The filter IOBJNM VALUE parameters The URL of the BEx query The technical field names of the Dimensions.
You are using SAP BPC Optimized for SAP S/4HANA. Which InfoProvider stores the comment entered Input-ready query? VirtualProvider DataStore Object CompositeProvider Real-Time InfoCube.
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? A BPC transport is in process. The workbook is offline. The system is saving a new member to a dimension. The InfoProvider is set to 'Load mode'.
What does a Dynamic Filter do? ADD-IN Use members in a referenced cell as filter values. None Just a process.
Give one word for-The cell where the comment is retrieved or stored Row Cell Column Grid.
What are the features Add-in The Excel Interface?
There are 2 correct answers to this question SPSS Distribution and collection Create reports CRM BOCF.
When you create a new model from an existing model, which items can be copied?
There are 2 correct answers to this question. Journal templates Transaction data Data Manager packages Control definitions.
Find out the components of Planning and Consolidation
There are 2 correct answers to this question Infrastructure layer Navigation pane Action pane Business layer.
You are working in a BPC Embedded system. Which objects are needed to run a calculation based on custom HANA SQL?
There are 2 correct answer to this question. Function type method class Native HANA table Data foundation.
When does the DEFAULT.LGF logic script run? When data is refreshed When data is sent from an input form When table-based logic is executed When business rules are executed.
You execute the following Script Logic Logic1.lgf by running a data manager
package, without transferring any further parameters and without using default
logic.
*WHEN ACCOUNT
*IS ACCOUNT1
*REC (FACTOR=1.5, ACCOUNT=ACCOUNT2)
*ENDWHEN
*COMMIT
What is the scope of the calculation? Only current view Only input schedule All data within the database ACCOUNT1 and ACCOUNT2.
You CANNOT view the final data in Real Time Consolidation. What could be the issue?
There are 2 correct answers to this question. The data needs to be validated. The work state needs to becomplete. The entity needs to be approved. The process needs to be submitted.
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? SPREAD TREND WEIGHT FORECAST.
You want existing records to be deleted first before writing new records. What
option do you choose while running a data management package? Replace and Clear Merge Clear and Append Clear.
Which infoProvider can access data from ACDOCA?
Note:There are 2 correct answers to this question. /ERP/SFIN_V01 /ERP/SFIN_R01 /ERP/SFIN_V20 /ERP/SFIN_M01.
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.
If 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?
Note:There are 2 correct answers to this question. Material group is a data declaration. Key figure is a field to change. Material group is a field to change. Key figure is a data declaration.
You are using BPC Embedded. In the BPC web client, a user can Access
Evironment #1 but not Environment #2. What change is required for the user to
access Environment #2? Assign a data access profile to the user. Add the user to the 'RSBPC_ID' authorization object. Add the user to the BPC team. Assign an Analysis Authorization to the Environment.
a user has measures containing plan and actual data within the columns of a
crosstab.How can you crate a dynamic variance using standard Analysis for
Office features?
Note: There are 2 correct answers to the question. Use a new Line rule type. Use a VB script. Use an MS Excel formula. Use the Calculation from the Analysis ribbon.
You need to run a planning sequence while data is being saved. Which object do
you attach the planning sequence to? Planning query Process chain Advanced DataStore Object Composite Provider.
What are the implementation factors required to start a project
there are 3 correct answers to this question Layoff Scope Menu Project objectives Timeline.
When using US eliminations, which dimensions must you include in the model?
There are 2 correct answers to this question. Group Flow Time Entity.
What is entered in the destination group account when replacing the US elimination business rule with the automatic adjustment business rule? Same value as in the destination minority account Intercompany accounts payable account Intercompany accounts receivable account Value of the ELIMACC property of account dimension.
Which properties are required to carry out currency translation for legal consolidation?
Note: There are 2 correct answers to this question. FX_SOURCE_CATEGORY REPORTING MD RATE_PERIOD.
What all are the elements involved in making Analysis Levels
There are 3 correct answers Behavioral Attitude Strategic Tactical Operational.
Which of the following tasks can you perform using a Data Manager package deliverd by SAP?
There are 3 correct answers to this question. Export master data to SAP ECC. Export transcation data to a flat file. Load transaction data from a BW InfoProvider. Execute a Badl. Load master data and texts from a BW InfoObject.
Which if the following dimension types are required?
There are 4 correct answers to this question. Currency Time Entity Intercompany Category Account.
What is an advantage of using Web reports over of EPM reports? web reports suport multiple dimensions in the rows and columns web reports use a thin client web reports can access data from multiple sources web reports support EPM functions.
What are the two deployment scenarios
There are 2 correct answers to this question Targets only Services only Only Production Development to production.
What steps are required to save new members from the member sheet to the database of the admin console?
There are 2 correct answers to this question. Change the flag 'Take system off-line'. Process dimension. Maintain dimension members. Maintain dimension property. Save to server.
What determines the user access to BPC Applications?
There are 2 correct answers to this question. Secured dimensions Profile SAP_ALL User/team assignment Member access profile.
Running control could include the following steps. Identify them.
there are 2 correct answers to this question Contents Dimensions Review Control data Hyper links Run Control.
What needs to run before ownership elimination? Currency translation Account transformation Intercompany booking Carry forward.
Which of the following options do you use to calculate KPIs on the fly? Business Rules Dimension Member Formulas Script Logic Worksheet Logic.
To what destination members is the script logic in the attached figure writing
the records? SquareFootage account for all entities LeaseCost account for all base level entities SquareFootage account for all base level entities GlobalOps account for all entities.
What tasks can be done using the Web Administration?
There are 2 correct answers to this question. Adjusting the version number of a report template Setting up file types Activating but not deactivating auditing Changing documents type but not document subtype.
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? AdavancedDataStore Object InfoCube MultiProvider InfoObject.
What step is required to configure data audit for BPC standard? Add a parameter to data manager packages Activate the collection of data by model. Add a global parameter in Customizing(SPRO). Activate the collection of data by environment.
You are building an EPM report and would like to leverage local members. What
can you use to maintain local members?
There are 3 correct answers to this question. Excel formulas. Report editor. Dimension member formulas Row axis.
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. PCON is changed to 55 PCON is changed to 100 Method is changed to New Method is changed to 'Holding'.
Which of the following delivered task profiles allows you to maintain
environment? System Admin primary Admin secondary admin system security.
You are configuring consolidation for BPC Standard. Which dimensions be the
same for consolidation, rate, and ownership models?
There are 2 correct answers to this question. Category Time Account Entity.
Where do you change a BPC report to an input schedule? In the workbook options In the Web Admin Dashboard In the PageKeyRange In the EVDRE report.
You are using BPC Standard 11.0. Which of the following do you define in the US Elimination Business Rule?
There are 3 correct answers to the question. Source accounts Multiplers Architecture Entity dimension Source audit.
You are Working in a BPC Standard system. Which of the following dimension types can be used as reference dimensions for referential integrity?
There are 2 correct answers to this question. Time Audit Entity Subtables.
The access rights you can assign to the sets of members are
There are 3 correct answers to this question Accept Follow Read only Write Denied.
A KPI should be calculated centrally, on-the-fly, and be available to all reports.
Which implementation option do you choose? Worksheet Logic Script Logic Dimension Member Formulas Business Rules.
Which are the following elements responsible for Business Performance Optimization?
There are 2 correct answers to this question Enterprise Performance Management Employee Management Business Intelligence Customer Relationship Management.
Which of the following rules are based on business rules (models)?
There are 3 correct answers to this question. Driver-based calculation Allocation Elimination and adjustment Account-based calculation Currency translation.
You are working in BPC Standard. Which of the following calculation options is
HANA optimization? Consolidation logic Dimension member formulas Local member formulas Business rules.
Which property of the currency dimension is required for currency translation? PARENT GROUP STORE GROUP CURR CURRENCY TYPE GROUP CURRENCY.
Which tasks can you perform using the Consolidation Monitor in BPC embedded?
Note: There are 3 correct answers to the question. Run US Elimination Run controls Run reclassification Run ownership calculation Run planning function.
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 data access profile is not assigned to the user's team the data access profile is assigned to the user's team the task profile is assigned to the user's team the task profile is not assigned to the user's team.
A customer wants to load certain accounts with both local and reporting
currencies without doing a currency translation. What expression in the formula
of the business rule for currency conversion would leave the reporting currency
value unchanged? [COPYLC] [AS_IS] [END] [NOTRANS].
What are the steps required to configure controls
there 3 correct answers to this question Enable work status for the model Assign security task for control Managerial drill Create control sets Work status.
Which package groups are delivered by SAP in SAP Business Objects Planning
and Consolidation for Netweaver?
There are 2 correct answers to this question. other function data management financial process reporting management.
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?
There are 2 correct answers to this question. Model parameters in Customizing (SPRO) The Enable Comments indicator in model features The Show as Microsoft Excel Comments checkbox Environment parameters in Customizing (SPRO).
Which dimensions or properties can you use to determine the rule type and
source values in a currency translation business rule?
Note:There are 2 correct answers to this question. GROUP_CURRENCY CURRENCY FLOW RATETYPE.
Script logic can be broken in to 3 components. List them.
There are 3 correct answers to this question Volume Multiple settings Scoping Body/ code Writing the record.
For which users does the system prevent saving templates to the company
folder?
(Choose two) For a team leader without the Manage Template task For a team leader with the Manage Template task For a non admin user with the Manage Template task For a user with the Primary Admin default function task For a non admin user without the Manage Template task.
Which steps are required to use data acccess profiles in BPC Embedded?
Note:There are 2 correct answers to this question. Set the model dimensions to be authorization relevant Assign authorizations to the environment Set a characteristic to be authorization relevant Assign authorizations to the user.
The attached figure shows a script logic written in BPC for NetWeaver. The
dimensions, except for time and account, are all restricted to a single base level
member.
The account type dimension has 40 dimension members. How many records are
written on execution of this script logic? 480 12 1 40.
Which prerequisites must be fulfilled if you want to display planning and
consolidation daa in dashboard designer?
There are 2 correct answers to this question. A BPC data grid must be used in the dashboard A runtime connection must exist between the planning and consolidation system
and the dashboard An EPM report must be created A list of models must be generated in the EPM report.
What allows you to type the Dimension Member values in your worksheet
Choose the correct answers Member Recognition Formatting Status reports Profiles.
Which dimension 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 E-Entity R-Currency T-Time G-Group.
What step is required when setting up Finance or Consolidation Application
compared to other Applications? Select copy options Select source Application Select Application options Modify Application.
You are working in BPC 11.0 Embedded. Which design parameters are available
for a Journal Template?
There are 2 correct answers to this question Enable Auto Reverse Allow Journals to be Recopened Enforce Balanced Journal Enable Ungrouping.
Identify the factors involved in Business Process Flow
there are 2 correct answers to this question Codes Levels Items Costs Benefits.
For which calculation do you have to use a different implementation method
than Business Rules? Currency conversion Account transformation Automatic adjustment Allocation.
Which user account do you need to log onto SAP BPC version for NetWeaver? Windows AD ECC BW CMS.
Three types of parameters are used in BO BPC, identify them System Parameters Functional parameters Configuration parameters Analytical parameters Conceptual parameters.
What is displayed in the report, based on the screenshot of the Control Panel
settings?
There are 2 correct answers to this question. Total for time in the first column All base members for accounts except net income in the rows Total for time in the last column Net income and all members for accounts in the rows.
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.
Which model types are required to consolidate investments?
There are 3 correct answers to this question. Standard Consolidation Ownership Financial Exchange Rates.
Which of the following conventions apply to dimension property Ids?
There are 2 correct answers to this question. 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 character.
The legal application is set to YTD storage. What would a BPC report display compared
to a database view?
There are 2 correct answers to this question. If the measure is set to PERIODIC, cash would match but not revenue. If the measure is set to PERIODIC, both inventory and equity account would match. If the measure is set to YTD, an investment account would match but a liability account
would not. If the measure is set to YTD, a goodwill account would match but minority interest would
not If the measure is set to YTD, both revenue and cash accounts would match.
You have two models: one for Expense, and another for Sales. Both models have the
same Profit center dimention. 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 to accomplish this requirement?
There are 2 correct answers to this question. The 'outerdimension' option. 'EPM RetrieveData' formulas. The 'repeat row headers' property. 'Shared axis' reporting.
Which of the following functions do you use to load data from a flat file to a model?
Please choose the correct answer. Data Preview Download Data Organize Package Run Package.
Business warehouse, Planning and consolidation Leads to…….? None of the above Enterprise Performance Management Research Development Organizational Development.
In Analysis for Office you have an input-ready query with accounts in the rows and all
periods (month) 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?
There are 2 correct answers to this question. The total remains as 1500. The non-locked cells will update to 150. The non-locked cells will update to 130. The total will be changed to 1700.
What is the maximum length of a dimension member ID in SAP BusinessObject Planning
and Consolidation version for NetWeaver? 32 characters 500 characters 20 characters 255 characters.
Which of the following calculations uses only logic script? Reclassification Allocation currency translation Ownership calculation.
What do you do when you mantain dimensions data manually and want to return to the
previous unsaved values? Choose display Choose restore Choose revert Choose back.
Which default function task type always includes Appset maintenanc System Primary Administration Secondary.
Identify three function category from the following
There are 3 correct answers to this question PCL function EPM functions EV Functions FPMXL client. Technical Category BSNL.
The consolidation monitor displays a blank screen for the current period although the
previous period has been displayed properly. What could be the reason for this? No master data exist No ownership records exist No exchange rate records exist No trial balance exist.
What activities are possible while running a data management package in BPC
for NetWeaver? Importing transaction data Importing master data descriptions Importing master data attributes Loading data from InfoProviders.
You enter data using EPM Office Add-inn excel. When you attempt to save the data, you
receive 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?
There are 2 correct answers to this question. restrict rows and columns to base member change the header dimensions to base members set the expand option to "member and children" change the calc property of the parent members to N.
Which business rules are used in the consolidation monitor (Choose three) Account-based calculations Eliminations and adjustments Global definitions Currency translation US eliminations.
When you enter a new value into a cell manually, you want the cell color to switch to a
different color. How to you configure the formatting sheet to achieve this?
Please choose the correct answer. select apply for Inputable Member Default Format select apply for Calculated Member default Format select apply for changed Member Default format select apply to Local Member default Format.
You need to work with BPC Embedded environments. What are your options?
There are 2 correct answers to this question. Change the description. Copy with reference. Create from scratch. Change the status.
You want to create a PD book that contains PDF files by cost center for the current year
based on an EPM report, and publish it in the library.
Which of the following steps are required when you create the publication template?
There are 2 correct answers to this question. assign a time varible to the publication template include the cost center dimension in the page axis in the publication template assign the EPM report to the publication template include the cost center dimension in the fixed keys in the publication template assign the cost center to the variable members of the publication template.
You want to calculate revenues as a product of the unit sold and price for unit and save
the results in database. How can you achieve this? Use the logic script Use business rules Use the dimension member formulas Use the worksheet logic.
Your customer needs a blank input template that allows users to enter product groups
as needed and plan revenue for them.
The BW Query has product group 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? 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. Product group is set to display based on "Characteristic Relationships".
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? Same as in the formula column Same as in the destination account column Same as in the source account rate type column Same as in the source flow column.
What program can you use to validate the consistency of an application set after
copying the standard application set? UJA_DATA_CHECKER UJA_COPY_APPSET UJA_APPSET_INFO UJT_CHECK_TABLE_ENTRIES.
The Account type dimension consists of three properties? What are they
there are 3 correct answers to this question Mid list Dim list Up list Account type Rate type.
What are the components of Process Template Components?
there are 3 correct answers to this question Instance Dimensions Flat file control Costs Process Monitors.
How to set a work status in the consolidation monitor.
there are 2 correct answers to this question Changes in data Choose work status Only refresh Choose an entity and click work status Click refresh to see the update status.
SAP guidelines recommend that you make what changes directly in SAP BW on BPCgenerated
objects?
Please choose the correct answer. Switch case sensitivity off. Change the data lengths of characteristics. Switch hierarchies to time dependent. Change no objects at all.
What dimensions can be referenced to each other?
There are 2 correct answers to this question. Currency to Entity Flow to Account Intco to Entity Account to Rate Time to Category.
Which of the following methods does the Shared Query Engine (SQE) use to retrieve
data from database?
There are 2 correct answers to this question. cell query RSDRI query MDX query axis query.
Which of the following dimension type can be used as reference dimension?
There are 2 correct answers to this question. D-Audit T-Time E-Entity S-Subtables G-Group.
To add custom dimensions automatically to BPC Optimized structures,what do you use? Model Extension Tool RTC Modeling Tool. Planning Application Kit BW Modeling Tool.
What value for the property DATASRC_TYPE in the datasource dimension allows you to
identify system postings? M - Manual I - Input A - Automatic L - Level.
What is missing in the following currency translation logic script if you want to translate
local currency to reporting currency in a financial model?
*RUN_PROGRAM CURR_CONVERSION CATEGORY=%CATEGORY_SET% TID_RA=%TIME_SET%
RATEENTITY=%ENTITY_SET% *ENDRUN PROGRAM logic for the account type dimension logic for the entity type dimension logic for the currency type dimension logic for the group type dimension.
What solution for uploading master data into BPC for NetWeaver requires customerspecific
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.
You are working in a BPC Standard system and you want to check the member
combinations for incoming transection data. Which step is mandatory? Implement a BAdI. Activate the validations for the environment. Configure controls. Assign a driver dimension to the validation rule.
Who is notified when a step is completed using Business Process Flow? BPF User BPF Reviewer BPF Manager BPF Owner.
Which steps are mandatory if you want to implement the work status?
There are 3 correct answers to this question. define at least one hierarchy in the owner dimension enable data audit for the model define the reviewer property in the owner dimension define the owner property in the owner dimension enable data locking in the model.
Find out the Environment models from the following
There are 3 correct answers to this question Social Responsibilities Financial Reporting HR Planning Political Planning Sales Planning.
Where do you activate the parameter that is used to automatically refresh the input
form when you open it (input forms and report)? EPM - sheet options EPM - User option EPM - Command display options EPM - context options.
All model types must have the following dimension type Machine Resources Time Money.
There are three types of versions available in Business Process Flow Templates: identify
There are 3 correct answers to this question BOPC Draft Pro-active Deployed Inactive.
The parent company D owns 91% of company A, 51% of company B and 49% of
company C. which company can use the equity method? a b c d.
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 advanced package settings define the logic script file in the package link define the logic script file in the process chain.
What implementation step is required to add a new hierarchy for a dimension
member? Insert the hierarchy name into the 'APPROVALORG' web application parameter. Insert 'PARENTH2' column after 'PARENTH1' within the dimension member sheet. Insert 'PARENTH2' into the dimension property list. Insert the hierarchy name to the 'TOPDOWN' web application parameter.
Who is notified when an activity is submitted in the Business Process Flow? Manager Performer Reviewer Owner.
During testing you notice that account descriptions are missing. How do you
resolve this issue? Import master data descriptions Import transaction data. Refresh dimension members Import master data hierarchies.
In which section of the transformation file do you define the source InfoObject? Mapping Conversion Selection Options.
Which property is optional for account type dimensions? RATETYPE SCALING ICMATCH ACCTYPE.
What are valid MDX expansion options?
There are 3 correct answers to this question. AFTER ANY LEAVES BEFORE SELF.
You are configuring work status in BPC Embedded environment 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? By using a customer implementation By using a reference dimension By using an external dimension By using a property.
Which hierarchy is used in the consolidation monitor? Group Hierarchy Ownership-based Hierarchy Intercompany-based Hierarchy Entity Hierarchy.
You reopen a step in a business process flow. What will to status of the next step be? open reopened rejected delayed.
You are working in BPC Standard. Which dimensions must be identical in all
models that use the Exchange Rate Model? Time Account Category Currency.
Which data source types are processed by the balance Carry Forward rule?
Note:There are 2 correct answers to this question. manual Input Level Automatic.
A transformation file has the option CONVERT_INTERNAL = NO. The records
pertaining to account ACCPAY should not be loaded through your data
management package.
How do you configure the conversion file? Enter ACCPAY in the internal column and %EXTERNAL% in the external column. Enter ACCPAY in the external column and %EXTERNAL% in the internal column. Enter ACCPAY in the external column and *SKIP in the internal column. Enter ACCPAY in the internal column and *SKIP in the external column.
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? Account dimension - RATETYPE property Currency dimension - CURRENCY TYPE property Account dimension - ACCTYPE property Entity dimension - FX_TYPE property.
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? both the revenue value and the comment in a DataStore Object the revenue data in a infocube and the comment in a DataStore Object the revenue data in a infocube and the comment in another database table both the revenue value and the comment in a Infocube.
Which objects do not get transported in SAP BusinessObjects Planning and
Consolidation for NetWeaver? Journal Templates MultiProviders Business Rules Roles.
What can you use to prevent the insertion of records into the DataBase in SAP
BusinessObject Planning and Consolidation? data audit controls book publication work status.
How to use a consolidation monitor Business contents Work status Administration Control status Consolidation status.
You are using BPC Embedded and want ot plan on new members. You decide to
import class. What are the function type parameters? Parent ID InfoProvider Property ID InfoObject Member ID.
You are working in a BPC Standard system. Which are unique settings of the
ownership model?
Note:There are 2 correct answers to this question. Parent child property Use as source data Non-Interco Member Enable comments.
What does a consolidation model contains?
there are 2 correct answers to this question Income statement Balance sheet data Proactive data Accounts Only contents.
Data is loaded only in the 'F_OPE' flow/subtable. When executing the currency
translation for the first time, the CTA_ACT in F_CTA is empty. What is the
problem with the logic? The data is not available for F_TMP3 flow. The formula is incorrect and needs to be modified. The user needs to execute the task one more time. The logic is correct but the system is doing something wrong.
What are the components of Process Template Components?
there are 3 correct answers to this question Flat file control Instance Dimensions Process Monitors Costs.
What tasks are accomplished during full optimization in BPC for NetWeaver?
There are 2 correct answers to this question. Creating a copy of the MultiProvider for the BPC Application Updating DB statistics for the InfoCube Closing the open request after posting 50,000 records Compressing and indexing the InfoCube Executing a data model analysis and alerting if the data model can be improved.
Which of the following options can you use for drill through? RFC connection based on the selected cell RFC connection based on the current view URL based on the current view URL based on the selected cell.
User1 is the parent owner and user2 is the child owner. What happens when user2 sets a work status?
There are 3 correct answers to this question. 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 "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 "Both", user1 and user2 can post a journal.
|
