- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
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.
Advantages
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.
Disadvantages
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.
3K+ Views
