Question 1
Question
During testing you notice that account descriptions are missing.
How do you resolve this issue?
Answer
-
Import master data descriptions
-
Refresh dimension members
-
Import transaction data
-
Import master data hierarchies
Question 2
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?
Please choose the correct answer.
Answer
-
GROUP_CURRENCY
-
RATETYPE
-
CURRENCY_TYPE
-
FX_TYPE
Question 3
Question
For which dimension type can you activate a data audit trail for a model?
Answer
-
E – Entity
-
T – Time
-
A – Account
-
C – Category
Question 4
Question
Which data management option is required to load transaction data from a file to an SAP BusinessObjects Planning and Consolidation Application? Please choose the correct answer.
Question 5
Question
Which package group is customer-specific in SAP BusinessObjects Planning and Consolidation for NetWeaver?
Answer
-
Financial Processes
-
Data Management
-
Reporting Management
-
System Administrative
Question 6
Question
Which dimension type is optional for a Model?
Answer
-
Data source type
-
Category type
-
Time type
-
Account type
Question 7
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.
-
Process the dimension.
Question 8
Question
Which implementation step is mandatory to set up an on-the-fly KPI calculation?
Answer
-
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 memb
Question 9
Question
A KPI should be calculated centrally, on-the-fly, and be available to all reports.
Which implementation option do you choose?
Question 10
Question
Which EV functions can support the posting process of an Input Schedule?
Note: There are two (2) correct answers to this question.
Answer
-
EVDRE
-
EVGTS
-
EVCOM
-
EVMNU
-
EVHOT
Question 11
Question
Which objects do not get transported in SAP BusinessObjects Planning and Consolidation for NetWeaver?
Answer
-
MultiProviders
-
Business Rules
-
Roles
-
Journal Templates
Question 12
Question
Where is archived 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 DataStore Object
Question 13
Question
What settings are possible for restricting data access for a given work state?
Note: There are 2 correct answers to this question.
Answer
-
Administrator
-
Reviewer
-
Owner
-
Manager
-
Assistant
Question 14
Question
What components are needed to run business rules?
Note: There are 3 correct answers to this question.
Answer
-
Business Rule
-
Dimension Logic
-
Conversion File
-
Data Manager Package
-
Script Logic
Question 15
Question
Which function is used to perform a better or worse comparison of two values?
Please choose the correct answer.
Question 16
Question
Which parameter in the options list of a transformation file is available only in BPC for the SAP NetWeaver technology platform?
Answer
-
DELIMITER
-
SELECTION
-
VALIDATERECORDS
-
AMOUNTDECIMALPOINT
Question 17
Question
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 dimension will you look at to fix the problem?
Answer
-
Account
-
RptCurrency
-
InputCurrency
-
Groups
Question 18
Question
What Application option do you have to select when you create an Application to make intercompany eliminations?
Answer
-
Account Transformation
-
Validation Rules
-
Balance Carry Forward
-
Automatic Adjustment
Question 19
Question
What activities are possible while running a data management package in BPC for NetWeaver?
Note: There are 3 correct answers to this question.
Answer
-
Loading data from InfoProviders
-
Importing master data attributes
-
Importing master data hierarchies
-
Importing transaction data
-
Importing master data descriptions
Question 20
Question
You want to use a data manager package to load data from an InfoProvider in BPC for NetWeaver. What is supported?
Note: There are 2 correct answers to this question.
Answer
-
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
Question 21
Question
How do hierarchies in BPC for Microsoft differ from those in BPC for NetWeaver?
Question 22
Question
What dimensions can be referenced to each other?
Note: There are 2 correct answers to this question.
Answer
-
Time to Category
-
Flow to Account
-
Account to Rate
-
Intco to Entity
-
Currency to Entity
Question 23
Question
Which property is optional for account type dimensions?
Answer
-
SCALING
-
ICMATCH
-
RATETYPE
-
ACCTYPE
Question 24
Question
Which application type is optional in BPC for consolidation of investments and currency translation?
Answer
-
Financial
-
Ownership
-
Rate
-
Consolidation
Question 25
Question
Which properties are required to carry out currency translation for legal consolidation?
Note: There are 2 correct answers to this question.
Answer
-
DIMLIST in the account type dimension
-
FX_DIFFERENCE_ONLY in the category type dimension
-
RATETYPE in the account type dimension
-
STORE_GROUP_CUR in the currency type dimension
-
CURRENCY in the entity type dimension
Question 26
Question
The legal application is set to YTD storage. What would a BPC report display compared to a database view?
Note: There are 2 correct answers to this question.
Answer
-
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 PERIODIC, cash would match but not revenue.
-
If the measure is set to YTD, both revenue and cash accounts would match.
Question 27
Question
When validating the 'FXTrans.LGF' file, you get a validation error stating that the currency dimension is missing a property.
What property is missing?
Answer
-
PARENT_GROUP
-
GROUP_CURRENCY
-
STORE_GROUP_CURR
-
CURRENCY_TYPE
Question 28
Question
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?
Answer
-
[AS_IS]
-
[NOTRANS]
-
[COPYLC]
-
1
Question 29
Question
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?
Answer
-
The user needs to execute the task one more time
-
The formula is incorrect and needs to be modified
-
The logic is correct but the system is doing something wrong
-
The data is not available for F_TMP3 flow
Question 30
Question
To what destination members is the script logic in the attached figure writing the records?
Answer
-
SquareFootage account for all base level entities
-
LeaseCost account for all base level entities
-
SquareFootage account for all entities
-
GlobalOps account for all entities
Question 31
Question
For which calculation do you have to use a different implementation method than Business Rules?
Answer
-
Automatic adjustment
-
Account transformation
-
Allocation
-
Currency conversion
Question 32
Question
What is missing in the script logic on the screenshot in BPC for NetWeaver?
*RUN_PROGRAM CURR_CONVERION
CATEGORY = %CATEGORY_SET%
TID_RA = %TIME_SET%
RATEENTITY = GLOBAL
OTHER = [ENTITY=%ENTITY_SET%]
*ENDRUN_PROGRAM
Answer
-
Logic for entity type dimension
-
Keyword %CURRENCY_SET%
-
Logic for account type dimension
-
Logic for currency type dimension
Question 33
Question
What is displayed in the report, based on the screenshot of the Control Panel settings?
Note: There are 2 correct answers to this question.
Answer
-
Total for time in the last column
-
Total for time in the first column
-
Net income and all members for accounts in the rows
-
All base members for accounts except net income in the rows
Question 34
Question
What rows are displayed in an EVDRE report for the MemberSet 'SELF,DEP'?
Answer
-
The member as defined within the PageKeyRange 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 base members
-
The member as defined within the CurrentView and all its dependants
Question 35
Question
Which parameters are mandatory for a EVDRE function?
Note: There are 2 correct answers to this question.
Answer
-
KeyRange
-
OptionRange
-
FormatRange
-
ExpandRange
-
Application
Question 36
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 37
Question
What is displayed in an EVDRE report when 'Account1, Account2' is in the PageKeyRange, with entity in the rows and time in columns?
Answer
-
Aggregated data for Account1 and Account2
-
All Accounts other than Account1 and Account2
-
Account1 and Account2 in separate rows
-
Account1 and Account2 in separate columns
Question 38
Question
Which fields are required to eliminate the investment when using the All Formula?
Note: There are two (2) correct answers to this question.
Answer
-
Source Account
-
Destination All Account
-
Destination Group Account
-
Destination Equity Account
-
Destination Minority Interest
Question 39
Question
Which settings do you need to make for the Source Account to calculate the annual net income (ANI) for the liability account? Please choose the correct answer.
Answer
-
Revenue and Cost, Destination Account = ANI, reverse sign
-
Expense, Destination Account = Revenue and ANI, reverse sign
-
Revenue and Cost, Destination Account = ANI, do not reverse sign
-
Expense, Destination Account = Revenue and ANI, do not reverse sign
Question 40
Question
Who is notified when a step is completed using Business Process Flow?
Please choose the correct answer.
Answer
-
BPF Reviewer
-
BPF Manager
-
BPF Owner
-
BPF User
Question 41
Question
For which scenario is it impossible to use the work status?
Please choose the correct answer.
Answer
-
To track the progress of a planning process
-
To lock a step in a Business Process Flow
-
To allow or disallow a user to modify data
-
To lock a region of data in an Application
Question 42
Question
User1 is the parent owner and user2 is the child owner. What happens when user2 sets a work status?
Note: There are three (3) correct answers to this question.
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 43
Question
What is the transaction code for accessing the file service in the NetWeaver backend?
Answer
-
UJCS
-
UJ_VALIDATION
-
UJFS
-
FILE_SERVICE
Question 44
Question
Что соответсвует в NW приложению BPC
Answer
-
InfoCube
-
Real-time infocube
-
DSO
-
ABAP Table
Question 45
Question
When executing the ownership calculation you receive an error message. You therefor analyze the group/entity structure in the attached screenshot. Which method is missing in the consolidation method?
[Entity] - [Cons Method: Generated / Current]
JP - 100 Full / 100 Full
AU - 100 Full / 100 Full
CN - 100 Full / 100 Full
US - 100 Full / 100 Full
CA - 100 Full / 100 Full
Answer
-
E - Equity
-
P - Proportional
-
G - Global
-
H - Holding
Question 46
Question
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?
Answer
-
Same as in the destination account column
-
Same as in the source account rate type column
-
Same as in the source flow column
-
Same as in the formula column
Question 47
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 PowerPoint
-
Journal, BPC for Excel, BPC for Word
Question 48
Question
What actions are possible with work status?
Note: There are 2 correct answers to this question.
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 49
Question
What tasks are accomplished during full optimization in BPC for NetWeaver?
Note: There are 2 correct answers to this question.
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 50
Question
Where do you set the data audit to capture transactional data changes?
Answer
-
At Appset (Env) level in Admin Console
-
At Appset (Env) level in Web Admin
-
At Application (Model) level in Admin Console
-
At Application (Model) level in Web Admin
Question 51
Question
You want existing records to be deleted first before writing new records. what option do you choose while running a DM package
Answer
-
replace and clear
-
clear and append
-
clear
-
merge
Question 52
Question
What steps are required to save new members from the membersheet to the database
2 answers
Question 53
Question
What is the best business practice to execute multiply iterations of budgeting in BPC
Answer
-
Create a separate dimension
-
Create a separate dimension member
-
create a separate property
-
Create a separate application
Question 54
Question
What steps are required when setting up Finance and Consolidation App compared to others
Answer
-
select source app
-
modify app
-
select copy options
-
select app options
Question 55
Question
*START_BADI DEMO …
Что такое DEMO?
Answer
-
Техническое имя BADI
-
Name of Enhansment spot
-
Filter value of the BADI
Question 56
Question
В опция файла трансформации указано CONVERT_INTERNAL=NO. Необходимо пропустить данные Acc1 при загрузке транзакционных данных
Answer
-
Acc1 (External), *SKIP (internal) in transformation file
-
*SKIP (External), Acc1 (internal) in transformation file
Question 57
Question
Ваша загрузка закончилась ошибкой (700 отклоненных записей), какое значение параметра MAXREJECTCOUNT нужно поставить, чтобы загрузка не зависела от числа отклоненных записей
Question 58
Question
Что из следующего являются MDX параметрами развертки (3 отв )
Answer
-
AFTER
-
LEAVES
-
SELF
-
BEFORE
-
ANY
Question 59
Question
What needs to run before ownership elimination
Answer
-
currency translation
-
intercompany booking
-
carry forward
-
account transformation
Question 60
Question
After creating the dimension in the BPC frontend Admin what you can change in the backend of netweaver BW