SAP BPC Interview Questions Total 596 ( 301 -400)

311.The Ownership Account contains

 Percentages

 Methods

 Parent Positions

 Entity

 Rates

Answer: Percentages,Methods and positions.

312.  Ownership data is collected and stored by entity and intco.

TRUE OR FALSE

TRUE

313.  In the ownership cube percentages and methods are stored by Entity

TRUE OR FALSE

TRUE

314.  Any user with "manage template task " can save and update objects to the company folder or team folder .

TRUE OR FALSE

TRUE

315.  When data is entered into YTD, its periodic values used for reporting purposes, are calculated as the difference between the current period and the last period.

TRUE OR FALSE

TRUE

316.  One can decide to store data in YTD or on a Periodic basis setting the AppSet Parameters .

TRUE OR FALSE

TRUE

317.  Info Area - App set .

318.  All dimensions in the application appear in the current view .

319.  Multiple single values or ranges are not allowed - Current View .

320.  The Current View is user dependent, therefore you will only be able to view information that your member access profile allows.

321.  "Work Book Option:Templates being used for reading have a workbook type of 'Report' whereas templates being for

both read and write have a type of 'Input Schedule'."

TRUE OR FALSE

TRUE

322.  Park n Go lock down the report or input schedule and the current view data.

TRUE OR FALSE

TRUE

323.  EvDRE is bidirectional; it can both send and retrieve data. It combines and extends the functionality of other BPC functions such as EvGET and EvSND.

TRUE OR FALSE

TRUE

324.  10 dimesion types

A E C T R G I D S U

325.What is the new dimension in 7.5

GROUP

326.What is IFRS and US GAAP? Which is more specific GAAP or IFRS ?

- GAAP is more specific .

327. BPC allows periodic or YTD data storage while BCS is always periodic.

TRUE OR FALSE

TRUE

328.The Microsoft versions have a soft limit of 20 dimensions per Application .

TRUE OR FALSE

TRUE

329.               InfoCubes used for Business Planning and Consolidation only contain one key figure.

TRUE OR FALSE

TRUE

330.               Request id’s stay ’open’ until a threshold of 50,000 records is reached. However,they can be closed by turning the request id green, switching from plan to load mode, or by running the ’close trans request’ function module.

TRUE OR FALSE

TRUE

331.               The BW F Fact table is similar to the Microsoft based Write Back and Fac2 table.The BW ’E’ Fact table is like the Microsoft Fact table.

332.When you create a BPC application – it creates a info cube, multi provider and a query.

333. Why a multiprovider is created when BPC application is created ?

334.Why a query is created when a BPC application is created ?

335. You can report on non-reporting application data, but you cannot assign work status codes to the data. In addition, you cannot define business rules to these application types.

336.When you create an application you reference an application and business rules ?

TRUE OR FALSE

TRUE

337.What are the components of BPC security ?

     Member access profile

     Task  profile

     Teams

     Users

338.               When you create new applications, you need to select at least one ’secure’ dimension. Then the member access profiles need to allow access to the desired members.

TRUE OR FALSE

TRUE

339.               If the carry forward business planning function is working because the following web application parameter is not set

     CARRYFORWARD

     OPENING BALANCE

     COPY OPENING

     BALANCE CARRYOVER

Answer : COPY OPENING

340.               If the YTD web admin parameter is set to YTD  then the data stored in the cube will

     Cash YTD measure and Revenue YTD measure will be the same.

     Cash periodic  measure and Revenue periodic measure will be the same.

     Cash YTD measure and Revenue YTD measure are different.

     Cash periodic  measure and Revenue periodic measure are different.

Answer: 2 are correct answers .

341.

     ’DIMLIST#’ properties are used to provide selection criteria in business rules.

     ’GROUP’ is used to designate an account as PL or BS.

     ’ELIMACC’ is used for US Elims and logic based eliminations in Microsoft typically.

     ’FORMULA’ is for dimension formulas.

342.      All of the properties which begin with ’ORG...’ are related to the Dynamic Hierarchy Editor .

TRUE OR FALSE

TRUE

343.      You cannot delete a dimension when it is being used by an application.

TRUE OR FALSE

TRUE

344.      C, A, E, I can be referenced to other dimensions.

     Category & Time – year common

     Account & Account – Rate Type property

     Entity & Currency – Local currency property

     Intercompany & Entity – Entity values

345.      CALC - a system-generated property that indicates calculated members.

TRUE OR FALSE

TRUE

346.      Hierarchies are stored as SAP NetWeaver BW

Hierarchies.

TRUE OR FALSE

TRUE

347.      Hierarchies are stored as a separate dimension in MS version.

TRUE OR FALSE

TRUE

348.      SCALING is a property of account used to display values in thousands for example in formula based reports.

TRUE OR FALSE

TRUE

349.What are the 4 account types ?

AST, INC, EXP & LEQ

350.It is possible to create custom account types?

TRUE OR FALSE FALSE.

351.Check the signs for the account types stored in DB and reporting ?

352.Processing a dimension does the following

   Validate Dimension member formulas.

   Validate Hierarchy .

   Update member data into BW.

   BW Attribute change run.

353.Which 2 functions can be used using script logic and business rules. 2 answers are correct.

     Carry Forward

     Validation

     Automatic ajustments

     Currency Translation

Answer : A & D

354. In microsoft the work status cannot be advanced if the ’validation’ account as defined in the application work status has a non zero value.

TRUE OR FALSE

TRUE

355.What is missing  in this code ?

*RUN_PROGRAM CURR_CONVERSION

CATEGORY = %C_CATEGORY_SET%

TID_RA = %TIME_SET%

