CUBE Data
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.
Main Purpose
Data import from operational databases and further aggregation according to specified parameters.
Issuance of analytical information upon request.
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.
Presentation of aggregated data in tabular and graphic form through the Web interface.
