Ricardo Zárate
Quiz by , created more than 1 year ago

SAP BPC 10.0 Certification

107
3
0
Andrey Tamashenko
Created by Andrey Tamashenko over 8 years ago
Ricardo Zárate
Copied by Ricardo Zárate over 8 years ago
Close

C_EPMBPC_10 part 2

Question 1 of 60

1

During testing you notice that account descriptions are missing.
How do you resolve this issue?

Select one of the following:

  • Import master data descriptions

  • Refresh dimension members

  • Import transaction data

  • Import master data hierarchies

Explanation

Question 2 of 60

1

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.

Select one of the following:

  • GROUP_CURRENCY

  • RATETYPE

  • CURRENCY_TYPE

  • FX_TYPE

Explanation

Question 3 of 60

1

For which dimension type can you activate a data audit trail for a model?

Select one of the following:

  • E – Entity

  • T – Time

  • A – Account

  • C – Category

Explanation

Question 4 of 60

1

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.

Select one of the following:

  • Run the data management package

  • Organize the package list

  • Download the data file

  • Maintain data management

Explanation

Question 5 of 60

1

Which package group is customer-specific in SAP BusinessObjects Planning and Consolidation for NetWeaver?

Select one of the following:

  • Financial Processes

  • Data Management

  • Reporting Management

  • System Administrative

Explanation

Question 6 of 60

1

Which dimension type is optional for a Model?

Select one of the following:

  • Data source type

  • Category type

  • Time type

  • Account type

Explanation

Question 7 of 60

1

How can you add a property other than a hierarchy to a dimension?

Select one of the following:

  • Maintain the dimension property

  • Refresh the dimension members.

  • Maintain the dimension members.

  • Process the dimension.

Explanation

Question 8 of 60

1

Which implementation step is mandatory to set up an on-the-fly KPI calculation?

Select one of the following:

  • 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

Explanation

Question 9 of 60

1

A KPI should be calculated centrally, on-the-fly, and be available to all reports.
Which implementation option do you choose?

Select one of the following:

  • Worksheet Logic

  • Business Rules

  • Dimension Member Formulas

  • Script Logic

Explanation

Question 10 of 60

1

Which EV functions can support the posting process of an Input Schedule?
Note: There are two (2) correct answers to this question.

Select one or more of the following:

  • EVDRE

  • EVGTS

  • EVCOM

  • EVMNU

  • EVHOT

Explanation

Question 11 of 60

1

Which objects do not get transported in SAP BusinessObjects Planning and Consolidation for NetWeaver?

Select one of the following:

  • MultiProviders

  • Business Rules

  • Roles

  • Journal Templates

Explanation

Question 12 of 60

1

Where is archived audit data stored in BPC for the SAP NetWeaver technology platform?

Select one of the following:

  • In a flat file

  • In a BW InfoCube

  • In a BW table

  • In a DataStore Object

Explanation

Question 13 of 60

1

What settings are possible for restricting data access for a given work state?
Note: There are 2 correct answers to this question.

Select one or more of the following:

  • Administrator

  • Reviewer

  • Owner

  • Manager

  • Assistant

Explanation

Question 14 of 60

1

What components are needed to run business rules?
Note: There are 3 correct answers to this question.

Select one or more of the following:

  • Business Rule

  • Dimension Logic

  • Conversion File

  • Data Manager Package

  • Script Logic

Explanation

Question 15 of 60

1

Which function is used to perform a better or worse comparison of two values?
Please choose the correct answer.

Select one of the following:

  • EVPRP

  • EVGTS

  • EVPRO

  • EVBET

Explanation

Question 16 of 60

1

Which parameter in the options list of a transformation file is available only in BPC for the SAP NetWeaver technology platform?

Select one of the following:

  • DELIMITER

  • SELECTION

  • VALIDATERECORDS

  • AMOUNTDECIMALPOINT

Explanation

Question 17 of 60

1

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?

Select one of the following:

  • Account

  • RptCurrency

  • InputCurrency

  • Groups

Explanation

Question 18 of 60

1

What Application option do you have to select when you create an Application to make intercompany eliminations?

