« previous next »

Author Question: What is OLAP? Explain its features. What will be an ideal ... (Read 62 times)

yoooooman

  • Hero Member
  • *****
  • Posts: 557
on: Jul 7, 2018
What is OLAP? Explain its features.
 
  What will be an ideal response?

Question 2

Inserting new client information without an actual job assignment is possible in the
  denormalized design.
 
  Indicate whether the statement is true or false
Using MIS ¦ Kroenke, Boyle ¦ 10th Edition
Buy Test-Bank


lorealeza77

  • Sr. Member
  • ****
  • Posts: 356
Reply #1 on: Jul 7, 2018
Answer to Question 1

Online analytical processing (OLAP) is an important reporting application. It is more generic than RFM. OLAP provides the ability to sum, count, average, and perform other simple arithmetic operations on groups of data. The remarkable characteristic of OLAP reports is that they are dynamic. The viewer of the report can change the report's format, hence the term online. An OLAP report has measures and dimensions. A measure is the data item of interest. It is the item that is to be summed or averaged or otherwise processed in the OLAP report. Total sales, average sales, and average cost are examples of measures. A dimension is a characteristic of a measure. Purchase date, customer type, customer location, and sales region are all examples of dimensions. With an OLAP report, it is possible to drill down into the data. This term means to further divide the data into more detail.

Answer to Question 2

FALSE


Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
« previous next »
 

Did you know?

More than one-third of adult Americans are obese. Diseases that kill the largest number of people annually, such as heart disease, cancer, diabetes, stroke, and hypertension, can be attributed to diet.

Did you know?

In ancient Rome, many of the richer people in the population had lead-induced gout. The reason for this is unclear. Lead poisoning has also been linked to madness.

Did you know?

Drugs are in development that may cure asthma and hay fever once and for all. They target leukotrienes, which are known to cause tightening of the air passages in the lungs and increase mucus productions in nasal passages.

Did you know?

Anesthesia awareness is a potentially disturbing adverse effect wherein patients who have been paralyzed with muscle relaxants may awaken. They may be aware of their surroundings but unable to communicate or move. Neurologic monitoring equipment that helps to more closely check the patient's anesthesia stages is now available to avoid the occurrence of anesthesia awareness.

Did you know?

A cataract is a clouding of the eyes' natural lens. As we age, some clouding of the lens may occur. The first sign of a cataract is usually blurry vision. Although glasses and other visual aids may at first help a person with cataracts, surgery may become inevitable. Cataract surgery is very successful in restoring vision, and it is the most frequently performed surgery in the United States.

Surface Features on Europa Surface Features on Europa
Major features of Homo erectus include increased brain size, an angular vault, and cranial superstru Major features of Homo erectus include increased brain size, an angular vault, and cranial superstru
Glacial Depositional Features Glacial Depositional Features
Please explain the different Rf values for xanthophyll’s in paper chromatography compared to ... Please explain the different Rf values for xanthophyll’s in paper chromatography compared to ...
Explain the myogenic autoregulation of the glomerular filtration rate Explain the myogenic autoregulation of the glomerular filtration rate
Major features of human genome Major features of human genome
Video: Hyperglycemia Animation

For a complete list of videos, visit our video library