« previous next »

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

When taking monoamine oxidase inhibitors, people should avoid a variety of foods, which include alcoholic beverages, bean curd, broad (fava) bean pods, cheese, fish, ginseng, protein extracts, meat, sauerkraut, shrimp paste, soups, and yeast.

Did you know?

According to the Migraine Research Foundation, migraines are the third most prevalent illness in the world. Women are most affected (18%), followed by children of both sexes (10%), and men (6%).

Did you know?

Amphetamine poisoning can cause intravascular coagulation, circulatory collapse, rhabdomyolysis, ischemic colitis, acute psychosis, hyperthermia, respiratory distress syndrome, and pericarditis.

Did you know?

More than 34,000 trademarked medication names and more than 10,000 generic medication names are in use in the United States.

Did you know?

The first documented use of surgical anesthesia in the United States was in Connecticut in 1844.

General features of a growth factor or hormone signalling pathway that promotes cell division General features of a growth factor or hormone signalling pathway that promotes cell division
Surface Features on Titan Surface Features on Titan
Microscopic Features of Alzheimer’s Disease Microscopic Features of Alzheimer’s Disease
An example of the key features of pesticide labels. The EPA requires the inclusion of specific ... An example of the key features of pesticide labels. The EPA requires the inclusion of specific ...
Depositional Features Depositional Features
Please fully explain the answer with steps Please fully explain the answer with steps
Video: Evolutionary tree of life Animation

For a complete list of videos, visit our video library