Web-based OLAP Overview

Web-based OLAP Overview

Web-based OLAP Definition OLAP is a Business Intelligence technology designed to carry out analysis and draw up reports based on data available in a multidimensional view. OLAP is suitable for businesses with multiple departments and points on sales. Every location...
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

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 and in this article, we’re going to speak about MOLAP particularly. MOLAP is short for multidimensional online analytical processing and is taken for the traditional...
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...
Page 1 of 812345...last »
Write US