201. Ownership data can be entered via the Dynamic
Hierarchy Editor or via input templates.
202. There are five possible adjustment types: But typically this is blank except for Equity and Proportionate.
• Generic
• Equity
• Proportional
• New (acquisitions)
• Leaving (divestitures)
203. In the NetWeaver release, the 'Groups' dimension is typically used whereas the Microsoft release referred to it as the 'Consolview' dimension.
204. The business rules are broken down into Appset and Application sections for Automatic Adjustments – TRUE.
205. In the Appset, the Rules, Methods, and Formulas are defined. In the Application, the destination datasource is assigned t the method in the 'automatic adjustments'. In the automatic adjustment details, the source accounts, reversal signs, target accounts, and target flows, are specified .
206. A unique requirement when dealing with inter unit elimination entries is that they should only be reflected in any given group if both the entity and the partner entity which it was doing business with are part of the group.
207. The adjustment types include the same 5 rule types:
Generic, Equity, Proportional, New, and Leaving.
208. The consolidation method types include: New, Holding, Global, Proportional, Equity, Leaving @ the beginning of the year, Leaving @ the end of the year .
209. Any number of commit instructions can be entered in a logic file. However, the number of commit instructions should be kept to the minimum, because they have a negative impact on the overall performance of the logic execution due to increased communication between database and Script logic engineThe ideal case is to have one commit at the end .
210.BPC supports compounded info objects . TRUE OR FALSE FALSE.
211.BPC doesn’t support compounded info objects.You have to write proper transformation .
TRUE OR FALSE FALSE.
212.Data packages available are :
Standard Data Loading Packages
Financial Packages
Administrative Packages
Misc Packages
213. Import Hierarchy package…Only supports Overwrite mode, not update mode .The node name in the hierarchies, after transformation, should be a existing members in BPC target dimension.Supports reading hierarchies by time and version dependency, but not writing hierarchies to BPC by time and version dependency.
214.Master data the BADI is based on the table level .
TRUE OR FALSE TRUE.
215.Transaction data the BADI is based on the package level .
TRUE OR FALSE TRUE.
216. Package Link is application based and can not be used across applications.
The packages in one package link are executed in sequence. If one package fails, then all subsequent packages will not run.
217. What are the options available for transaction data load ?
Merge and Replace options are both available .
TRUE OR FALSE
TRUE
218. One driver dim per application is allowed while setting up validations using UJ_VALIDATIONS.
TRUE OR FALSE
TRUE
219. The driver dim can only be the account dim while setting up validations.
TRUE OR FALSE
FALSE
220. If two applications are using the account dim , the validation will be set across applications.
TRUE OR FALSE
TRUE
221. All config in UJ_VALIDATION is _____Specific
Application
App Set
Dimension
DSO
Answer: App Set
222. While setting up validations in UJ_VALIDATIONS.
Value ranges
Use non existing members
Only = sign
You can include multiple values.
Answer: A,B,D
223. It is possible to turn validations on/off by Journals, Manual Planning and Data Manager. TRUE OR FALSE
TRUE
224. Following is true with regards to validations
All validations config can be transported
Validations integrate with Activity Audit Authorisation is controlled by access to task profiles last changed date and time is stored in tables auth is ctrled by access to transaction code S-TRANS Answer: A,B,D.
225. It is possible to log the process of copying and deleting an Appset.
TRUE OR FALSE FALSE.
226. All changes regarding activation and de-activation of
audits is logged into the system
TRUE OR FALSE
TRUE
227. An Application set is equivalent to a MS Analysis Services Database.
TRUE OR FALSE
TRUE
228. An Application is equivalent to a table in a relational database
TRUE OR FALSE
TRUE
229. In the MS Version the ApShell comes with 5 of 6 app types.
TRUE OR FALSE
TRUE
Note:Does not include Generic,non-reporting type. Includes apps like Finance ,Legal,Lrate,Rate and Ownership .
230. In the MS Version, you can create custom menus , define security and add them to the custom menu list in BPC for Excel .
TRUE OR FALSE
TRUE
231. In case the SQL dim data and Excel member do not correspond the _________ is needed to make sure the diff storage types contain the same members.
Process Dim
Delete Dim
Export Dim
Modify Dim Answer: Export Dim
232. Processing a dim in the MS version will execute the foll steps.
Create info objects
Save to the server
Validate the Formulas
Validate the hierarchies
Answer: C & D
233. You can schedule processing of dimensions in the MS Version .
TRUE OR FALSE
TRUE
234. Duplicate dim types are allowed in one application.
TRUE OR FALSE FALSE.
Note:Duplicates are allowed if it is user defined dimesnions.
235. In the MS Version you can set the system to remind you to optimize the app when the database records reach a certain limit.
TRUE OR FALSE
TRUE
236. When you load data via data manager in the MS Version it resides in the "Real Time" data storage.
TRUE OR FALSE FALSE.
Note: When you load data via DM it resides in the FAC2 tables which is the short term data storage.
237. The Compress database option in the MS Version sums multiple entries for the same CV into one entry so that data strorage space is minimized.
TRUE OR FALSE
TRUE
238. Index Defragmentation has no effect on FACT Tables.
TRUE OR FALSE FALSE.
Note:ID can update all indices and statisticsto receive a faster access to the data. ID has an effect on FACT tables .
239. The BPC DM is an instance of the MS Analysis
Integration Services.
TRUE OR FALSE
TRUE
240. Data Manager can handle meta data.
TRUE OR FALSE FALSE.
Note: Only Master data and Transaction data .
241. Clear package creates an additional record with a reverse sign and is eliminated upon compression to achieve the deleted effect.
TRUE OR FALSE
TRUE
242. Worksheet Logic does not require a call to the server.
TRUE OR FALSE
TRUE
243.Worksheet Logic doesn’t update the database.
TRUE OR FALSE
TRUE
244. Dimension logic can only be used with the Account type dimension .
TRUE OR FALSE FALSE.
Note:It can be used with any dim having the formula property
.
255. Upon posting a Journal the system runs the logic that Is specific to journal processes. You can create a Journal.lgf to overwrite this.
TRUE OR FALSE
TRUE
256. In case of Work Status, if a child is added to the hierarchy, and if the parent is locked, the child will also be in locked status.
TRUE OR FALSE
TRUE
257. Re-posting a journal is like posting the values again with a reverse sign.
TRUE OR FALSE FALSE.
Note: Unposting is posting the JV again but with a reverse sign. Reposting is posting the values twice to the database .
258. There are no dynamic template wizard available for the EVDRE function .
TRUE OR FALSE
TRUE
259. EVDRE produces smaller workbooks the EVSND and EVGET as there is no need to embed functions to send or receive data.
TRUE OR FALSE
TRUE
260.. You cannot build a static report using EVDRE.
TRUE OR FALSE FALSE.
261. The ________ option controls the sending of data by EVDRE .
Workbook
Esubmit
Eanalyze
Etools Answer: Workbook.
262.Where you set the layout is input schedule or report.
Workbook options – Input schedule or Report.
263. Refresh option recreates the sturcture of the report and then refreshes the cells.
TRUE OR FALSE FALSE.
Note: Expand All does this.
264.What is the difference between EXPANDALL and REFRESH ?
265.EXPANDALL is time consuming than REFRESH.
TRUE OR FALSE
TRUE
266. The member for each dim is tied to the CV from the Page Key Range using the EVCVW function.
TRUE OR FALSE
TRUE
267. The _________ allows you to select the members from a member look-up dialog box by double clicking on the cell that
contains the formula
EVCOM
EVMBR
EVCVW
EVITM
Answwr: EVMBR
268. You can use the Cell key range only on static reports .
TRUE OR FALSE
TRUE
Note: Use the cell key range to overwrite the CV for any cell
that Is a part of the data range
269. You can base the suppression option on a diff region of data than the one being retrieved.
TRUE OR FALSE TRUE.
270. In the advance formatting, all the 6 cols can be arranged in any order.
TRUE OR FALSE
FALSE
Note: They must be found in the correct order -
Criteria,Evaluate in , format, Use, Parameters, Apply to.
271. Time is a flat dimension .
TRUE OR FALSE
FALSE
Note: Times ia hierachial dimension .
272. In BPC you can assign task profiles directly to users.
TRUE OR FALSE TRUE.
273.In BPC you can assign task profiles to Team and assign users to the team.
TRUE OR FALSE TRUE.
274. Drag and drop reporting provides an alternative method for creating reports and does not use the EVDRE Functions .
TRUE OR FALSE
FALSE
275. In EVDRE , Report is pulled by Page Key Range and not by Current View.
TRUE OR FALSE
TRUE
276. BW has detailed level data and BPC is executive data.
TRUE OR FALSE
TRUE
277. The menu command
‘MNU_eSUBMIT_REFSCHEDULE_BOOK_NOACTION is useful for
Refresh the schedule without sending data
Sending data and refresh the worksheet
Sending data without clearing or refreshing the worksheet
Answer : Sending data without clearing or refreshing the worksheet
278. The dimension type that is required for effecting
currency translations is
Currency Type
Flow Type
Entity Type
Rate Type
Answer: Currency Type
279. Delivered properties like Scaling, formula etc can be
shared across Appsets
TRUE OR FALSE
TRUE
Note: The dimensions are app set specific not application specific.
280. A step is re-opened? What is the next step status?
Open
Re-open
Pending
Delayed
Approved
Answer: Delayed .
281. What is BW object equivalent to a BPC cube?
Info cube
Info object
DSO
Info area
Table Answer: Info Cube.
281. Where are the archived reports stored in BW?
Cube
SAO
Write DSO
Real Time cube
Tables
Answer: Tables
282. Where do you set up the data audit for transactional data?
BPC Admin
BPC excel interface
Web Admin parameters at app set level
Web Admin parameters at application level .
Answer: Web Admin Parameters at application level.
283. What DIM is same for all applications in consolidation setup?
Category, time
Category,entity,time
Category,group,time
Category,group,Time,Entity
Answer: category & Time
284.IC Matching is required for consolidation setup.
TRUE OR FALSE
FALSE
285.What are the 3 apps required for Legal consolidation
Ownership
Rate
Legal
286.Ownership and Rate for non-reporting type apps.
TRUE OR FALSE
TRUE
287.Rate is like equivalent to TCURR in ECC system.
TRUE OR FALSE
TRUE
288. Which of these transformation file options is unique for NW setup?
SELECTION
MAXREJECTCOUNT
VALIDATION
SELECT
Answer: SELECTION
289. What is not possible through work-status?
To lock a BPF – Business Process Workflow
290.What is the name of the program to check the appset consistency ?
UJA_APP_DATA_CHECKER
291. Transaction data is described by
Infocube
Dimension
Appset
Dimension Members
Calculated KF’s
Answer: Dimension Members
292. The required dim types for reporting,generic is ACET .
TRUE OR FALSE
TRUE
293. During optimization the records are moved from the Ffact table to the E-fact table.
TRUE OR FALSE
TRUE
294. SAP BPC does not have the facility of portioning.
TRUE OR FALSE
TRUE
295. You can access the "Modify Work Status option thru the __________ menu.
Edata
Esubmit
Eanalyse
Etools
Answer: esubmit
296. The copy package can copy from several senders to one receiver.
TRUE OR FALSE
FALSE
Note: Always 1:1 relationship.
297. Compounding is supported in the /CPMB namespace.
TRUE OR FALSE
FALSE
298. Non-team leaders can manage a package at the team level
.
TRUE OR FALSE
FALSE
Note: Non team leaders's can only run a package within the company or team folder.
299. A user can be both a system admin and primary admin .
TRUE OR FALSE TRUE.
300. Default logic ref system constants which allow you to use diff dim names .
TRUE OR FALSE
TRUE
291. Default logic allows you to set fixed filters such as the fiscal year
TRUE OR FALSE
FALSE
Note: None of the logic sets fixed filters
292. Validation must be run to clear the validation account .
TRUE OR FALSE TRUE.
293. The designated validation account is specified in work status config (MS only) .
TRUE OR FALSE
TRUE
294. Every time the validation is run, the validation account is incriminated by 1 so the user knows how many time validation was run .
TRUE OR FALSE
FALSE
295. The *REC instruction tells the program what to do once the specified criteria has been met .
TRUE OR FALSE
TRUE
296. Each *REC instruction generates one new record to post to the data base
TRUE OR FALSE
TRUE
297. Script logic calculations cannot cross applications within on Appset .
TRUE OR FALSE FALSE.
298. Script Logic is used to calc data but only for base level data in the application.
TRUE OR FALSE
TRUE
299. You use journals to record and make adjustments to the database.
TRUE OR FALSE
TRUE
300. How many journal templates are in a application N no of journal templates.
Only one journal template per application. Based on the no of dimensions
Journal templates are app set specific.
Answer: only one journal template per application .
No comments:
Post a Comment