The framework provides wide possibilities for designing and interactive work
with reports:
intellectual creation of hierarchical, multidimensional and cross reports;
retrieving user-specified analytical data without modifications in an
applied solution;
tables support grouping and aggregation of information, drill-down
functionality;
summary table to analyze multidimensional data, dynamical report structure
modification;
various charts and diagrams for graphic representation of economical
information;
geographic chart – for Visual data representation from geographical
location point of view;
For geographic chart shape-files with topologic data are used. They can be
created with ESRI ArcGIS-compatible software.
At that, one can change the chart scale, getting detailed information, as
well as create new charts.
Data
Composition System
This system allows to build reports on the base of declarative description,
manage report building, create reports “without programming”, etc.
It allows creation and customization of representative reports having complex
structure, including any number of spreadsheets, diagrams, charts,
geographic charts, data analysis and prognosis, etc.
This system allows implementing the following capabilities:
Build reports without programming.
Use automatically generated Browse form and report settings.
Fragmentation of report building process into several steps.
Execution of several steps of report building on different computers.
Independent use of several parts of the data composition system by
different users.
Programmatic report building process control.
Business Data Analysis
The business data analysis mechanism provides users with a way to detect not
obvious patters (regularity) in data accumulated in their information base. This
mechanism allows:
Search for patters in initial information base data;
Adjust analysis parameters;
Generate a tabular document on the base of analysis result;
Create forecast models providing forecasting further events or values of
some characteristics of new objects.
This mechanism gives a developer a possibility to include to the business
application some means for mathematical analysis of management information, with
minimal efforts. To represent results of the analysis there is a set of various
diagrams and charts, including Gantt chart.
For the purposes of analysis, not only database data can be used as input
data, but also data from external source being loaded into a table document.
Implemented types of analysis include:
General statistics. It is a mechanism for collecting information on data
contained in the set being analyzed. Intended for preliminary examination.
Search for associations. It searches for groups of objects or
characteristics’ values often seen together and searches for association
rules. It can be used to detect groups of items (or services) often bought
together.
Search for sequences. Detects sequences of events in the source data, such
as a series of items or services often bought one after another.
Cluster analysis. Breaks source set of objects being analyzed into groups
of more similar objects. Examining these groups (clusters) one can find out
what is typical of one of other group and to make a decision as to how to
operate on objects from different groups.
Decision tree. This type of analysis allows building a hierarchical
structure of classifying rules. Analyzing various characteristics of objects
it provides a forecast. For example, analyzing known characteristics of
partners, (such as annual turnover, number of stores, amount of purchases,
etc.) it can forecast, for example, for how long time this partnership will
go on.
Aggregates
Aggregates – is a special mechanism implemented in turnover accumulation registers. Using
aggregates allows to significantly reduce report generation time.
Every aggregate is a storage of a special kind, containing aggregated
register data by various dimensions, convenient for generation of reports in a
given information base. The system automatically estimates the usage of various
dimensions by users, then from this statistics it selects an optimal set of
aggregates supported.
The system includes a special
Aggregates Wizard to adjust a set and properties of aggregates.