What is OLAP? Explain its features.
What will be an ideal response?
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.
You might also like to view...
Dynamic pricing is least prevalent online
Indicate whether the statement is true or false
The use of electronic communications technology tends to:
a. increase the importance of status differences among communicators. b. reduce the need to establish communication norms. c. reduce conformity pressure in group decisions. d. decrease the sense of participation in an organization.
On December 31 of the current year, Plunkett Company reported an ending inventory balance of $215,000. The following additional information is also available:Plunkett sold and shipped goods costing $38,000 to Savannah Enterprises on December 28 with shipping terms of FOB shipping point. The goods were not included in the ending inventory amount of $215,000.
Plunkett purchased goods costing $44,000 on December 29. The goods were shipped FOB destination and were received by Plunkett on January 2 of the following year. The shipment was a rush order that was supposed to arrive by December 31. These goods were included in the ending inventory balance of $215,000. Plunkett's ending inventory balance of $215,000 included $15,000 of goods being held on consignment from Carole Company. (Plunkett Company is the consignee.) Plunkett's ending inventory balance of $215,000 did not include goods costing $95,000 that were shipped to Plunkett on December 27 with shipping terms of FOB destination and were still in transit at year-end. Based on the above information, the amount that Plunkett should report in ending inventory on December 31 is: A. $200,000 B. $156,000 C. $171,000 D. $194,000 E. $209,000
Secure Investments, Inc, a U.S. firm, expands into international markets through a joint venture. In this situation, Secure owns
a. all of the operation, and its profits and liabilities. b. all of the operation, and none of its profits and liabilities. c. none of the operation, and none of its profits and liabilities. d. part of the operation, and shares its profits and liabilities.