Select one of the following:

  • Account Transformation

  • Validation Rules

  • Balance Carry Forward

  • Automatic Adjustment

Explanation

Question 19 of 60

1

What activities are possible while running a data management package in BPC for NetWeaver?
Note: There are 3 correct answers to this question.

Select one or more of the following:

  • Loading data from InfoProviders

  • Importing master data attributes

  • Importing master data hierarchies

  • Importing transaction data

  • Importing master data descriptions

Explanation

Question 20 of 60

1

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.

Select one or more of the following:

  • 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

Explanation

Question 21 of 60

1

How do hierarchies in BPC for Microsoft differ from those in BPC for NetWeaver?

Select one of the following:

  • 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.

Explanation

Question 22 of 60

1

What dimensions can be referenced to each other?
Note: There are 2 correct answers to this question.

Select one or more of the following:

  • Time to Category

  • Flow to Account

  • Account to Rate

  • Intco to Entity

  • Currency to Entity

Explanation

Question 23 of 60

1

Which property is optional for account type dimensions?

Select one of the following:

  • SCALING

  • ICMATCH

  • RATETYPE

  • ACCTYPE

Explanation

Question 24 of 60

1

Which application type is optional in BPC for consolidation of investments and currency translation?

Select one of the following:

  • Financial

  • Ownership

  • Rate

  • Consolidation

Explanation

Question 25 of 60

1

Which properties are required to carry out currency translation for legal consolidation?
Note: There are 2 correct answers to this question.

Select one or more of the following:

  • 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

Explanation

Question 26 of 60

1

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.

Select one or more of the following:

  • 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.

Explanation

Question 27 of 60

1

When validating the 'FXTrans.LGF' file, you get a validation error stating that the currency dimension is missing a property.
What property is missing?

Select one of the following:

  • PARENT_GROUP

  • GROUP_CURRENCY

  • STORE_GROUP_CURR

  • CURRENCY_TYPE

Explanation

Question 28 of 60

1

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?

Select one of the following:

  • [AS_IS]

  • [NOTRANS]

  • [COPYLC]

  • 1

Explanation

Question 29 of 60

1

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?

Select one of the following:

  • 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

Explanation

Question 30 of 60

1

To what destination members is the script logic in the attached figure writing the records?

Select one of the following:

  • SquareFootage account for all base level entities

  • LeaseCost account for all base level entities

  • SquareFootage account for all entities

  • GlobalOps account for all entities

Explanation

Question 31 of 60

1

For which calculation do you have to use a different implementation method than Business Rules?

Select one of the following:

  • Automatic adjustment

  • Account transformation

  • Allocation

  • Currency conversion

Explanation

Question 32 of 60

1

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

Select one of the following:

  • Logic for entity type dimension

  • Keyword %CURRENCY_SET%

  • Logic for account type dimension

  • Logic for currency type dimension

Explanation

Question 33 of 60

1

What is displayed in the report, based on the screenshot of the Control Panel settings?
Note: There are 2 correct answers to this question.

Select one or more of the following:

  • 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

Explanation

Question 34 of 60

1

What rows are displayed in an EVDRE report for the MemberSet 'SELF,DEP'?

Select one of the following:

  • 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

Explanation

Question 35 of 60

1

Which parameters are mandatory for a EVDRE function?
Note: There are 2 correct answers to this question.

Select one or more of the following:

  • KeyRange

  • OptionRange

  • FormatRange

  • ExpandRange

  • Application

Explanation

Question 36 of 60

1

How do you allow data entry and posting in a BPC Excel sheet?

Select one of the following:

  • 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.

Explanation

Question 37 of 60

1

What is displayed in an EVDRE report when 'Account1, Account2' is in the PageKeyRange, with entity in the rows and time in columns?

Select one of the following:

  • 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

Explanation

Question 38 of 60

1

Which fields are required to eliminate the investment when using the All Formula?
Note: There are two (2) correct answers to this question.

Select one or more of the following:

  • Source Account

  • Destination All Account

  • Destination Group Account

  • Destination Equity Account

  • Destination Minority Interest

Explanation

