COMPUTER APPLICATIONS
ENTERPRISE RESOURCE PLANNING ERP SOFTWARE
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Olap servers support common analytical operations such as?
|
|
Operation
|
|
|
Drill-down
|
|
|
Consiliation
|
|
|
Slicing and Mining
|
Explanation:
Detailed explanation-1: -DRILL ACROSS: Accesses more than one fact table that is linked by common dimensions. COmbiens cubes that share one or more dimensions. DRILL THROUGH: Drill down to the bottom level of a data cube down to its back end relational tables.
Detailed explanation-2: -OLAP or Online Analytical Processing is a category of software that allows users to extract and examine business data from different points of view. It makes use of pre-calculated and pre-aggregated data from multiple databases to improve the data analysis process.
There is 1 question to complete.