var quiz = { questions : [ { text : 'Which of the following describes a Result Set query?', img : 'http://media.techtarget.com/WhatIs/images/spacer.gif', responses : [ 'a. A prequery', 'b. A query using flat tables (ODS object or InfoObject)', 'c. A nested query where the results of a first query are used as entry values for a second query', 'd. There is no such thing in SAP BW', 'e. None of the above' ], answer : 2, score : 1, expandedAnswer : '

A Result Set query is a nested query where the results of a first query (prequery) are used as entry values for a second query. For example, a Result Set query can be used to return the customer sales for the top 10 products.', moreInfo : ' - Smooth BEx queries
- Book Chapter: \'Information Access, Analysis, and Presentation\'' }, { text : 'Which of the following is correct about Profile Generator?', img : 'http://media.techtarget.com/WhatIs/images/spacer.gif', responses : [ 'a. It is a tool to automatically generate Authorization Profile', 'b. It is a tool existing in OLTP systems only', 'c. Complete the Administrator work with extra tasks to set up authorization', 'd. A tool that can be used by end users to modify their authorizations', 'e. None of the above' ], answer : 0, score : 1, expandedAnswer : '

Profile Generator is a tool used to automatically create user profiles.', moreInfo : ' - SAP HR Organisational Management vs. the profile generator
- Book Chapter: \'Business Scenario and SAP BW\'' }, { text : 'What do the SAP BW content extractors provide?', img : 'http://media.techtarget.com/WhatIs/images/spacer.gif', responses : [ 'a. Generic extractors', 'b. Custom extractors', 'c. There is no such thing in SAP BW content', 'd. Data sources that can be activated for all applications', 'e. None of the above' ], answer : 3, score : 1, expandedAnswer : '

SAP BW content extractors extract data from SAP R/3 application-specific data (e.g., FI, CO, HR, LO cockpit).', moreInfo : ' - BI Content and Extractors' }, { text : 'Using PSA as a loading process, which of the following methodologies can be used?', img : 'http://media.techtarget.com/WhatIs/images/spacer.gif', responses : [ 'a. To PSA, then to the data target', 'b. To PSA only', 'c. To data target only', 'd. To PSA and data target in parallel', 'e. None of the above' ], answer : 4, score : 1, expandedAnswer : '

The PSA is the inbound layer of the SAP BW system and contains data in original context and format. From the PSA, data can be uploaded to the ODS or InfoCube(s) via transfer rules.', moreInfo : ' - Are the V1 and V2 updates used in LO? How do I view a PSA data table?
- Our database is full -- how should we proceed?' }, { text : 'Which of the following is a supply of workbooks in SAP BW arranged according to ttopic areas?', img : 'http://media.techtarget.com/WhatIs/images/spacer.gif', responses : [ 'a. An InfoSource', 'b. A channel', 'c. An InfoArea', 'd. An InfoCatalog', 'e. An InfoObject' ], answer : 1, score : 1, expandedAnswer : '

Channels: A supply of workbooks in SAP BW arranged according to topic areas. Using the channels of the Business Explorer end users access workbooks that are assigned to him/her.', moreInfo : ' - Top 10 business warehouse best practices
- Book Chapter: \'SAP Gives Business Intelligence\'' }, { text : 'What is the maximum number of key figures in an InfoCube?', img : 'http://media.techtarget.com/WhatIs/images/spacer.gif', responses : [ 'a. 13', 'b. 85', 'c. 322', 'd. 233' ], answer : 3, score : 1, expandedAnswer : '

InfoCube: Max key figures -- 233
\nDimension table: Max characteristics -- 248
\nInfoCube: Max fact table -- 1', moreInfo : ' - Definition: cumulative vs. non-cumulative key figures
- Extracting COPA InfoCube data in flat file format to a non-SAP interface' }, { text : 'Which of the following tools helps in the Web reporting area?', img : 'http://media.techtarget.com/WhatIs/images/spacer.gif', responses : [ 'a. The Web agent', 'b. The front-page tool', 'c.The Web wizard', 'd. The query view' ], answer : 2, score : 1, expandedAnswer : '

The Web Publisher wizard is a tool within the Web Publisher to provide user assistance in Web publishing.', moreInfo : ' - SAP BW Web Publisher' }, { text : 'When are aggregates useful?', img : 'http://media.techtarget.com/WhatIs/images/spacer.gif', responses : [ 'a. Always', 'b. They are useful only for key figures with aggregation SUM, MIN, or MAX', 'c. For reorganizations and realighnments', 'd. To increase the speed of loading during data update', 'e. None of the above' ], answer : 1, score : 1, expandedAnswer : '

Aggregates: Precalculated and prestored summaries stored in the data warehouse to improve data warehouse performance.', moreInfo : ' - Read our definition of podslurping.
- Checking aggregates in SAP BW and starting a change run
- It it necessary to do a rollup to maintain consistency between a cube and its aggregates?' }, { text : 'Which of the following is correct about SAP BW Statistics?', img : 'http://media.techtarget.com/WhatIs/images/spacer.gif', responses : [ 'a. Data volume of the SAP BW Statistics cannot be anticipated', 'b. SAP BW Statistics are delivered as a part of the technical content', 'c. All SAP BW Statistics query objects start with OSAP', 'd. All SAP BW Statistics InfoObject catalogues start with OSAP', 'e. SAP BW Statistics is automatically activated' ], answer : 1, score : 1, expandedAnswer : '

SAP BW Statistics is a tool delivered as part of the technical content to support the administration and performance review of an SAP BW live system. It is useful to note that reporting from SAP BW Statistics is done through a MultiCube approach.', moreInfo : ' - Enabling the BW statistics cube
- Slow BW reporting with 150m rows infocube' }, { text : 'In FI/SL we can create a ledger based on what type of tables?', img : 'http://media.techtarget.com/WhatIs/images/spacer.gif', responses : [ 'a. Aggregate tables', 'b. InfoCube level tables', 'c. Line-item level tables', 'd.Summarization level tables', 'e. Total tables' ], answer : 4, score : 1, expandedAnswer : '

Data from FI/SL are only extracted from the total tables.', moreInfo : ' - SAP Definition: FI/SL' } ] };