Many organizations are in front of most competitive economic environments, where, in order to survive, they must reduce costs all the time and adopt the most intelligent business strategies. In most decision making activities the manager has to decide which variant is the most advantageous,...

The Oracle OLAP option of Oracle Database 10g Enterprise Edition provides advanced analytic features to help us to summarize, analyze and calculate data faster than standard SQL. In this article I discussed about the CWM2, a set of PL/SQL packages which are using to create the OLAP Catalog...

A key to survival in the business world is being able to analyze, plan and react to changing business conditions as fast as possible. With multidimensional models the managers can explore information at different levels of granularity and the decision makers at all levels can quickly respond to...

Using SQL you can manipulate multidimensional data and extract that data into a relational table. There are many PL/SQL packages that you can use directly in SQL*Plus or indirectly in Analytic Workspace Manager and OLAP Worksheet. In this article I discussed about some methods that you can use...

In a rapidly changing economy, Business Intelligence solutions have to become more agile. This paper attempts to discuss some questions which help in creating an agile BI solution such as: What is Agile? Why agile is so well suited for BI? Which are the key elements that promote an agile BI...

This paper explores one of the newer technologies related to the field of Business Intelligence: in-memory technology. The new class of in-memory BI tools turns a BI solution into an agile BI solution. Also, the paper focuses on the main data models used by in-memory BI technologies and tries to...