esProc 2012 IDE

esProc is a script for structured data that delivers more flexibility and ease to your complex business data computing and analytics. esProc Leads to 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. In addition, esProc provides a grid style analysis interface to facilitate users for organizing layout and observing the relations of various steps, enabling users to conduct multi-step complicated analysis. 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. Comparison between esProc and SQL esProc applies to quantities of structured data computation and complex multi-step calculations, and is good at coping rapidly changing calculation target. esProc has similar SQL computation capabilities, but it is much easier for users without SQL expertise to analyze the data at their will independently. esProc introduces the concepts of step-by-step computing, set datatype, ordered set and object reference to simplify the complicated data process against the computational complexity of SQL. The step-by-step computing allows to divide the complex calculation goals into simple and small targets and reuse the operation result of each step, thus completes complex tasks by solving simple and small targets. The set datatype makes data calculation realize complete set-lizing, transforming obscure lower level calculations into more business-focus intersection, union, and complement. The object reference can turn complex and lengthy multi-table associated statement into a simple object access, which is user-friendly and intuitive to analyze problems from business's point of view. esProc Makes your EXCEL Tell you more esProc can save you the mess and inconvenience when you re-process the data in excel(or txt), as esProc can load the data in excel files and re-compute them easier. esProc is a tool designed for bulk data computation with the ability of SQL and high-level languages, which can query, filter, group, and handle statistics like SQL statements while with lower technical requirements for users than SQL. Similar to VBA, esProc can handle loop execution, branch judgment, parameters execution in the analysis process, as well as professional optimization for structured data calculation. esProc is suitable for non-technical staff to conduct complex calculation and analysis with Excel, which is more convenient for excel data mining, enabling valuable data to support better business decision-making and give full play to the maximum value of the Excel. Good Helper for Reporting Tool 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 analysis 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, at the same time, has lower requirements than SQL for users, and is the ideal auxiliary tool for report designers.