Question 1
Question
Your customer wants to use a unique business rule to translate currency for selected entities. Which property do you set for the selected entities to meet this requirement?
Answer
-
GROUP_CURRENCY
-
CURRENCY_TYPE
-
RATETYPE
-
FX_TYPE
Question 2
Question
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?
Answer
-
[COPYLC]
-
[NOTRANS]
-
1
-
[AS_IS]
Question 3
Question
For which dimension type can you activate a data audit trail for a model?
Answer
-
Account
-
Time
-
Entity
-
Category
Question 4
Question
Which business rules are used in the consolidation monitor?
(Choose three)
Question 5
Question
What limitation exist for dimension properties in BPC 10.0 for Netweave?
Answer
-
No more than 20 properties can be created for a given member.
-
Properties with more than 60 characters cannot be used for dimension member formulas.
-
Properties cannot be deleted once they are created
-
Property size can only be increased, not decreased.
Question 6
Question
What benefits does BPC offer to a corporation?
(Choose 2)
Answer
-
It gives the IT department control over budgeting and planning functions.
-
It integrates with the Microsoft Office suite including Word, Excel and Powert Point
-
It enables compilance with IFRS and SOX
-
It enables you to drill through to the SAP ECC system for reporting
Question 7
Question
Which of the following delivered components cause quick implementation in Planning and Consolidation?
(Choose three)
Question 8
Question
Which of the following could be some examples of the impact of implementing SAP BPC?
(Choose three)
Answer
-
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
Question 9
Question
What limitations exist for dimension properties in BPC 10.0 for Netweaver?
Answer
-
Properties cannot be deleted once they are created
-
Property size can only be increased, not decreased.
-
No more than 20 properties can be created for a given member.
-
Properties with more than 60 chararcers cannot be used for a dimension member formulas.
Question 10
Question
How can you add a property other than a hierarchy to a dimension?
Answer
-
Maintain the dimension property
-
Refresh the dimension members
-
Maintain the dimension members
-
Proccess the dimension
Question 11
Question
Which dimension type can be used to track openning and closing balance?
Answer
-
Intercompany
-
Datasource
-
Category
-
Subtable
-
Group
Question 12
Question
What is the best business practise to execute a multiple iteratons of a budgeting process in BPC?
Answer
-
Create a separate dimension
-
Create a separate property
-
Create a separate dimension memeber
-
Create a separate application
Question 13
Question
Which implementation step is mandatory to set up an on-the-fly KPI calculation?
Answer
-
Add a "Formula" property to the account member.
-
Execute a data manager package
-
Update the "system_constants" file
-
Add the library file "mdxlib.lgl" to the option sheet of the account member.
Question 14
Question
A KPI should be calculated centrally, on-the-fly, and be available to all reports. Which implementation option do you choose?
Question 15
Question
Which of the following are valid for a BPC Dimension?
(Choose 2)
Answer
-
Equivalent to BW Characteristic
-
Equivalent to a BW Dimension
-
Contain three types of master data
-
Can have multiple hierarchies
Question 16
Question
Which of the following can you say about members of a dimension?
Answer
-
Members with no children are called Based-level Members
-
Members with childrens are Parents
-
Parents members have a calc value of NO
-
Members have properties that can be used in reporting
Question 17
Question
Which dimension type is optional for a model?
Answer
-
D-Audit
-
T-Time
-
C-Category
-
A-Account
Question 18
Question
What dimension types are mandatory from the applications (models) type Financial?
(Choose 2)
Answer
-
C-Category
-
D-Audit
-
T-Time
-
I-Intercompany
Question 19
Question
Which dimension type is optional for an Application (Model)?
Answer
-
Data source type
-
Category type
-
Time type
-
Account type
Question 20
Question
The four required dimension types for any model include:
(Choose 4)
Answer
-
Intco Dimension
-
Category
-
Account
-
Time
-
Entity
-
Request ID
Question 21
Question
What is a BW object equivalent to a BPC Model?
Answer
-
Info Cube
-
Info object
-
DSO
-
Info area
-
Table
Question 22
Question
Transaction data is described by:
Answer
-
Infocube
-
Dimension
-
Appset
-
Dimension members
-
Calculated KFs
Question 23
Question
The ownership account contains:
(Choose 3)
Answer
-
Percentages
-
Methods
-
Parent Positions
-
Entity
-
Rates
Question 24
Question
Which of the following application options are common between Finance and Consolidation Application?
(Choose 4)
Answer
-
Currency Conversion
-
Calculation
-
Intercompany Elimination
-
Validations
-
US Elimination
-
Openning Balance
Question 25
Question
What object in business wharehouse is equivalent to an application (Model) in BPC?
Answer
-
Basic Infocube
-
Realtime Infocube
-
Multiprovider
-
Transactional Infocube
Question 26
Question
Every AppSet (Environment Shell) has a 2 character AppSet Prefix stored in a table called UJA_APPSET_INFO. This prefix can be used in a technical name of:
(Choose 3)
Answer
-
Infoarea
-
infoobject
-
Infoobject Catalog
-
Infocube
-
Multiprovider
Question 27
Question
What applications do you need for Consolidation as a mandatory application?
Answer
-
Legal
-
Ownership
-
Rate
-
Intercompany Matching
-
Finance
Question 28
Question
For the budgeting process, you need to extrapolate a base amount across 12 months with a gowth factor of 3%
What modeling function do you use?
Answer
-
TREND
-
FORECAST
-
SPREAD
-
WEIGHT
Question 29
Question
How do you allow data entry and posting in a BPC Excel sheet?
Answer
-
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
Question 30
Question
Which function do you use to display a dimension name?
Answer
-
EPMDimensionOverride
-
EPMDimensionProperty
-
EPMDimensionList
-
EPMDimensionType
Question 31
Question
Your customer wants to load certains accounts with both local and report currencies without doing a currency conversion. Which expression in the formula of the business rule for currency conversion can you use to achieve this?
Answer
-
[NOTRANS]
-
[AS_IS]
-
[COPYLC]
-
1
Question 32
Question
Which of the following options can you use for drill through?
Answer
-
RFC Connection based on the current view
-
URL based on the current view
-
URL based on the selected cell
-
RFC Connection based on the selected cell
Question 33
Question
Which of the following are the options for the drill through feature?
(Choose 2)
Answer
-
A BW Web report
-
ECC
-
Website
-
A BW Excel report
Question 34
Question
When use drill through , the member id that is passed into ECC would include which of the following?
Question 35
Question
Which of the following are valid business reasons to use the ECC Drill through?
(Choose 2)
Question 36
Question
Which of the following are required for a BW query drill through?
Question 37
Question
Which of the following are required for a ECC drill through?
(Choose 3)
Question 38
Question
What settings do you need for Source Account to calculate the liability account annual net income (ANI)?
Answer
-
Expense, Destination Account = Revenue and ANI, do not reverse sign
-
Revenue and Cost, Destination Account = ANI, do not reverse sign
-
Revenue and Cost, Destination Account = ANI, reverse sign
-
Expense, Destination Account = Revenue and ANI, reverse sign
Question 39
Question
A KPI should be calculated centrally, on-the-fly, and be available to all reports. Wich implementation option do you
Question 40
Question
Which of the following is required to run formulas in script logic files as data is written to the database?
(Choose 1)
Question 41
Question
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
Question 42
Question
Which of the following is required to run formulas in script logic file as data is written to the database?
Question 43
Question
What components are needed to run business rules?
Answer
-
Business Rule
-
Dimension logic
-
Conversion field
-
Data Manager Package
-
Script logic
Question 44
Question
Which 2 functions can be used using script logic and business rules?
(Choose 2)
Answer
-
Carry Forward
-
Validation (Controls)
-
Automatic adjustments
-
Currency translation
Question 45
Question
Which business rules are used in the consolidation monitor?
(Choose 3)
Question 46
Question
What value is used in the destination flow column of the currency conversion businees rule when there is no subtabe type dimension in the Application?
Answer
-
Same as in the destination account column
-
Same as in the source account rate type column
-
Same as in the in the flow column
-
Same as in the formula column
Question 47
Question
Your customer wants to use a unique business rule to translate currency for selected entities. Which property do you set for the selected entities to meet this requeriment?
Answer
-
GROP_CURRENCY
-
RATETYPE
-
CURRENCY_TYPE
-
FX_TYPE
Question 48
Question
The currency conversion setup includes wich of the following?
Answer
-
A rate aplication wich is referenced to the legal application and stores the exchange rates used to translate into the reporting and group currencies.
-
The currency property of the entity dimension which designates the local operating currency of legal subsidiaries normally
-
Rate type property in the account dimension which determines the rate and logic to be used in translation
-
Tcurr table which stores exchange rates such as sport and historical
-
Currency business rules
-
The currency data manager package and process chain
Question 49
Question
Which of the following are included in the currency translation process?
(Choose 2)
Answer
-
Account rate types are used to select accounts in the business rule table
-
Entity local currencies are read from the entity type dimension
-
The LC in the transaction data record is used to calculate group currency in the same record
-
Formula keywords are use to select exchange rates from the rate application
Question 50
Question
Which of the following modeling aspects are included in the rate application as delivered?
(Choose 2)
Question 51
Question
What value is the destination flow column of the currency conversion business rule when there is no subtable type dimension in the application?
(Choose 1)
Answer
-
Same as in the destination account
-
Same as in the source account rate type column
-
Same as in the source flow column
-
Same as in the formula column
Question 52
Question
Which of the following is/are true with regards to validations?
(Choose 3)
Answer
-
All validations configuration can be transported
-
Validations integrate with Activity audit
-
Authorizations is controlled by access to task profiles
-
Las changed date and time is stored in tables
-
Authorization is controlled by access to transaction code S-TRANS
Question 53
Question
Which of the following are features of Characteristic Validation?
(Choose 2)
Answer
-
Compare assets to liabilities and Owners equity
-
Prevent invalid combinations of Dimensions Members
-
Use a Badi for complex validation
-
Control journal, manual and Data manager activity by application
-
To lock and entity from changed data
Question 54
Question
While setting up validations in UJ_VALIDATIONS, we configure:
(Choose 3)
Question 55
Question
All configurations in UJ_VALIDATIONS are _________ specific:
Answer
-
Model
-
Environment
-
Dimension
-
DSO (Data Source Object)
Question 56
Question
What settings are possible for restricting data access for a given work state?
(Choose 2)
Answer
-
Administrator
-
Reviewer
-
Owner
-
Manager
-
Assistant
Question 57
Question
How do you control inserting records into the database in BPC?
Question 58
Question
For which scenario is it impossible to use the work status?
Answer
-
To allow or disallow a user to modify data
-
To lock a region of data in a application
-
To lock a step in a Business Process Flow
-
To track the status of a planning process
Question 59
Question
What actions are possible with work status?
(Choose 2)
Answer
-
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
Question 60
Question
User1 is the parent owner and user2 is the children. What happens when user2 sets a work status?
(Chose 3)
Answer
-
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
Question 61
Question
Which step is required to store a comment to a filled cell in an Excel pop-up in BPC for Net Weaver?
Answer
-
Save the Excel workbook locally
-
Enable comments in the Application parameters
-
Assign a keyword
-
Enable comments in the Application Set parameters
Question 62
Question
Comments are stored in:
Answer
-
Cube
-
DSO
-
Real Time cube
-
Table
Question 63
Question
What interfaces can you use during the step Define Action when setting up a BPF?
Answer
-
Manage Books, BPC Web, BPC for Word
-
BPC Administration, BPC for Excel, BPC for Word
-
Data Audit, BPC for Excel, BPC for Power Point
-
Journal, BPC for Excel, BPC for Word
Question 64
Question
Who is notified when a step is completed using Business Process Flow?
Answer
-
BPF User
-
BPF Manager
-
BPF Owner
-
BPF Reviewer
Question 65
Question
Who is notified when an activity is submitted in the Bussines Process Flow?
Answer
-
Performer
-
Manager
-
Owner
-
Reviewer
Question 66
Question
What are the required dimensions to create the BPF instances?
Question 67
Question
A step is re-opened? What is the next step status?
Answer
-
Open
-
Re-Open
-
Pending
-
Delayed
-
Approved
Question 68
Question
What components are needed to run business rules?
Answer
-
Business Rules
-
Dimension Logic
-
Conversion Fields
-
Data Manager Packages
-
Script Logic
Question 69
Question
What DIM is same for all models in consolidation step?
Question 70
Question
What applications do you need for Consolidation as mandatory application?
Answer
-
Legal
-
Ownership
-
Rate
-
Intercompany Matching
-
Finance
Question 71
Question
Which fields are required to eliminate the investment when using the All Formula?
(Choose 2)
Answer
-
Source Account
-
Destination All
-
Account
-
Destination Group Account
-
Destination Equity Account
-
Destination Minority Interest
Question 72
Question
What needs to run before ownership elimination?
Answer
-
Account transformation
-
Carry Forward
-
Currency translation
-
Intercompany book
Question 73
Question
What fields are required to eliminate the investment when using the "All Formula"?
(Choose 2)
Answer
-
Source Account
-
Destination group account
-
Destination equity account
-
Destination minority interest
-
Destination All Account
Question 74
Question
How manu journal templates are in a model?
Answer
-
N no of journal templates
-
Only one journal template per application
-
Based on the no of dimensions
-
Journal templates are app specific
Question 75
Question
For which users does the system prevent saving templates to the company folder?
(Choose 2)
Answer
-
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
Question 76
Question
What determines the user access to BPC applications?
(Choose 2)
Answer
-
Profile SAP_ALL
-
Secured Dimensions
-
Member acces profile
-
User/Team assignment
Question 77
Question
Which objects do not get trasported in SAP Business Objects Planning and Consolidation for Net Weaver?
Answer
-
Multiproviders
-
Business Rules
-
Roles
-
Journal Templates
Question 78
Question
Where is achieved audit data stored in BPC for the SAP Netweaver technology platform?
Answer
-
In a flat file
-
In a BW InfoCube
-
In a BW table
-
In a Data Store Object
Question 79
Question
Where do you set the data audit to capture transactional data changes?
Answer
-
At Appset level in Admin Console
-
At Appset level in Web Admin
-
At Application level in Admin Console
-
At Application level in Web Admin
Question 80
Question
For which dimension can you activate a data audit trail for an Application?
Answer
-
Category
-
Account
-
Time
-
Entity
Question 81
Question
What data managment option is required to load transaction data from a file to a BPC application?
Question 82
Question
What task are accomplished during full optimization in BPC for Netweaver?
(Choose 2)
Answer
-
Creating a copy of the MultiProvider for the BPC Application
-
Closing the open request after posting 50.000 records
-
Updating DB statistics for the InfoCube
-
Compressing and Indexing the InfoCube
-
Executing a data model analysis and alerting if the data model can be improved.
Question 83
Question
What is the consequences in BPC for Net Weaver when updating the web admin parameters without entering the required parameters?
Answer
-
Warnings
-
Nothing
-
Crashes
-
Errors
Question 84
Question
What task can be done using the Web Administration?
(Choose 2)
Answer
-
Changing documents type but not documents subtype
-
Activating but not deactivating auditing
-
Adjusting the version number of a report template
-
Setting up file types
Question 85
Question
Which of the following are required for an import?
(Choose 2)
Answer
-
Conversion
-
Flat File
-
Transformation
-
Dynamic Template
Question 86
Question
During testing you notice that account descriptions are missing. How do you resolve this issue?
Answer
-
Import transaction data
-
Import master data descriptions
-
Refresh dimension members
-
Import master data hierarchies
Question 87
Question
Which package group is customer-specific in SAP BO Planning and Consolidation for Net Weaver?
Answer
-
Financial Processes
-
Data Managment
-
Reporting Management
-
System Administrative
Question 88
Question
Procesing a dimension does the following:
Question 89
Question
Which objects do not get transported in SAP Business Objects Planning and Consolidation:
Answer
-
MultiProviders
-
Business Rules
-
Roles
-
Journal Templates
Question 90
Question
What program can you use to validate the consistency of an application set after copying the standar application set?
Answer
-
UJA_DATA_CHECKER
-
UJA_COPY_APPSET
-
UJA_APPSET_INFO
-
UJT_CHECK_TABLE_ENTRIES
Question 91
Question
Which default function task type always includes Appset maintenance?
Answer
-
Administration
-
Primary
-
System
-
Secondary
Question 92
Question
What solution for uploading master data into BPC for Netweaver requieres customer-specific process types?
Answer
-
Loading data directly into the dimension member sheet
-
Loading data via flat file using BPC Data Manager
-
Loading data via flat file using BW
-
Loading data from a SAP BW InfoObject into a BPC dimension using BPC Data Manager
Question 93
Question
Which parameter in the options list of a transformation file is available only in BPC for the SAP Net Weaver technology platform?
Answer
-
DELIMITER
-
SELECTION
-
VALIDATERECORDS
-
AMOUNTDECIMALPOINT
Question 94
Question
When you load the data to the BPC infoprovider you want to delete the existing data and reload the new data what options you use:
Question 95
Question
What are the out of the box solution for loading master data load?
(Choose 2)
Answer
-
Load Master Data from SAP ERP directly into BPC, version for SAP Netweaver
-
Load Master Data from SAP Netweaver BI Characteristic Directly using data manager
-
Flat file by DM
-
Flat file in BW
Question 96
Question
What are the out of the box solution for loading the transaction data load?
Answer
-
Load transaction data from SAP Netweaver BI using an Openhub 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 Dataflow)
-
Load transaction data via flat file using BPC Data Manager
Question 97
Question
Where are the achieved reports stored in BW?
Answer
-
Cube
-
SAO
-
Write DSO
-
Real Time Infocubes
-
Tables
Question 98
Question
Which of these transformations file options is unique for NW setup?
Answer
-
SELECTION
-
MAXREJECTCOUNT
-
VALIDATION
-
SELECT
Question 99
Question
Performance is critical to the BPC application. The use of light and full optimization is possible. What activity is unique to a full optimization?
Question 100
Question
What task are accomplished during full optimization in BPC for NW?
(Choose 2)
Answer
-
Creating a copy of the multiprovider for the BPC application
-
Closing the open request after posting 50.000 records
-
Upadating DB statistics for the Infocube
-
Compressing and indexing the Infocube
-
Executing a data model analysis and alerting if the data model can be improved
Question 101
Question
Which section of the transformation file would be used to assing BW Characteristic to BPC Dimensions?
(Choose 3)
Answer
-
Options
-
Mapping
-
Conversion
-
External and Internal
Question 102
Question
Which folder must store the conversion files?
Answer
-
Company
-
C Drive
-
Wizard
-
Books
Question 103
Question
Which component of BPC can be used to execute series of data manager packages in sequence?
Answer
-
Package
-
Package group
-
Package list
-
Package link
-
Package process
Question 104
Question
Which of the following objects are required when executing an upload of data into BPC using a data manager process?
Answer
-
Conversion files
-
Script logic
-
Transformation files
-
Trasnformation rule
-
Process chain
Question 105
Question
Which of the following task can be performed as a background job via process chain?
Answer
-
Copy Application
-
Modify Application
-
Optimized Application
-
Copy Appset