esProc 2012 Desktop

Easy-to-use business computing script esProc is easy-to-use business computing script specialized in solving complex computing objects. It optimizes business data and has lower technical requirements. esProc is cell style scripts, allowing complex business computing objects to be divided into small objects in the grids for solving final objects. esProc is designed for business professionals, as its syntax is easy to use and understand with lower technical requirements. The scripts are aligned automatically in esProc, allowing users to observe the results of each step clearly and visually. Especially, the results can be referenced directly through the names of the cells, enabling users to compute freely according to business logic. esProc can run as a desktop application once it's installed. It goes on well in the enterprises' office environment without extra server. esProc can realize the interactive computing among various business databases for direct reading, computing and writing back the structured data in Excel and txt. More capable database computing script esProc is more powerful on structured data computing, particular for complex computation in database as a script language. esProc improves SQL computing ability with step by step computing, sequence computing, set-lization and object reference. esProc can solve complex database problems by dividing into several simple computing steps. Each step result can be referenced directly for further process without defining extra variables or changing the script. esProc is able to access the row number, column number and relative position, providing great convenience for data ranking, locating and sorting. It can also agilely handle complex database computation involves cross rows, relative position and relative subset. esProc's set-lization computing model can directly express the multi-layer sets unsupported by database, offering convenience to sets computation which are difficult to realize by database. esProc supports access multilevel associated data with "." and thus expresses the most difficult multi-table associate query with simple and visual objects access. esProc's syntax system and function package are oriented to structured data, which can process multiple fields and batch data meanwhile without loop statements. In addition, esProc has advanced features including branch, judge, loop, subfunction, parameter and macro for more flexible database computing. Report datasource esProc allows report designers to combine esProc's excellent computation and analysis capability with the strong presentation function of reporting tools. It can organize the disorderly source data and directly delivery clear data to reporting tools through the JDBC interface. Besides, esProc can also complete complex data analysis and give the analytical results to reporting tools for simple processing, and integrate the data from excel, txt, database and other data sources, and then submit to reporting tools in the form of a single dataset. esProc is beyond the computing power of SQL / SP, has lower requirements than SQL for users, and is the ideal auxiliary tool for report designers. Real OLAP esProc represents a broad category of OLAP tools especially for complicated structured data processing. It restores the true meaning of OLAP, which is reflected in the following aspects: First, it does not require pre-data-modeling for your analysis goal, breaking the limitations of traditional OLAP and allows users to freely conduct bound-free data analysis. Besides, esProc can conveniently reference and process the prior calculation results, allowing users to delve into the target core and tap the maximum value of data. Finally, it offers functions for real-time analysis and real-time computing, so as to automatically present each step of the analysis results, making users more ready to focus on business analysis.