IBS Planet OLAP Platform

IBS has developed a universal platform "Planet," built on the basis of OLAP technologies, allowing to automate the management tasks of planning, budgeting, analysis, forecasting and formation of production programs.

Planet is a Russian development designed to improve the efficiency of business processes through the introduction of specialized solutions. Optimization of management processes is most important for federal and regional management structures, representatives of the public and commercial sector, as well as military-industrial complex enterprises, medium and large businesses.

2024: Postgres Pro DBMS compatibility

Postgres Professional and the IBS Group announced compatibility of their products on July 4, 2024.

The certificate issued by Postgres Professional confirms the correct operation of the Planet platform. And products based on it developed by IBS, and Postgres Pro Enterprise, Postgres Pro Enterprise Certified and Postgres Pro Certified (versions 14, 15).

Over the past year and a half, we have seen a multi-fold increase in demand from our customers for the implementation of Postgres Pro DBMS. That is why it was important for us to check and confirm the compatibility of the vendor's solution with the Planet platform.. The testing has shown full compatibility of products, which gives a quality guarantee to our customers when implementing the Planet. Platform, - said Konstantin Kurdyumov, director of the department of own platforms at IBS.

2021

Add Planet modules. Access "and" Planet. Architect "

On November 30, 2021, IBS announced that its Planet platform was replenished with two products - Planet. Access "and" Planet. Architect. " Both modules were successfully registered with Rospatent.

Planet is a tool for improving process efficiency, creating industry data models, and enterprise-level recommendation systems. Specialized functional products are used to solve specific business problems: "Planet. Analytics, "" Planet. NSI "et al. With the advent of "Planet. Access "and" Planet. Architect "the platform's capabilities have expanded significantly.

"Planet. Access "is one of the key products of the entire system. It is responsible for the correct display of data and authorized access for users to view and edit confidential information. Key Product Features:

• Setting up an authorization role model
• identification and authentication of access subjects;
• authorization of access subjects;
• management of access subjects and access objects;
• Configure the data filter. You can create a model filter for a user group. This solution allows you to differentiate access to different data within the same data model;
• Connecting external authentication providers/SSOs
• Log all meta-information changes.

"Planet. Access "is the core of the platform, it is at the kernel level that access rights and role models are distributed. From a business point of view, this is security, data protection, delineation of rights, said Elena Alexandrova, director of the IBS own platforms department.

Module "Planet. The architect "will appreciate the architects of information systems and analysts working with databases. The product is a solution for direct and reverse design of relational database schemas. Among its main functions are:

• design of conceptual, logical and physical layers of the DB diagram in a convenient visual interface;
• generating a SQL script for a physical model, taking into account the dialect of RDBMS (PostgreSQL, Hive);
• Integration with document and source code versioning systems based on git technology
• Reverse design of a physical model from a database schema SQL script
• comparison of DB schema versions and automatic updating of the physical model based on changing the SQL script of the DB schema.

In fact, this is a service module, but with very great application prospects. It allows you to visualize the relationships between entities within the platform: see databases, the relationships between them and in design mode, customize data models without writing code. From a business point of view, this is an opportunity to save the resources of programmers and analysts by quickly and clearly setting up relationships between data, noted Elena Alexandrova.

"Planet. Access "and" Planet. Architect "gives customers advanced capabilities to implement industrial solutions developed entirely based on Russian technologies and open source software.

Based on MyOffice Analytics software

The company New cloud technologies"," Russian a manufacturer software of office for document collaboration and communication, on January 27, 2021 announced the launch of the application "" MyOffice for, visualization processing and analysis. data The application "MyOffice Analytics" is fully domestic decision developed by "MyOffice" on the basis of the platform "Planet" of the Russian company. IBS More. here

2019

Inclusion in the MyOffice ecosystem

On September 11, 2019, the company IBS announced that it had New Cloud Technologies jointly signed a partnership agreement with "to introduce the IBS technology platform Planet into the ecosystem. MyOffice The solution will allow you to perform economic and statistical calculations and perform tasks analysts big data in the spreadsheet editor "MyOffice Table."

For MyOffice users, for analytical processing, just select the data in the MyOffice Table application and launch the analytics module. The system will instantly perform calculations and display the results in the form of graphs and diagrams. The solution will allow you to create visual analyses without switching to other windows and programs that can be built on the database from any source.

In addition, users will be able to use the web version of Planeta.Analytics directly from the private cloud interface MyOffice. The analytics app will also be available on all types of supported devices - personal computers and smartphones.

Enterprise users, especially employees of analytical and financial departments, need convenient means to work with various reports and large amounts of data. Our joint solution with IBS simplifies their daily work and provides tools for intuitive analysis and visual representation of data,

The Planet line is created based on our experience with both classical and advanced digital architectures, bringing all the best from different technological generations. Thus, it not only successfully competes with "traditional" products, but also allows you to solve many problems faster and more conveniently. We see the partnership with New Cloud Technologies as a confirmation of the maturity of our product and the interest of partners. This is the second large-scale experience in synthesizing Planet products with other platforms after a project with IBS subsidiary BFT, and we see a promising direction of cooperation in the development of such plugins and add-ons.

Process Core and Function Modules

• Development in Microservice Architecture
• Reliance on class-leading SOEs (in-house development with no alternatives and integration components)
• Open, documented, stable APIs () API
• Explicitly separating basic functionality (kernel) and expansion points
• Mandatory use of diagnostic and monitoring tools
• Main method of software delivery - docker containers
• Committed technology stack (e.g. React, AntD, Echarts, NodeJS, Java (Spring), C++, pgSQL)
• Single DevOps infrastructure (for example, Kubernetes, Jenkins, Ansible, BitBucket, Confluence, Jira, Slack/Zoom, xunit/jest, Prometheus, Swagger, maven/npm/nuget, etc.)

