Go Back

User login

Frontpage Sponsor


How big is your Baan-DB (just Data AND Indexes)
0 - 200 GB
200 - 500 GB
500 - 800 GB
800 - 1200 GB
1200 - 1500 GB
1500 - 2000 GB
> 2000 GB
Total votes: 69

Baanboard at LinkedIn

Reference Content

Items for 'White Paper' (by date)
By Date  
Alphabetically By Date  


You are browsing all items of this content category sorted by date (most recent first). Note that forum posts/threads are not included here.


If you would like to search through the content then please refer to the Site Search page.


Predictive analysis in BI
By Hitesh Shah at 16 Nov 2009 - 18:25

Normally individual and collective wisdom / insights which takes care off latest trends outside system , historical data , seasonal fluctuations , other correlations in predicting events and data. At times such predictions need to be supplemented by statistical analytical tools especially in case of scientific researches and vast tera bytes of data.

One can understand the importance of such predictive analysis from free Oracle Spreadsheet Add-In for Predictive Analytics

By Ravishankar at 9 Apr 2009 - 07:01

Information about LN clients

Excel Assisted reporting strategy for Baan customers
By Hitesh Shah at 1 Mar 2009 - 10:25

Here is a blog on a reporting strategy for baan complemented with Excel load clients. This blog discusses various approaches to reporting in Excel and ingredients of successful Excel assisted baan reporting.



One should read this blog if:

  1. one is very much comfortable with existing authorizations and semantic layer in Baan (Read baan data dictionary ) technically ( table/domain /field codes ) and functionally (descriptions )  and
  2. one wishes to capitalize on  existing learning and knowledge of existing semantic layer in Baan (technically as well as functionally )  and do not wish to invest (or waste??) in learning / migrating /adopting / translating / maintaining new semantic layer for reporting
  3. one is very much adept at using Baan reporting and programming for routine documents  and
  4. one’s users enjoy the freedom, flexibility and functionality of spreadsheets (which may be freeware also) for analytical purposes.
  5. there are sufficient Office licenses already with company on PCs with high CPU and memory ( far exceeding basic Excel requirements and which have become norm rather than exceptions ) in one’s place and there is high need to optimally utilize  these resources  and to reduce the load on servers .


One whose objectives are different OR who don’t have any objectives only OR who is extremely satisfied with their current reporting already.


Customer / Supplier financial analysis in pivot table
By Hitesh Shah at 7 Feb 2009 - 13:17

Now it is becoming increasingly clear that users need liveliness and interactivity on static data from OLTP. This is possible through multi-dimensional modeling available in free-form pivot table or cube structures. As there are not many cube applications and not many established routines to populate cubes incrementally periodically automatically, report-directly-in-excel is becoming vogue.  Though most summarized multi-dimensional modeling cab be done easily with old MS Excel 2003, with excellent enhancement in MS Excel 2007, scalability and liveliness has increased manifold in pivoting (multi-dimensional modeling using pivot table).

All that one need is accurate, reliable and relevant figures side-by-side in CSV format for all dimensions / measures to follow report-directly-in-excel-with-data-dict-advantages strategy. For example, here is a baan report which gives all important dimensions/measures related to customer financial behavior.


Here is the list of dimensions:


Funds Flow statement in Excel Pivot Table directly from Baan
By Hitesh Shah at 30 Jan 2009 - 04:54

Just-do-it-in Excel has been long time successfully deployed strategy deeply embedded in ERPJewels tool of Jewelex. Now  there are many takers and followers for the same. One can vouch this in Just-do-it-in-excel. Reasons for this are not far to seek.

Ledger Balance Trends/Movement in Excel Pivot table directly from Baan
By Hitesh Shah at 14 Jan 2009 - 18:31

According to many experts , MS Excel is omnipotent for analytical purposes . MS Excel Pivot table is versatile for all analytical and reporting purposes in Baan.


Ledger balance trends is a direct pivot table output from Baan . Functional description of the session generating this output and sample excel output are attached. The program use the ERPJEwels tool . Getting such analytical reports  in Excel takes lot of manual effort . Those who require such analytical reports directly from Baan in Excel pivot table, can contact us (mentioning their company name and baan version) for installation, training, consulting and add-ons like such reports  to us .


Those who do not use Excel / ERPJewesl too can use such add-ons  and integrate the same with their office versions. The numbers / ledgers / unit in the sample output are replaced with random numbers for valid reasons . If one sees , liabilities and income are positive whereas it should be negative and final grand total should be 0 .


What is Better FTP (Standard Cost ) Or FIFO
By sharry66 at 27 Sep 2008 - 09:56

I am being confronted by this question by most of the organisations on Which is a better method of valuation, Is it FIFO (Actual Costing) or FTP (Standard Costing).

I tried to analyse and found out some of the basic differences between the two like:


1) Its the concern of most of the organisations that the number of financial transactions that should be generated in the finance should be minimum for better control, then its the FIFO which is better, the system does not generates the purchase price variance transactions in system.

2) Now, as we said above that purchase price variance transactions will not be generated, which is used by most of the organisations to control the performace of purchase department. So its the FTP which one should go ahead with.

3) Another requirement that is readily availability of inventory valuation in finance as per actual costs, if that is the requirement its only the FIFO one should go ahead with, you dont need to do the item valuation outside the system to arrive at the valuation on actual prices.

4) Same is for the valuation of finished goods and sub assemblies, the organisations requires the actual cost that has been incurred on the manufactured items and sub assemblies, which is only possible if we use the FIFO and not FTP where it would be only standard costs that would be applied on sub assemblies and FG.


These were some of the differences that I could find.

Comments and further addition to this is most invited.

Sharad Gupta. 

Redo & Rollback: After activating a standby rhe primary requires recopying to become the standby
By patvdv at 23 Feb 2008 - 23:29

When switching to a standby database, there are two basic scenarios. In one scenario, the switchover is undertaken in an emergency, and due to the unavailability of the primary host or the storage, the final one or two redologs are not available, and therefore cannot be applied to the standby. In such a case, the standby must be activated after incomplete recovery, without applying the last changes from the primary. This scenario is extremely rare.


All times are GMT +2. The time now is 02:22.

©2001-2018 - -