What is OLAP? Explain its advantages and disadvantages

OLAP represents online insightful handling and can be characterized as: "Online logical preparation alludes to an assortment of exercises typically performed by End-clients in the online framework."

OLAP incorporates choice help, demonstrating, data recovery, impromptu detailing, and imagining a scenario in which investigation. OLAP focuses on choice help needs.

ERP framework is a choice help instrument that gives constant data to the board and permits the executives to make convenient choices based on that data that is expected to improve execution and to accomplish determined objectives.

Example of OLAP

The case of OLAP can be consolidating deals information by deals channel, item type, and Sales information by determined district. The OLAP question may have to get to this huge measure of information to discover deals inside every locale and for every item type.

Clients can additionally refine the questions to discover all the more profound and explicit information. At long last, the client may choose to perform year to year or month to month correlations for every business channel. An OLAP application should have the option to help this examination online with a quick reaction.


The advantages of OLAP are as follows −

  • Business-centred multidimensional information.
  • Business-centred figuring’s.
  • Dependable information and figuring’s.
  • Speed-of-thought examination.
  • Adaptable, self-administration detailing.


The disadvantages of OLAP are as follows −

  • Pre-demonstrating is an absolute necessity. As to business information, the traditional OLAP tools don't take into consideration quick investigation without pre-demonstrating.

  • Extraordinary reliance on IT.

  • Helpless calculation capacity.

  • Shy Interactive examination capacity.

  • Slow in responding.

  • Theoretical model.

  • Extraordinary, expected danger.

Updated on: 08-Jul-2021

3K+ Views

Kickstart Your Career

Get certified by completing the course

Get Started