Exam 28: Reporting Systems and OLAP

A reporting system can create dynamic reports only if the most current data is available.

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

OLAP report generation is slower compared to standard DBMS report generation.

Which of the following reporting system functions will come useful if a user wants to select a portion of the database on the basis of a specific criterion?

Explain report authoring,management,and delivery.

Describe online analytical processing.

What is an OLAP cube?

The purpose of ________ is to define who receives what reports,when,and by what means.

Users are not allowed to alter the format of OLAP reports.

Reporting systems use the ________ as a reference to prepare and deliver reports to the proper users on a timely basis.

For query reports,the report-delivery system serves as an intermediary between the user and the report generator.

Which of the following is a medium for reporting query reports?

Ordinal data is used to describe reports,users,groups,roles,events,and other entities involved in the reporting activity.

What are the different types of reports? Explain.

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

What is the difference between push and pull reports?

Reporting systems cannot generate reports that require calculations on the data.

With reference to the online analytical processing,a presentation of a measure with associated dimensions is known as an ________.

An administrator in a company defines who receives what reports,when,and by what means.These functions performed by the administrator are referred to as report delivery.

How does a reporting system obtain the necessary data to generate reports?