ERPJewels

1. ERPJewels Jewelex Creations Pvt Ltd, 124C, Mittal Court, Nariman Point,Mumbai 400021, India. Email : css@erpjewels.com Phone : 91-22-56938505.

2. WHAT Is ERPJewels • Tool to Extract, Transform (Baan 4 GL) and Load (Visual Basic) info • Unique integrated DTS & BI Tool • Automatic Analyses Results Generator (PUSH Intelligence) • Data Marts & Data Warehouse resident in Baan • Tool to maximize ROI in Baan with little investment

3. WHY ERPJewels • Need for Multi-Dimensional Analyses • Need for integrated and scaleable DTS • Need for Graphical Data Representation • Insufficient Baan knowledge at Senior user levels (Lot of Data digging avoided) • Need for system driven PUSH intelligence rather then user driven PULL intelligence • Need for flexible Ad hoc reporting • Need for Exception reporting

4. WHY Excel • Manager’s software (Easy to Use) • Web enabled output possible with MS Excel (MS Office 9 onwards) • Excellent Graphical capability. • Pivot Table in MS Excel is an excellent multi-dimensional querying functionality within MS Office. • Limitation of MS Excel doesn’t apply due to summary nature of output and • ETL technology.

5. Other Companies promoting Excel for Business Intelligence • Actuate Corp’s e.Spreadsheet • Nobilis Software’s Ci • Microsoft’s soon-to-come Office 11

6. ETL methodology BaaN Data Sources 1.ASCII files. 2.BaaN table. 3.BaaN Report. Extracted Information Extract BaaN 4GL Transform BaaN 4GL Summary Data Marts Load Visual Basic6 Excel Output Optionally summary results can be saved in Baan tables after Transform process.

7. HOW ERPJewels • Maximum use of Baan’s agile data processing Capacity • 3 Data sources viz. Baan Report, Baan Table and ASCII file • Extract and Transform in Baan 4GL and Load in Visual Basic 6.0 and MS Excel sheet as Output • Seamless integration with Baan Job Management

8. HOW ERPJewels [2] • 4 Excel based Output format (Excel Summary, Group By,Pivot Table and Save as XLS) + 1 Interface output • User Interface capable of handling all requisite data types in single container. • Use of Calculated data fields (Date categorization , number classification , text classification etc) • Easy hierarchy creation,maintenance and usage

9. System Requirements • Baan 4c4 (Any Service Pack) • Microsoft Office 2000 (9) or 2002 (10)

10. 3 Data Sources Exception Norms 4 Excel Based output Integral DTS Recognition of unequal period length and non-date time fields by Job management. Recognition of reports printed through user choices and brp.open in Job Management Calculated Fields Graphical Output ETL Methodology Backward and forward Integration Functions & Features

11. ERPJewels Hierarchies • Hierarchy generation for Parent Child relations in Baan database and Expressions based parent child relations • Period Hierarchy based on Baan date field • Link of hierarchies to analyses , its validation and usage in output

12. Baan Report As Data Source • Almost all powerful data processing capacity • Data Source with great MIS value requiring virtually no further Transform action in ETL (especially After field layout section) • Limited Data dependent font/color changing • No Graphical Capability • Unable to generate data dependent Columns • Limited Aggregate data value manipulations

13. Peculiarities Of Baan Report • Derived Data Source • Selection Criteria In-built in Baan • Possible one to Many relationship with analyses/output • Difficult Data source fields (Report output variables ) Labeling • Possible synchronization with Job management • Hierarchical relationship between data for natural drill down.

14. Excel Load Clients

15. PUSH Intelligence • From date in a session set correct when used in periodic (with unequal number of days) job with the tool • Nod-date time indicators like Fiscal period , week etc recognized in Jobs with the tool. • Recognition of reports printed through brp.open and through user choices in the tool for job scheduling.

16. Data Marts - Need • Periodic Archiving / purging of transaction data • CPU intensive Analyses • Heterogeneous Systems • Facilitating modern tools to do user friendly graphical reporting without having to do complex data processing (Extract and Transform) • Periodic Analyses Consolidation

17. Data Marts - Features • Created with Best use of Baan all powerful data processing capabilities • Data Marts resident in Baan itself • Data marts stored in multi-dimensional format using relational technology without any limitation on its size. • Possible Backward & forward integration • Consolidation of analysis available over period and heterogeneous analyses

18. ERPJewels Data Warehouse Architecture Data Marts Data Sources Client Applications Sales Analysis ERP Tables Income Expense Baan Resident Data Warehouse CRM Tables ETL Layer Producti vity SCM Tables Aging External DS

19. Backward & Forward Integration Data Marts ERP Extract & Transform • Need for updating Transaction data based on analyses results (e.g.Updating budgets /estimates ) • Tool to activate any customized program (immediately after a Transform action) which can read the results value from Data warehouse resident in Baan and update transaction database in Baan accordingly.

20. DTS not integrated with Baan Baan report can not be recognized as data source Separate server required for storing data marts in multi-dimensional formats. Powerful integrated DTS in Baan without limits. Existing Baan reports can be considered as data source . Thus protecting existing investments Integrated with Baan Job Management Comparison with other tools ERPJewels Other Tools

21. Backward Integration from Data Marts to Production data not possible Pull Intelligence (User triggered only) CPU under-utilized in production server Baan Job Management Can not be used Backward Integration in-build in the tool Push intelligence (System generating periodic MIS) Existing CPU power of ERP used and optimized No separate DW hardware required Comparison with tools (Contd) ERPJewels Other Tools