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

yoooooman

  • Hero Member
  • *****
  • Posts: 557
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


lorealeza77

  • Sr. Member
  • ****
  • Posts: 356
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
 

Did you know?

The FDA recognizes 118 routes of administration.

Did you know?

A headache when you wake up in the morning is indicative of sinusitis. Other symptoms of sinusitis can include fever, weakness, tiredness, a cough that may be more severe at night, and a runny nose or nasal congestion.

Did you know?

To maintain good kidney function, you should drink at least 3 quarts of water daily. Water dilutes urine and helps prevent concentrations of salts and minerals that can lead to kidney stone formation. Chronic dehydration is a major contributor to the development of kidney stones.

Did you know?

As many as 28% of hospitalized patients requiring mechanical ventilators to help them breathe (for more than 48 hours) will develop ventilator-associated pneumonia. Current therapy involves intravenous antibiotics, but new antibiotics that can be inhaled (and more directly treat the infection) are being developed.

Did you know?

The B-complex vitamins and vitamin C are not stored in the body and must be replaced each day.

For a complete list of videos, visit our video library