Integration of «key indicators» software with operational system
Category: Information SystemsThe picture below shows the technology of integration of «Key Indicators» software with operational systems.
The picture below shows the technology of integration of «Key Indicators» software with operational systems.
As an environment for development and a meta-level for data storage Microsoft Access 2000 was used. Using internal MS Access abilities to create links with tables from almost any DB, we established links with tables from the Key Indicators data warehouse and with tables designated for export of data on average price per product from […]
When designing the structure for the Key Indicators data warehouse we used PLATINUM software products belonging to the ERwin 3.5.2 and Model Mart family which is used to design
Hierarchy of Key Indicators The list of key indicators is a hierarchy where information is aggregated from the lower level of detail into a limited number of general aggregated key indicators.
Technology development includes the following main steps: Development of a logical physical structure of data in the central database and data in «portions» transmitted from subsidiaries.
Requirements of managers in terms of necessary information should be formalized via an informational and logical scheme presenting pieces of information and correlations between them.
At this phase one should formulate requirements of managers in terms of information they need to manage company finances efficiently:
If a central database in the head office of the company will contain all data from all the subsidiaries any database will soon be congested. That is why it seems to be reasonable to differentiate between data used for financial accounting and those for management.
There have been few fully successful SAP, BAAN or other ERP implementation projects in Ukraine. The main risks and mistakes for such projects is the fact that business processes, document flows, management procedures and management thinking need to be changed during the process of ERP implementation in a relatively short period of time.
To enhance financial management a company typically needs to integrate its information systems, if one or more of the following criteria are met: