« previous next »

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

Tobacco depletes the body of vitamins A, C, and E, which can result in any of the following: dry hair, dry skin, dry eyes, poor growth, night blindness, abscesses, insomnia, fatigue, reproductive system problems, sinusitis, pneumonia, frequent respiratory problems, skin disorders, weight loss, rickets, osteomalacia, nervousness, muscle spasms, leg cramps, extremity numbness, bone malformations, decayed teeth, difficulty in walking, irritability, restlessness, profuse sweating, increased uric acid (gout), joint damage, damaged red blood cells, destruction of nerves, infertility, miscarriage, and many types of cancer.

Did you know?

There can actually be a 25-hour time difference between certain locations in the world. The International Date Line passes between the islands of Samoa and American Samoa. It is not a straight line, but "zig-zags" around various island chains. Therefore, Samoa and nearby islands have one date, while American Samoa and nearby islands are one day behind. Daylight saving time is used in some islands, but not in others—further shifting the hours out of sync with natural time.

Did you know?

Your chance of developing a kidney stone is 1 in 10. In recent years, approximately 3.7 million people in the United States were diagnosed with a kidney disease.

Did you know?

Cancer has been around as long as humankind, but only in the second half of the twentieth century did the number of cancer cases explode.

Did you know?

The average adult has about 21 square feet of skin.

Basic features of the function of many excretory systems. Basic features of the function of many excretory systems.
Surface Features on Titan Surface Features on Titan
Number of lower molar cusps is one of the features used to distinguish sundadonts from sinodonts. Number of lower molar cusps is one of the features used to distinguish sundadonts from sinodonts.
The strange situation. The Strange Situation features a series of episodes in which (a) the mother l The strange situation. The Strange Situation features a series of episodes in which (a) the mother l
Working Memory Binds Visual Features into a Single Chunk Working Memory Binds Visual Features into a Single Chunk
Video: Summary of female reproductive cycle days 1-28

For a complete list of videos, visit our video library