Product Key Functionalities in Brief
1.Baan Report As Data Source
Baan reports are a treasure of lot of information which can be very good source further analysis in MS Excel. Any information in detail /after field section of a report can be extracted in runtime from a report and loaded to Excel. It is different from output formatting technique of getting data in Excel. Further on this report fields , lot of data calculations and conversions can take place in terms of summing , date conversion , description lookup , writing user defined field using the output fields as input parameters , hierarchy lookups etc . This gives tremendous flexibility and freedom to the user in creating analysis . Know more about this amazing data source.
2.Wizard for analyses creation on Baan report.
Baan report is a special data source. There are no ready available field descriptions for report variables. Further the user creating the analysis may not know the VRC in which the report exist in run time. Further before creating the analysis, user may want to view report input variables / report layout variables / available layouts etc. This necessitates a user friendly interface which helps user to create analyses out of Baan report easily. Know more about this wizard.
3.System driven Push Intelligence as against user driven Pull intelligence
Analyses based on Baan report have to be
scheduled using Baan job management only. Further Baan reports can be printed in
special user choices and/or using brp functions instead of rprt functions
.So separate user interface and logic is in-built to integrate the tool
seamlessly with Baan Job management comprising all complex conditions. Job
management for Baan table is relatively simpler . And this runs through
Baan job management. This facilitates sophisticate Push Intelligence as
against traditional user driven Pull Intelligence. At the same time it gives
following advantages to users over plain job management.;
i. From date corrections for getting correct analyses results
i. Recognizing non-date based period indicators and using is
for generating analysis (e.g fiscal periods , week number etc).
Know more about Push Intelligence.
4. Backward & forward Integration
The tool allows users to run certain 3GL or 4GL programs in Baan after the analysis is over. These programs can update the user’s transactional data based on the analysis results. This will help in cases where user needs to revise his/her budget / forecast in definite fashion based on analysis results. Thus user is saved of unwarranted data entry. Further user can have a separate non-excel based third party load client also for forward integration. Know more about this .
5. Report Complexities handled
Baan report is a complex data source. Layout print conditions, print expressions, short lived nature of the report data, implicit output fields (sort fields not printed in the layout ) , layout line numbers , aggregate conditions , aggregate expression etc all these goes to make the report data source very complex . However , this has been handled very nicely in ERPJewels . Know more about report complexities handled
6. Hierarchies
Typical analyses involve reporting statistics
in an hierarchical manner. There can be hierarchies in time , in geography
or in any other user defined manner .Pivot table has very good
reporting structure for hierarchical data. These hierarchies facilitates
very good exception reporting . In Baan side ERPJewels bridges the
gap by providing complete infrastructure for its creation , maintenance and
usage in ERPJewels. You can see
how.
User defined function or
UDF are the customized business logic functions which users can use
in the generation of analyses. Ad hac complex analyses generation is beyond
simple data mining rules . It calls for some sort of scripting interface where
the analyses can be created as per the needs of the business .
ERPJewels provide a way for creating and using these UDF in analyses
.These functions let users get any kind of analytical information from
Baan. Here is how can use
ERPJewels UDF.
ERPJewels optimizes the Baan's versatile and
agile data dictionary and all-powerful data extraction and manipulation
techniques to the max .
Here is the information how . If one wish to know ERPJewels add
more power and complement Baan tools for analytical processing ,here
is how.
QSS functions are extra-ordinary functions of
Baan 4GL to manipulate data in memory .We have written dll which can
expedite the data transformation process at the speed of light. The code for
this dll is available publicly on
http://www.baanboard.com/baanboard/showthread.php?t=28569.
Though this dll simplifies the data transformation to
great extent ,there is still some level of complexity. We have removed this
complexity through our code generators.
Certain programs typically process or print sessions sometimes take inexplicably long time . In order to
improve such program a genric performance dll code is written.The performance improvement can be as high as 90% .
Excel Pivot tables are the exclusive
functionality of MS Excel .All we do at ERPJewels is to bring this
wonderful functionality to the user very easily for Baan data . Know more about
the marvels of pivot table.
Latest Trend | Hot Links | Jewels of ERPJewels | Jewels of Baan | Jewels of Excel
7. User Defined Functions
8.Power of Baan's Native data dictionary
9.Code Generator for data transformation
Know more about this performance blasters .10.Excel pivot table
FastTrack to ERPJEWELS :