The CUBE Data service is a data warehouse support subsystem that allows for rapid multi-faceted data analysis, has the ability to manipulate and analyze data from different perspectives. Organizing data into cubes overcomes the limitations of relational databases. Such databases are not very well suited for almost instantaneous analysis and display of large volumes of data. Rather, they meet the requirements of creating records through a series of OLTP (Online Transaction Processing) transactions.
Data import from operational databases and further aggregation according to specified parameters.
Use: A company may want to analyze some financial data by product, by period, by sales location, by revenue type, and by price, and compare actuals to budget.
Issuance of analytical information upon request.
Presentation of aggregated data in tabular and graphic form through the Web interface.
With a high level of operations automation, you can significantly increase the number and profitability of these types of services. Besides, it is very important for operations to ensure: the maximum control of the completeness of information, the speed of the operation, the convenience of entering information and the efficiency of further processing of data.