Home

Key Functionalities of ERPJewels

What is new in ERPJEWELS

Latest Trends

ETL/Trends in Data mining/ Trends in Data mining/ Data tranformation and multi-dimensional repoting capabilites

Download

Docs, Executable, AVI and others in Download Section

Hot Links

Find what is Hot in ERPJewels

Related Links

Jewels of ERPJewels

Jewels of BAAN

Jewels of Excel

Jewels of Data Mining

OLAP Interface

ERPJewels is an excellent Data Transformation Service which is native to Baan, written in Baan 4GL and fully integrated with Baan with job scheduling capabilities. It is possible that a user can use the DTS services of ERPJewels for building data marts and may use OLAP server for creating and querying cubes. ERPJewels condense the data to the requisite level and provides just the required redundancy for very high speed cube querying.

There are following advantages of using ERPJewels DTS on Baan.

1. ERPJewels is written in Baan 4GL which is native to Baan and can understand Baan dictionaries better than anybody else (like date, domains, enums, labels , field description ,table indices, company numbers, field alignment, case conversion etc). ERPJewels query generator takes care of this in a better way.

2. ERPJewels can extract data from Baan report. And Baan reports can calculate any figures and numbers (especially after field). Baan reports are scalable transformation engine capable of versatile data transformation. Please see Baan report as data source for more information. In order to get best Baan reports, it’s necessary to understand the Baan reporting structure thoroughly.


3. There are about 2000+ standard reports in Baan. And the customer may already have created great number of customized reports for their internal MIS. If the customer is to have the same MIS outside Baan for OLAP analysis, then tremendous development and implementation-like effort is required. Using ERPJewels existing investment in Baan MIS is protected and it reduces the TCO of  data warehousing & business intelligence.


4. Baan report can be run under Baan Job. And ERPJewels is well integrated in with Baan Job management for analyses. Thus client can use Baan Job management for MIS purposes in addition to day end job activities. This facilitates sophisticated PUSH intelligence as against traditional PULL intelligence. 

5.Baan users are well familiar with Baan report, it's functioning & it's development .And these users don't have to be re-trained for other DTS software.


6. ERPJewels implementation is very easy and requires minimum implementation time.


7. ERPJewels enable MOLAP cubes. ROLAP / HOLAP cubes will not be possible. However this is what users require normally due to very poor response times associated with ROLAP/HOLAP.

To cater to the needs of such users who needs ERPJewels for DTS, OLAP Interface is an analysis type, helps user accomplish the desired objective in following manner.

    1. After analysis Program – If the Baan production server has OLAP capabilities also (as is the case in SQL server and Oracle 9i), a Baan 3GL / 4GL program has to be written. This program should update the OLAP database from ERPJewels tables. This program is started immediately after the analysis is over when in non-job mode or scheduled immediately after program generating analyses results.

    2. Direct Access to ERPJewels Tables - When analyses results are saved, OLAP users can access the ERPJewels summary analyses results directly from OLAP client. This can be possible from when Baan server database also has OLAP capabilities.

    3. OLAP client program - ERPJewels can start a OLAP client program which takes text files as input along with selection values and update OLAP database with the requisite DDL & DML statements.



FastTrack to ERPJEWELS :

Latest Trend | Hot Links | Jewels of ERPJewels | Jewels of Baan | Jewels of Excel