Profile cover photo
Profile photo
Raqsoft BI OLAP
Raqsoft focuses exclusively on the development of Business Intelligence (BI) solutions
Raqsoft focuses exclusively on the development of Business Intelligence (BI) solutions


Post has attachment
Dynamic Criterion in Report Building
You can perform data sorting in
both the report script and in SQL. But both are only capable of sorting data by
specified field(s). To sort data by a specified list, you have to compose the
code using functions like decode and union. If the sorting criterio...

Post has attachment
The Standard Method of Performing Transposition
Sometimes the source data needs to be transposed before displaying
it in the report. But cross table can only handle the most basic transposition.
Most of the scenarios need to be dealt with using SQL, report script or Java
script. Each way has its own tric...

Post has attachment
A Standard Method of Building Reports Presenting Link-Relative Ratios and Year-on-year Growth Rates
A link-relative
ratio is a percentage got by comparing the data of current period and that of
the previous period. A year-on-year growth rate is the rate of change expressed
between the current period and the same one from the previous year. Different repor...

Post has attachment
The Three Stages in Building Reports with Heterogeneous Data Sources

There are many different types of report data sources, including relational databases, NoSQL databases, local files, HDFS files and JSON data stream. It’s easy to build a report with a single data source, but it’s difficult to build one that needs data from more than one type of data source, i.e. heterogeneous data sources. The data preprocessing involving different data sources is always one of the bottlenecks in report development. This article will introduce three stages, from raw to perfect, in dealing with the heterogeneous data sources, and attempt in each stage to offer one or a few solutions with an example detailed.

Post has attachment
The Three-layered Reporting Architecture
A reporting architecture consists of three
layers from bottom to top – storage layer, computing layer and displaying
layer. The storage layer contains raw data, which may be stored in a relational
database (RDB), a NoSQL database, and a local or HDFS file, ...

Post has attachment
A Middleware for Data Reporting
there are three ways to prepare data source for reporting: 1. Retrieve data by
directly connecting the reporting tool to the database and submit SQL
statements to the database in which data source is prepared; 2. Partial data prepara...

Post has attachment
An esProc Code Example of Computing Link-Relative Ratio and Year-on-year Comparison
A link-relative
ratio is a percentage got by comparing the data of current period and that of
the previous period. Usually the interval between the two periods is a month (sometimes
an hour, a day, a week and a quarter). The link-relative ratio of April is ...

Post has attachment
Grouping In-memory Data Using esProc: Code Examples
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. Equal groupi...

Post has attachment
Code Examples of esProc Foreign Key Function
If k (a single field or a
combination of fields) is table M ’s primary key, and k , at the
same time, exists in table B , then k is regarded as B’s foreign
key. The foreign key defines a relationship between two tables and is one of
the most important conce...

Post has attachment
An Example of esProc Set Operations
There are a lot of occasions when set operations are needed to do
structured data summarizing and analysis. For example, to list all students who
have published papers, find the employees who have participated in all trainings
and select students who passed...
An Example of esProc Set Operations
An Example of esProc Set Operations
Wait while more posts are being loaded