Exam 25: Reporting Systems and OLAP

Which of the following types of reports has the ability to sum,count,average,and perform other simple arithmetic operations on groups of data?

The ________ in a reporting system indicates the channel to be used for sending a report to a user and whether the report is to be pushed or pulled.

A report on the current stock prices in a market is an example of a static report.

Reports that are not subject to change and are prepared from underlying data are referred to as ________.

An OLAP cube can also be referred to as an ________.

The sales manager of a retail store wants a list of customers who have made more than three repeat purchases from the store: Which of the following operations of a reporting system would help the store manager obtain such a list?

Describe online analytical processing.

Reports that are prepared in response to data entered by users are termed ________.

Reports that users receive on declaring that they wish to receive notification of events via email or on their cell phones are termed as ________.

Which of the following report media is used for delivering a query report?

Alerts generated on the basis of user notification are not treated as reports.

The process of dividing the data in OLAP reports into more details is termed drill-down.

The ________ function of a reporting system pushes reports or allows them to be pulled according to report management metadata.

What are reporting systems? What are the fundamental operations they perform?

Push reports are generated only on receiving a user request.

Explain the different types of reports.

What is the difference between push and pull reports?

Which of the following statements is true of dimensional databases?

Reporting systems cannot generate reports that require calculations on data.

In OLAP reports,a dimension refers to an item that is to be processed in the report.