Raqsoft esProc provides the ability of performing file-based computation. It supports multithreaded parallel processing to deal with problems involving relatively big data. The multiprocessing can make full use of the computational power of the machine’s multi-core CPU to achieve an almost equal or better performance t...
2015-04-30 497 0
There are some computational tasks of processing structured data that involves multi-table data sources joined through cascaded foreign key relationships. For example, you want to find particular orders from the order management system, where the following structure of cascaded foreign key relationships is involved. Co...
2015-04-29 407 0
In data analysis, we often need to group data and then compute the aggregate value for each group, or perform other computations on each group. esProc allows using groups function to compute aggregate values for groups of data, as well as grouping records of a table with group function for use in subsequent computation...
2015-04-28 410 0
Problem source: http://developer.actuate.com/community/forum/index.php?/topic/36204-split-data-row/ .
To split fields apart and recombine them into records, you can use the stored procedure or a report script. But as the code is complex, an alternative choice is using esProc to help the reporting tool with the job. Let...
2015-04-27 451 0
Irregular month grouping: If the start date is 2014-01-10, group dates from this date to 2014-02-09 together and dates from 2014-02-10 to 2014-03-9 together. If the start date is 2014-01-31, put dates f...
2015-04-25 385 0
Using esProc, it is quite convenient to group data in memory. There are several main types of grouping based on how data is grouped. Here we’ll illustrate equal grouping, alignment grouping and enumeration grouping respectively with an example.
That data is grouped by one or more certain fields (or one o...
2015-04-24 362 0
Here, we use esProc to analyze the upward trend in stock prices. There is a variety of algorithms, of which one will be illustrated in detail. Other cases can be handled using the similar codes. Specific requirements are:
Among the stocks which have kept going up for N days, what is the proportion of those that c...
2015-04-23 470 0
The calculation of opening balances according to deposit and withdraw amount involves inter-row operation. Jasper can do the calculation but the code is complicated. You can use esProc to assist the jo...
2015-04-22 618 0
Problem source: http://community.jaspersoft.com/questions/851148/loop-jasper .
The calculation of loan payments according to loan amount will involve loop operation and inter-row operation. It is difficult to write code for it using stored procedure or Scriptlets. Yet with the help of esProc, the Jasper calculati...
2015-04-21 1124 0
Generally intragroup inter-row calculations are handled with window functions or report scripts. But the code is rather complicated. Instead, you can use esProc to assi...
2015-04-20 496 0
Problem source: http://community.jaspersoft.com/questions/847490/how-get-annual-growth-rate-crosstab .
As every column in a crosstab is generated dynamically, you also need to reference them dynamically when performing inter-row calculations. There is some difficulty in handling this dynamic reference using a Jas...
2015-04-17 533 0
Problem source: http://bbs.csdn.net/topics/390611005 .
Below is JSON data (s.json) the system acquires:
“MESSAGE”: “IMEI Servi...
2015-04-16 433 0
Problem source: http://stackoverflow.com/questions/29396985/is-there-a-where-like-relation-function-when-using-pymongo .
It is difficult to join MongoDB collections through hardcoding as it doesn’t directly support joins. Yet you can use esProc to perform inner join, left join and full join between collections or join ...
2015-04-15 421 0
Problem source: http://bbs.csdn.net/topics/391014229.
Below is data from SL field of table tb1:
You need to calculate the sum of values every five rows. The expected aggregate result is as follows:
That is, the first column is the int...
2015-04-14 443 0
We often need to sort records in a table for data analysis and computing. esProc supports sort function to sort sequences or table sequences. External memory sorting is required when the data being sorted is too huge to be loaded into the memory all together and the ordinary sorting method cannot be used.
2015-04-13 368 0