RATEENTITY = GLOBAL

ENTITY = %ENTITY_SET%

*ENDRUN_PROGRAM

     CURRENCY = %RPTCURRENCY_SET%

     RATEENTITY = %ENTITY_SET%

     ACCOUNT = %ACC_SET%

     Rate type is missing

     TCURR table is missing

Answer: A

356.When you load the data to the BPC info provider you want to delete the existing data and reload the new data what options you use

     Merge and replace the date

     Append the date

     Delete and do a full load

     Replace and clear

     Merge the data

Answer: Replace and Clear

357.What is distributor and collector ?

358.               Only reports can be distributed and collected  and not the Input Schedules ?

TRUE OR FALSE FALSE.

359.               What are the Out of the Box solution for loading the master data load?

Load Master Data from SAP ERP directly into BPC, version for SAP NetWeaver .

Load Master Data from SAP NetWeaver BI Characteristics

Directly Using Data Manager

Flat file by DM

Flat File in BW

Answer; A & B

359.What are the Out of the Box solution for loading the transaction data load ?

     Load transaction data from SAP NetWeaver BI using an Open Hub destination that provides flat files to data manager (Delta Load)

     Load transaction data from SAP NetWeaver BI InfoCubes directly using data manager custom process type (Delta Load)

     Load transaction data via flat file via SAP NetWeaver BI dataflow .

     Load transaction data via UD Connect (SAP NetWeaver BI dataflow )

     Load Transaction Data via Flat File using BPC Data Manager

Answer: A & B

360.               When performing a “Copy AppSet” action, all Validations configuration is copied as well. Likewise, for “Delete AppSet” all Validations configuration is also deleted.

TRUE OR FALSE

TRUE

361.               The new dimension type ’G’ is new in 7.5 and permits the calculation of multiple group currencies by adding multiple currencies into currency type dimension in the group dimension .

TRUE OR FALSE

TRUE

362.               Stored procedures are used on the Microsoft product but not in NW. NW uses process chains and programs.

TRUE OR FALSE

TRUE

363.               By adding a value of ’Y’ to the IS_CONSOL property, the corresponding datasource will be included in the consolidation processing, otherwise they are ignored.

TRUE OR FALSE

TRUE

364.               By adding a value of ’Y’ to the IS_CONVERTED property, the corresponding datasource will be included in the conversion from local to the desired currency, otherwise they are ignored.

TRUE OR FALSE

TRUE

365.               What are the required dimensions to create the BPF instances ?

     Time

     Time and category

     Category

     Entity,category and Time

Answer: Time

366.There is no opening criteria for the first step in the BFP process .

TRUE OR FALSE

TRUE

367.When an BPF action is completed or status changed who gets notified ?

     Owner

     Reviewer

     Manager

     Admin

Answer: Owner

368.               Time is the only required dimension. It is best practice to select at least two dimensions to define an instance. The instance will be used to determine the status of the steps.Usually Time and Category .

369.               The first step of the BPF always opens regardless of the opening criteria.

TRUE OR FALSE

TRUE

370.               Allow Reopen will allow that step to be reopened after completion. If this is set to ‘No’ that step can’t be reopened during execution.

371 Opening criteria All Step Region will enable opening of the next step only after all step regions are complete whereas in case of Matched Step Region when you complete a stepregion, the next step opens for the same step region.

TRUE OR FALSE

TRUE

372.Drill through calls the following

     Any URL

     Any BEX Query

     Any ECC tcode

TRUE OR FALSE

TRUE

373.  Data audit is captured at the Application level.

TRUE OR FALSE

TRUE

374.  Activity audit is captured at the AppSet level.

TRUE OR FALSE

TRUE

375.  When a new application is created, you must define member access to the secured dimensions that reside in the application. This is required in order to use BPC Web, BPC for Excel, BPC for Word and BPC for PowerPoint with any newly created application that contains secured dimensions.

376.  Some components in SAP Business Planning and Consolidation do not post delta values (e.g. Journals), in which case, the package size is always set to 99,999,999 (meaning packaging will never be used).

377.  You specify the hierarchy for which you want to track the work status of deliverables in the APPROVALORG field on the Setting Application Parameters .

378.  Email Notification is only available in SAP BusinessObjects Planning and Consolidation 7.5, version for SAP NetWeaver.

TRUE OR FALSE TRUE

 379.What controls access to applications?

Member Access Profile, Tasks

380.Limitation of dimension property?

 Size cannot be decreased

381. Required DIM for inter-company setup? 

382.What is different in options when you create a legal application? 

383.What can you do while creating a BPF?

 Matched opening criteria, owner 

384.There is a problem in currency translation? Where would you look?

Property MD in Rate 

385.A step is re-opened? What is the next step status? 

386.What is BW object equivalent to a BPC cube? 

387.Where are the archived reports stored in BW? 

388.What can you do in web admin interface? 

389.Which of these would require additional programming while loading data?

Open hub data load

390. Where do you set up the data audit for transactional data?

App level or Appset level and where( web-admin/BPC client) 

391.What DIM is same for all applications in consolidation setup?

Entity/Category 

392.Which of these transformation file options is unique for NW setup?

SELECT

393.How are hierarchies stored in MS?

As a Dimension

394. What is  AS-IS keyword for conversion 

395.What is not possible through work-status?

 Locking a BPF step

396.An application is not shown while logging into excel? What is wrong?

Member Access not given 

397.Program to check AppSet consistency

UJA_APP_Data_Checker

398.What are the reporting applications ?

399.What are the non-reporting applications ?

400.Can you assign work-status codes which application : reporting or nonreporting.