Methods and tools of on-line analytical data processing for Siberian region government

The authoring OLAP-system “Analytic” based on integration of DOLAP architecture and MOLAP functionality is represented. The original embodiments of the OLAP rules realization are described. Functional modules of the “Analytic” are described. The data access tools for constructing cube based on data from different local sources (e.g. Excel, Access, InterBase, MySQL, Oracle) and data warehouse are developed. The data mart manage tools are developed. The dimensional cubes are processed by original OLAP tools: statistical table, cross-table, diagram and map for geographic data. The original high-level programming language to create scenario of the fact calculation in to a cube is realized. The cubes sharing method to store a cube as the materialized view and semantic metadata in the data warehouse is suggested. The method of creating and committing step-by-step calculating algorithm using pre-aggregated cubes is considered. Tools for forming operative and statistical reports based on results of OLAP are described. The complex of proposed methods and tools enables Siberian region government to improve effectiveness of decision making support based on OLAP. The “Analytic” usage for control medical care, governing in the field of social support and planning the social economic development of territories is represented by using the examples.