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