📜 ⬆️ ⬇️

I needed a report ...

It often happens that the ultimate goal of the existence of an enterprise information system is the relevance of the reporting data used by company management or provided to government bodies.

At the same time, approved reporting requirements are already in place, as are reports that today, of course, are not compiled on paper, but, say, in MS EXCEL, but often still contain unsupported summary figures sent "from departments". Of course, the quality of this information is positively affected by the high likelihood of subsequent checks and the severity of liability that comes from, but this does not save from mistakes. One can not talk about how this “work” of specialists distracts from their professional activities and their attitude to reporting.

Of course, now many organizations have inventory accounting information systems, but the structure of a specific accounting is determined by the configuration of this information system and the underlying information model of the organization’s accounting objects.
In this article I want to describe the approach to the design of the information model of the accounting (inventory) system based on the requirements for the necessary reporting of the enterprise ...

Obviously, primary data from places is still needed for the current summary report, and in order to avoid emergency hands during the reporting period, field users must regularly enter the necessary information. In order not to overload many users with unnecessary work when creating a system, it is necessary to clearly define what minimum necessary input data are needed for reporting. The composition of these data and their organization together determine the information model of the system.
')
In my opinion, one of the key criteria for the quality of the information model is the accuracy of the reflection of the simulated physical reality. But the track is like a “model” - it should reflect only the objects that are significant for the applied tasks, their properties, and their interrelationships.

Infrastructure model


For example - the infrastructure model of any enterprise in general contains:


An analyst who understands the business of an enterprise can quickly form the core of an infrastructure model — select the composition of objects necessary for accounting and build one or several hierarchical trees from them. Further, when it is necessary to determine the composition of the attributes taken into account, the proposed method for analyzing the required reporting using the so-called “Chessboard” can be useful.

Chess boards


Perhaps now there is some kind of ready-made solution for solving such problems on the market, maybe even all of this can be done in Excel, I will be happy with advice, suggestions and alternative proposals. I did not find anything ready and had to write my small piece in the corporate web application environment on the ORACLE DBMS platform (the point is not how it was done - the article describes the general principle).

The image of the required report is downloaded as a scan (photo) and placed under the transparent “Chess Board” from which only the markup is visible in the pictures. This board is - in this case, just a transparent table placed on top of the report image loaded into the system. The table has column markings in letters and rows in numbers, which allows you to visually determine to which cell the picture area belongs - a report scan containing an element of interest to us. Naturally, the scaling of the image scan and the table in the browser should be synchronized so that nothing slips.

In the user interface it looks like this (examples of reports for railway workers):





Everything is simple - there are 2 frames - in the right is the very picture on the “Chessboard”, and on the left is a table for manually entering the rows containing the necessary ones (according to the analyst):


Accounting model formation


Thus, the information model of the accounting system (inventory) is formed on the basis of the Objects and their parameters used in the specific required reports.

Accounting and Objects and their Parameters were previously formalized in the form of separate reference classifiers - the result of this is formed:






The second picture on the right shows the links to the reporting forms for the formation of which there is a parameter in the card.

Conclusion


In practice, the use of this approach allowed:




Thank you for attention!

Source: https://habr.com/ru/post/283542/


All Articles