Home

Key Functionalities of ERPJewels

What is new in ERPJEWELS

Latest Trends

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

Download

Docs Executable, AVI and others 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

Microsoft Excel Pivot Table Report

Pivot Table report and Pivot Table Charts in Microsoft  Excel 2000 / 2002/2003 /2007 are the excellent contributions of MS Excel in the field of summary reporting.  Pivot Table Report can report relational data in multi-dimensional form very easily. User can use the excellent drag and drop facilities of Pivot Table report to view the analyses results from different angles.

ERPJewels uses Microsoft Pivot Table Report as an output directly coming Baan automatically without having to trigger the same manually by user. This has tremendous advantages to users which are enumerated here.

  1. One challenge of Intelligence applications is to present the analyses results in very user-friendly interactive manner (like drag & drop features) without compromising on quality and yet it’s very simple. Pivot Table Report meets these challenges very easily.
  2. Optionally user can present the data graphically in interactive manner in Pivot Chart Report. This is boon to key users with little knowledge multi-dimensional technology and terminologies.
  3. User can filter the analyses results also using page fields. This is possible only for analysis results filtering (ie Transform level querying). User can not however change the original query in Baan data source (ie Extract level query). This is because the ERPJewels uses MOLAP approach which stores the analyses results only in multi-dimensional format and not the original large bulky data from data source. In fact this is not even required and desired in most cases.
  4. User can get Top 10 / Bottom 10 easily.
  5. User can use calculated fields to get ratios & % among various columns.
  6. ERPJewels also specifies the selection criteria on the original data source. This helps users to understand / know what they are viewing (even at a later point of time).
  7. Format Report is an excellent function of Pivot Table whereby users can present the analysis results in the way he/she desires.
  8. Pivot Table Report can accommodate 8000 (32000in MS Excel 2003 and  1 Million in Excel 2007 ) distinct items and 255 data items (16000 columns in Excel  2007). This is sufficient for most analyses because by very nature summary information compact, concise and precise.
  9. User need not learn multi-dimensional technology to query pivot table report.

There are some limits to capabilities of Pivot Table Report and MS Excel. To know more about limits, please click this.

 

Microsoft has provided excellent samples of Pivot Table report. Please download Pivot Table Samples  & Pivot Table Reports 101 to view these excellent How-To samples.



FastTrack to ERPJEWELS :

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