« previous next »

Author Question: What is OLAP? Explain its features. What will be an ideal ... (Read 22 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?

Acute bronchitis is an inflammation of the breathing tubes (bronchi), which causes increased mucus production and other changes. It is usually caused by bacteria or viruses, can be serious in people who have pulmonary or cardiac diseases, and can lead to pneumonia.

Did you know?

Of the estimated 2 million heroin users in the United States, 600,000–800,000 are considered hardcore addicts. Heroin addiction is considered to be one of the hardest addictions to recover from.

Did you know?

Disorders that may affect pharmacodynamics include genetic mutations, malnutrition, thyrotoxicosis, myasthenia gravis, Parkinson's disease, and certain forms of insulin-resistant diabetes mellitus.

Did you know?

To combat osteoporosis, changes in lifestyle and diet are recommended. At-risk patients should include 1,200 to 1,500 mg of calcium daily either via dietary means or with supplements.

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.

Features of the skull of anatomically modern Homo sapiens. Features of the skull of anatomically modern Homo sapiens.
Features of the skull of archaic Homo sapiens. Features of the skull of archaic Homo sapiens.
Bone Features Bone Features
The major external features of a neuron. The major external features of a neuron.
The major internal features of a neuron. The major internal features of a neuron.
Common sequence features in integrated retroviruses and other eukaryotic transposable elements Common sequence features in integrated retroviruses and other eukaryotic transposable elements
Video: Sigmoidoscopy

For a complete list of videos, visit our video library