It is a well established fact that MS Excel is an excellent user-friendly
presentation (as far as quantitative information is concerned) and
analytical tool. With recent enhancements in MS Excel 2007 (http://www.erpjewels.com/excel2007enhancements.htm) and
Duet- JV between Microsoft and SAP, (http://www.sap.com/community/pub/flash/kw11_07_story_2.epx) it has become more evident.

Already Baan customers know about the importance of MS Excel and try many
ways to provide good Baan data access in MS Excel .There are many ways
and work arounds for data access and transformation of Baan data in Excel .
But none are complete for many reasons

1. Complexity of output formatting either through a tool or manually due to
lack of native data dictionary and deeper integration with Baan objects.
2. Longer lead times for getting data in excel
3. Lack of data transformation functionality in current alternatives
4. Lot of complexity and difficulty in changing backend Baan objects repeatedly.

All these leads to longer lead times for MIS generations and probable loss of user
Interest in MIS which in turn leads to delayed and inaccurate decisions leading
to more losses.


Today’s world is dynamic and so are the requirements of IT. Practically no
solution can satisfy the complete requirements IT in all situations . Different
situations and scenarios demand different approaches and different solutions.
Multiplicity of solutions to fit diverse requirements of a company is the order
of the day . This is what all leading corporations do to keep it agile and vibrant
moving forward fast. So deploying an integrated tool like ERPJewels will definitely
add to the vibrancy and agility of Baan customers .

ERPJewels is one such excel reporting solution on Baan which can provide easy
Baan data access and transformation in MS Excel. It provides great synergy
between these 2 great applications by combining their complementing functionalities
and providing deeper integration between these applications. One can view
Specific Native Data dict advantages (http://www.erpjewels.com/nativedatadict.pdf) in Baan terminology for more information.

For more information on this tool, one can visit our website www.erpjewels.com.

We have pleasure in making our wonderful Excel based reporting tool open source . We have
created ERPJewels open source project (https://sourceforge.net/projects/baan2excel/) for the same on 24th Dec 2007 . Even download page our website has more information about the same.

Names of contributors and volunteers have not been added as per request from many of them.

This tool bring life to dead (static raw) data in Baan tables and Baan reports by adding the much-needed interactivity and formatting/multi-dimensional capabilities of MS Excel and adding further data transformation power to it. This tool lets developer specify analyses fields (including user defined ) & calculated items (data polishing ) , map it to pivot table / plain excel , describe the field , add selection criteria (including user defined based on Baan 4GL code ) for any Baan table / Baan report .

As Baan 4GL functions and reporting flow remains same across versions , the tool can be of use in other Baan versions also besides Baan IV .

Connector to Baan report has worked across all SPs. It's tested upto SP21. There had been some changes in repgen6.1 about 2-3 times during it's journey from SP8 to SP21. All the times it has worked by making some fixes to the code within couple of hours so that it works on older SP as well as the new SP .

Enjoy this new year gift from Jewelex.

Hi,

I wholeheartedly congratulate ERP Jewels team for making such a marvelous tool and further making it open source. I would request all baan users to have a look at it and get benefit. This is very much unique tool from all other Over-hyped BI tools (COGNOS, Business Objects etc) as this is natively integrated with baan iv.

I just setup ERP Jewels on my live server and I was up and running on the same day as the tool comes with demo analysis which you can import in your baan company.

I feel, if this tool is used with baan, it has the capability to serve allmost all reporting and analytics requirement of enterprise.

Vishal

Dear Vishal ,

I am overwhelmed by ur response to this tool and thank u for appreciation of our effort and vision.

As identified by u , this tool really holds extremely good value proposition for Baan customers which complements existing Baan reporting and data processing capabilities very well .

Once again thanks for the response .

i have problem download the link inside

http://www.erpjewels.com/download.asp

Certain files were taken offline for certain enhancements .Till the time that's updated , working set of download along with product and installation documentation is available at http://sourceforge.net/project/platformdownload.php?group_id=207529 (server download and additional files ) .

I still not able to know how to get ERPJewel to work with Baan IV?

Send me a PM as to what all u downloaded , what documents u have gone through and at what stage u enocuntered the problem along with ur email.

i mean i don't even know how to start.

Now the revised documentation and demo table are also made available on download page (http://www.erpjewels.com/download.asp) . U can use the same.

In summary the flow should be like

1. Download , read and understand installation procedure.
2. Download the requsite software components and demo tables (server and requisite office version binary ) .
3. Follow the installation procedure as detailed in installation procedure (optional but preferred to do in test system) .
4. Import demo tables
5. Use functional documentation (after downloading and / or available online in baan) for using demo tables and ur own business requirement . Video files available online (http://www.erpjewels.com/Product%20Live%20Demo.HTM) can also be viewed.
6. Start with Easy analysis creator (tudll9176m000) , Report based analysis (tudll9160m000 ), table based analysis (tudll9140m000) .

Do let me know by PM if u have any query .

the video live demo not working.

http://www.erpjewels.com/Product%20Live%20Demo.HTM

the below file not able to download..

ej2000.zip
ej2002.zip
ej2003.zip
ej2007.zip
clientsources.zip

Steven ,thanks for this feedback . As most of the dumps are on sourceforge , we had not done enough check on website download page in our last changes. Now check and give me feedback.

below link still cannot.

Product Live Demo
5. http://www.erpjewels.com/avi/datamarts.zip

erpjewels2000.exe
erpjewels2002.exe
erpjewels2003.exe
erpjewels2007.exe

datamarts.zip transfer was insterrupted and hence incomplete .It's there now complete. All other binaries are already there on www.erpjewels.com and also on sourceforge . U may use any of them .