Question 39 of 60

1

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.

Select one of the following:

  • 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

Explanation

Question 40 of 60

1

Who is notified when a step is completed using Business Process Flow?
Please choose the correct answer.

Select one of the following:

  • BPF Reviewer

  • BPF Manager

  • BPF Owner

  • BPF User

Explanation

Question 41 of 60

1

For which scenario is it impossible to use the work status?
Please choose the correct answer.

Select one of the following:

  • 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

Explanation

Question 42 of 60

1

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.

Select one or more of the following:

  • 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.

Explanation

Question 43 of 60

1

What is the transaction code for accessing the file service in the NetWeaver backend?

Select one of the following:

  • UJCS

  • UJ_VALIDATION

  • UJFS

  • FILE_SERVICE

Explanation

Question 44 of 60

1

Что соответсвует в NW приложению BPC

Select one of the following:

  • InfoCube

  • Real-time infocube

  • DSO

  • ABAP Table

Explanation

Question 45 of 60

1

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

Select one of the following:

  • E - Equity

  • P - Proportional

  • G - Global

  • H - Holding

Explanation

Question 46 of 60

1

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?

Select one of the following:

  • 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

Explanation

Question 47 of 60

1

What interfaces can you use during the step Define Action when setting up a BPF?

Select one of the following:

  • 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

Explanation

Question 48 of 60

1

What actions are possible with work status?
Note: There are 2 correct answers to this question.

Select one or more of the following:

  • 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

Explanation

Question 49 of 60

1

What tasks are accomplished during full optimization in BPC for NetWeaver?
Note: There are 2 correct answers to this question.

Select one or more of the following:

  • 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

Explanation

Question 50 of 60

1

Where do you set the data audit to capture transactional data changes?

Select one of the following:

  • 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

Explanation

Question 51 of 60

1

You want existing records to be deleted first before writing new records. what option do you choose while running a DM package

Select one of the following:

  • replace and clear

  • clear and append

  • clear

  • merge

Explanation

Question 52 of 60

1

What steps are required to save new members from the membersheet to the database
2 answers

Select one or more of the following:

  • change the flag "take system offline"

  • maintain dim members

  • process dims

  • maintain dim property

  • save to server

Explanation

Question 53 of 60

1

What is the best business practice to execute multiply iterations of budgeting in BPC

Select one of the following:

  • Create a separate dimension

  • Create a separate dimension member

  • create a separate property

  • Create a separate application

Explanation

Question 54 of 60

1

What steps are required when setting up Finance and Consolidation App compared to others

Select one of the following:

  • select source app

  • modify app

  • select copy options

  • select app options

Explanation

Question 55 of 60

1

*START_BADI DEMO …
Что такое DEMO?

Select one of the following:

  • Техническое имя BADI

  • Name of Enhansment spot

  • Filter value of the BADI

Explanation

Question 56 of 60

1

В опция файла трансформации указано CONVERT_INTERNAL=NO. Необходимо пропустить данные Acc1 при загрузке транзакционных данных

Select one of the following:

  • Acc1 (External), *SKIP (internal) in transformation file

  • *SKIP (External), Acc1 (internal) in transformation file

Explanation

Question 57 of 60

1

Ваша загрузка закончилась ошибкой (700 отклоненных записей), какое значение параметра MAXREJECTCOUNT нужно поставить, чтобы загрузка не зависела от числа отклоненных записей

Select one of the following:

  • 0

  • -1

  • 700

  • 701

Explanation

Question 58 of 60

1

Что из следующего являются MDX параметрами развертки (3 отв )

Select one or more of the following:

  • AFTER

  • LEAVES

  • SELF

  • BEFORE

  • ANY

Explanation

Question 59 of 60

1

What needs to run before ownership elimination

Select one of the following:

  • currency translation

  • intercompany booking

  • carry forward

  • account transformation

Explanation

Question 60 of 60

1

After creating the dimension in the BPC frontend Admin what you can change in the backend of netweaver BW

Select one of the following:

  • Base of unit of measure

  • Authorization relevant field

  • Conversion routine

  • Nothing

Explanation

Previous
Next