OLAP Security

OLAP Security

When working with Ranet OLAP, access to business data in the pivot table can be organized according to the principle of Microsoft SQL Server Analysis Services where you can customize access rights for all users. Such a security model based on users’ roles for each...
Multidimensional Expressions

Multidimensional Expressions

Multidimensional Expressions In BI world such tools as OLAP and multidimensional data analysis still play the leading roles. The reasons are clear: they are fast, accurate and efficient. But how does it work on practise? The key to this knowledge is MDX query...
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

OLAP Cubes Today we’d like to highlight the most principle part of OLAP technology – OLAP cube. If you had ever wondered what is a cube in BI in general and want to define OLAP cube technology you will likely find the answer here. The Technology of an OLAP...
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...
Write US