Online analytical processing (OLAP in this case, desktop OLAP) allows the user to quickly analyse different Online analytical processing (OLAP in this case, desktop OLAP) allows the user to analyse different scenarios of the extracted data quickly. This means that if, for example, we are looking at sales, we can look at the Sales, Revenue or quantities based on a salesperson (sales code), then quickly add to that a break down by inventory category. The user can filter out specific sales codes or inventory categories and produce simply charts and reports.
The layout can be saved as a scheme or layout to use later to apply against the raw data, or a cube can be saved, which includes all the data and the layout. The cube can be supplied to another user/manager for further analysis with the actual need for connection to the corporate database.
OLAP is an attempt to reflect a 3D cube in a 2D world; you can rotate just the slices (fields of information) and place them as required to get the breakdown of information required.
CRM's OLAP interface comes with standard SQL statements to extract required data and some basic schemes/layouts to interpret the raw data. The user can create their SQL statements to either extract information from Pastel or CRM's own data tables and create and save scheme layouts for reuse.
The OLAP screen is split into four different sections.
This tab displays the currently saved SQL statements (or views of the data) for CRM and Pastel
This is the main desktop area for creating the scheme/layout required, producing simple cross tab reports
Simple charting of the currently active data represented in the DOLAP area
This is a grid representation of the raw data only