2017

Advanced Enterprise Management Solutions

As of July 2017, there are many offers on the market for enterprise management processes from both domestic developers and foreign companies.

Western solutions are distinguished by a high technological level, developed functionality and flexibility. They allow you to process large amounts of data and simultaneously work with a large number of employees, including remotely. However, foreign software is characterized by a high cost of licenses and implementation, and as practice shows, manufacturers cannot guarantee system maintenance under sanctions restrictions. Russian developments are often not inferior in functionality to Western counterparts. They are more affordable for small and medium-sized businesses, but not always suitable for large enterprises with complex internal business processes and a large number of users. The cost of domestic products is lower, while they are less common and have less experience in implementation.

Planet products are included in the register of Russian software and surpass Russian analogues in technological characteristics, standing on a par with the leaders of the foreign market, while the cost of solutions based on the Planet platform is significantly lower.

Unlike a number of systems focused on use in specific industries (public sector, banking) or to solve narrow problems (miscalculation of investment projects), Planet solutions are applicable in all areas. This advantage in the combination of "price-quality," taking into account openness to programmable extensions, ease of change, a flexible approach to creating complex multidimensional business rules and extremely fast performance, makes Planet profitable in the Russian market.

Features of the Planet platform from IBS

The Planet platform is a universal, efficient in-memory MOLAP open source platform for implementing CPM and BI class tasks, with integration capabilities with the most common ERP systems, built-in WEB and Excel interfaces, rights and workflow management system, ETL tools and API.

Planet - IBS Strategic Enterprise Management Solution

Planet provides convenient means for organizing data and distinguishing access rights to it at various levels using the SVS module. Using the Excel add-in or the web interface, you can quickly create data stores, differentiate access rights and provide all interested parties with a familiar tool (Excel) for editing/analyzing department or company information. At the same time, since the data is in divided access, the changes made by one person, without any additional effort, will be available to all participants in the process.

The ETL module for loading/uploading data to the Planet allows you to create scenarios for importing data. Data sources can be either flat files of type csv or N-C format, as well as various databases, xml files, web services. To keep the databases up to date, ETL provides the ability to run scripts on a pre-configured schedule.

Depending on the installed module, user interaction with the platform occurs through Web applications on user workstations, it is also possible to interact with the system through the application on mobile devices (operating systems iOS,). Android

IBS Planet Platform Capabilities

"Planet" is optimal for the creation and maintenance of budgeting systems, analysis of financial and production information, real-time processing of large arrays of complex, multifactorial information. The most important for strategic enterprise management are budget planning and control, cost and cost management, financial and operational reporting, data analysis, modeling and forecasting of the future state. The following modules have been created on the basis of the Planet platform:

• "Planet. Budgeting "
• "Planet. Cost Management "
• "Planet. Reporting "
• "Planet. Analytics "
• "Planet. Forecasting "
• "Planet. Production "

Each of the listed modules is an individual product and can be installed and used independently according to the needs of the enterprise.

Module "Planet. Budgeting "has all the necessary functionality for organizing budget management and planning at the enterprise:

• creation of any algorithms for calculating budget indicators
• support for budgeting regulations
• scenario and plan-fact analysis in a single interface
• rapid mastering of the toolkit through the Excel interface
• the ability to independently develop budget models due to intuitive business rules
• processing large amounts of information in real time with no additional consolidation costs at a high level of detail
• A toolkit that allows you to easily communicate with your corporate information environment.

Module "Planet. Cost Management "provides:

• compliance with legal requirements;
• Improving the accuracy of plans and forecasts
• reducing discrepancies between planned and actual indicators;
• high analytical accuracy of data on the cost of GOZ products, economic validity of prices for military and dual-use products;
• accumulation of a database on product nomenclature, cooperation systems, resources and prices;
• identification and elimination of inefficient costs;
• information processing efficiency;
• Create a favorable analysis environment.

Module "Planet. Reporting "allows you to form a complete package of financial and operational reporting for regulating the activities of defense industry enterprises and provides:

• finding a balance of interests of state customers and DOZ executors;
• opportunities for operational and strategic management of funding allocation;
• monitoring of the cost structure of the BBST and compliance with the requirements of authorized banks;
• risk monitoring;
• factor, structural, and dynamic analysis, modeling, and forecasting.

Module "Planet. Analytics "is a modern BI system with descriptive, predictive and prescriptive analytics functions that allow business users to quickly and conveniently explore data on computers and mobile devices:

• extract data yourself (including Big Data)
• make flexible queries to find relevant information
• implement flexible analytical and predictive models
• Form corporate reporting and performance indicator panels

Module "Planet. Forecasting "allows analysts based on advanced high-performance mechanisms to quickly form models of production and financial performance at any planning horizon. The modeling tool is a key foundation for management to make balanced management decisions to identify key trends, identify bottlenecks and optimize the company's business processes.

The Planet: Production module is a modern complex system, the functionality of which is to automate the following tasks:

• formation of an optimal plan for production and sale of products (production program) of the enterprise in natural and cost terms
• scenario modeling of the production program through the assignment of various production factors
• creation of a production program for any production element of the logistics network of the enterprise (workshop, site)
• generation of an executable production program using statistical information for prompt adjustment of material consumption rates and calendar and planned standards
• calculation of forecast or probabilistic values in case of lack of data
• selection of the optimal operating mode of the equipment depending on the dispatching task.

Planet is the right solution for a successful enterprise.

www.ibs.ru

Material prepared with IBS support

156