Ranet OLAP

Ensuring fast and effective work of the user with the multidimensional data Analysis Services (SSAS) on the Internet is one of key tasks during creation of BI solutions on the Microsoft SQL Server platform. Market research of the software showed absence a component which optimum would conform to requirements for functionality, licensing terms and the cost, convenience of using and ergonomics.

The Galaktika corporation organized development necessary a component by own forces. The product Ranet OLAP with functionality which in a complex was not offered earlier by any of other producers became result of the carried-out work.

The Ranet OLAP components are one of solutions for SSAS, the first in the market, on Microsoft Silverlight and the only component having:

• the designer of any reports the end user on the basis of pivot tables with the Drag and Drop functions, automatic analysis and generation of MDX requests (MDX designer);
• The MDX parser providing analysis of any MDX request of any level of complexity, including intersections (Crossjoin) and formulas both written by hands and generated automatically by the MDX designer. At the same time the object model for multidimensional expression (Document Object Model, DOM) on the basis of an abstract syntax tree is under construction (Abstract Syntax Tree, AST);
• The MDX generator providing generation of a MDX request at detailed data analysis in the pivot table using services Expand/Collapse, Drill Down/Up for any measurement of a multidimensional cube;
• the pivot table with support of reverse notation in a cube (Writeback) that gives the chance to edit data of a cube via the Internet and relevant for problems of consolidation of the reporting from remote branches, planning, modeling;
• the know-how implementation of data exchange between the client and the server - the format JSON + ZIP 90% more effectively and quicker than the standard format XML/A + ZIP, acceleration is especially noticeable on large volumes of data.

The Ranet OLAP library was placed on resources for drafts open source (http://ranetuilibraryolap.codeplex.com/ and http://code.google.com/p/ranet-uilibrary-olap/) and attracted great interest of community of developers. Pages of the websites of the project were visited by more than 80000 users, about 7000 loadings of source codes of the project are performed. At the same time the project will show steady dynamics of visits and loadings.

The Galaktika Corporation had customers in the USA, Great Britain, Germany, France, Australia, India, China, etc., using Ranet OLAP library during creation of own solutions. Among them there are an investment bank, the university, the companies which are engaged in software development and an autsorting of business processes and also independent developers.

The Ranet OLAP components are used in different applications and the industries, such as: analytical applications and Business Intelligence (BI solution) for business, support systems of acceptance of management decisions, applications for medicine, scientific research, etc. Also the Ranet OLAP library was used when developing Galaktika the Business Monitor, Galaktika of Business Intelligence (BI), Galaktika of SUIP and other internal products of corporation.