9. The truth about aggregates

9. The following statements are true for aggregates.

a. An aggregate stores data of an info cube redundantly and persistently in a summarized form in the database.
b. An aggregate can be built on characteristics or navigational attributes from the info cube.
c. Aggregates enable queries to access data quickly for reporting.
d. None of the above.

ANSWER(S): A, B, C

Aggregates summarize and store data from an info cube. Characteristics and navigational attributes of an info cube can be used to create aggregates. Since aggregates contain summarized data, the amount of data in aggregates will be much less that the cube which makes the queries to run faster when they access aggregates.

Return to the answer page
Return to the quiz

Digg This!     StumbleUpon     Del.icio.us

RELATED CONTENT Quizzes Quiz: SAP master data management (MDM) Quiz: SAP BI/BW -- advanced level SearchSAP.com SAP BI/BW quiz answers: advanced level Quiz: Customers and Call Centers Quiz: SAP BI/BW -- intermediate level Answers to a SearchSAP.com quiz: Get to know BP master data for CRM SearchSAP.com SAP BI/BW quiz answers: beginner level Quiz: SAP BI/BW -- beginner level 2. Reference and referred characteristics 1. Data sources SAP business information warehouse Four things SAP must consider before a Teradata acquisition SAP BW or third-party data warehouses a dilemma for SAP customers Should we install SAP BW on the same server running SAP R/3 4.7? SAP: Don't rush from SAP BEx tools to SAP BusinessObjects SAP shores up SAP NetWeaver BW with Teradata Choosing an SAP BI/BW database for InfoCube data Using Infoset to join, move DSO analysis to InfoCube Selecting InfoCubes in SAP BI/BW Business Content SAP BI roadmap one year later: How's Business Objects working out for SAP BI customers? How to limit employee access to reports using roles in SAP NetWeaver SAP business information warehouse Research

RELATED GLOSSARY TERMS Terms from Whatis.com − the technology online dictionary BEx  (SearchSAP.com) Business Information Warehouse  (SearchSAP.com) Enterprise Services Architecture  (SearchSAP.com)

RELATED RESOURCES 2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems Search Bitpipe.com for the latest white papers and business webcasts Whatis.com, the online computer dictionary