Multidimensional Expressions

Multidimensional Expressions

MDX Definition Multidimensional Expressions or MDX is a calculation/query language to express queries for online analytical processing - OLAP, in a database management system. MDX is an SQL extension to query data stored in a multidimensional structure. As for...
MOLAP – Multidimensional OLAP

MOLAP – Multidimensional OLAP

Overview There are basically three types of online analytical processing: MOLAP, ROLAP, and HOLAP. In this article we’re going to speak about MOLAP particularly. MOLAP is short for multidimensional online analytical processing: it is taken for the traditional version...
Ranet OLAP Dashboard

Ranet OLAP Dashboard

Introduction Ranet OLAP as the name implies is an online analytical processing which refers to mining and analyzing fresh data belonging to current business processes. Owing to OLAP information originating from several sources can be stored in various formats in one...
OLAP performance

OLAP performance

1. Detecting the flaws All large organizations managing big amounts of storage data have to regularly optimize databases performance. In this article we’re going to review several methods to enhance OLAP performance particularly. Those methods are aimed to improve the...
Business Intelligence

Business Intelligence

What is BI According to Gartner glossary business intelligence (BI) is an umbrella phrase that involves applications, infrastructure, tools, and best practices which ensure access to the analysis of the requisite information to boost and enhance performance and...
ETL tools and OLAP correlation

ETL tools and OLAP correlation

What is the use of OLAP Being a part of BI, OLAP technology, developed to enable fast extraction of requisite data from the data warehouse, is populated from OLTP databases (CRM, ERP, AR, AP etc.) through ETL tools. Online Analytical Processing systems, offered today...
OLAP Cubes

OLAP Cubes

In this article, we are going to review a well-known OLAP technology and an application developed for better exploitation of an OLAP cube - CubesViewer, which function is already installed in Ranet OLAP. If you had ever wondered what is a cube in BI in general and...
OLAP Operations in Data Mining

OLAP Operations in Data Mining

OLAP is a widely spread technology belonging to Business Intelligence processes developed to coordinate and analyze vast amounts of data. OLAP databases are stored in the form of multidimensional cubes where each cube comprises the data supposed relevant by a cube...
OLTP and OLAP difference

OLTP and OLAP difference

Nowadays, practically all organizations can’t but accept big data streaming and processing as the most valuable resource to profit in their business. Due to data mining and handling companies are able to apply analytics and collect vital insights for forecasts and...
Write US