ProduktiKlijentiZastupniciContactsTehnološki partneriDSE grupa
News releases
Implementacija na Srbskih železnicah
08.11.2016
Začeli smo z implementacijo TOMAS na Srbskih železnicah, http://www.serbianrailways.com/


Implementirali bomo module: TOMAS.DM (Upravljanje dokumentov), TOMAS.Projects (projekti), TOMAS.Meeting (upravljanje sestankov in sklepov), TOMAS.Cori (korektivni ukrepi), TOMAS.Proces (procesi).
Read more

Implementacija TOMAS v Energetiki Maribor
08.06.2016
Začeli smo z implementacijo v Energetika Maribor, Slovenija, www.energetika-mb.si


Implementirali bomo module: TOMAS.BP (Plan), TOMAS.Dashboards (nadzorne plošče), TOMAS.Reports (poročila), TOMAS.Projects (projekti), TOMAS.Cori (korektivni ukrepi) 
Read more

Implementacija TOMAS v skupini Don don Srbija
08.09.2015
Začeli smo z implementacijo v skupini Don don, Srbija, http://www.tvojih5minuta.rs/


Implementirali bomo module: TOMAS.BP (Plan), TOMAS.Dashboards (nadzorne plošče), TOMAS.Reports (poročila), TOMAS.Projects (projekti), TOMAS.Cons(konsolidacija), TOMAS. Meeting (Sestanki)
Read more

IZVEŠTAJI POVEZANIH PREDUZEĆA

REPORTS OF AFFILIATES

The application is intended for parent company services which define and collect the reports of affiliates.



Reports elements

A parent company first completes a code list of report items (code, name, etc.). The controlling opens all items in this code list, which will later be used in individual reports. Each item can be used in several different reports.
 

 
The application enables users to create formulas for individual items of a report with all the main mathematical operations.


Defining reports


First, the title of a report is defined, if necessary, a short description is added, and the first date of submission, as well as the frequency of submission (daily, weekly, monthly, quarterly, half-yearly, yearly or occasionally) are determined. It can also be defined that users are automatically notified by e-mail two days before the date of submission and every day after that date if they are late with submission. A report form (e.g. Excel file) and instructions for the completion of the form can also be added. We define companies obliged to submit that report and where on the portal the report will be published. Descriptions, forms and instructions can be submitted in several languages.


Controlling can independently create the form of reports. Users determine which items from a code list will be shown in lines of the report. They also determine an arbitrary number of columns and to what month, year and version the report refers.

Columns of the report can be locked, which prevents the entry (editing) of data for previous periods.

One or more reporters of individual companies are defined through an administration console on the portal. To each reporter, a username and password for signing up to the portal are assigned. By signing up to the portal, a list of all required reports is provided in the Submission of Reports segment. Reports are visually marked with the information on a report status (delayed, just before deadline, rejected, etc.). Users can see when they have to submit a report, they can view a form and instructions for submission. Users can also add a comment (reasons for deviations from a plan, adopted corrective measures, etc.) to a submitted report.


Review and publishment of submitted reports

This section is intended for parent company services which review submitted reports of affiliates. In reviewing, filters by all parameters of reports (companies, type of report, date, status, etc.) are provided. Submitted reports can be opened and reviewed, they can also be rejected or approved on the basis of a review, and comments that will be published together with a report can be added. A report will be published (visible to management and other responsible persons) only after the approval by the relevant service of a parent company. For each report (especially in case of rejection), a subject can be opened on the forum, which enables the exchange and coordination of reporting, and correction of reports.

Report data are stored in a base, and reviews and comparisons for different time periods are enabled. Reports also include the version dimension which enables the entry of the same report for a plan, realization or evaluation (a version in also a code list created by users).

Construction of data warehouse and OLAP analyses for the purpose of controlling

In today's business world, accurate and timely business decisions are of extreme importance. Information systems in companies consist of enormous quantity of data stored in many different data bases. In such environments, data analyses are time consuming and do not offer support in business decisions.

Data submitted by affiliates for the purpose of controlling are collected on the basis of Excel tables.

Construction of a data warehouse

Modern holdings build data warehouses for that purpose. A data warehouse is connected with data collected in Reports submitted by affiliates for the purpose of Consolidation, so that those data can also be used in analyses. A data warehouse has the following functions and features:

  • Reduction of time for collection and preparation of information, since data are collected by submitting data through entry forms on the Portal. Capturing of data from Excel tables is also possible
  • Simple integration of data from different sources into a unified view
  • Data warehouse is connected with data which are collected in Reports submitted by affiliates for the purpose of Consolidation, so that those data can also be used in analyses
  • Data are stored in a base, which enables time analyses and comparisons


OLAP analyses for the purpose of controlling

The warehouse also includes an OLAP model with the OLAP tool for the purpose of analyses. OLAP is analytical software for the purpose of business decision making.

It consists of a programme set for an administrator and a set for users – clients. It has the following functionalities:

  • Preparation and cleaning of data
  • Creation of views or »cubes«
  • Changing of dimensions by columns and lines
  • Preparation of standard tables for multiple reviews, storage of reviews
  • Export of tables for direct printing or export in Excel
  • Editing of dimensions (adding, sorting, exclusion, fusion of data)
  • Different queries by data structure – drill-down system
  • Graphic display of tabular data
  • Data from OLAP can be exported in various formats: MS Excel (directly into a programme), PDF.

The review of Report data in OLAP cube is possible also through excel add-in. Through excel add-in we can open all Bookmarks, prepared in OLAP. It opens then directly in Excel, here we can format it, color, add our own calculations from OLAP data etc. This excel we can save and then open next time and refresh with OLAP data automatically. That is very useful for automation of report's preparation. Same we can do with Word add-in. 


Technical requirements

Data server: Windows 2000, Windows NT, Linux, Pentium II 1GHZ or higher, 2GB RAM, hard disc 100GB or bigger.

Oracle 8i or higher.

PC client: Windows 98 or higher, Pentium II 500MHZ, 128MB RAM, hard disc with minimum 100MB of free space.

FREE TRIAL AND RENT IN CLOUD
if you want to try it for free send as a request. If you will like it, you can rent for convenient price of 696 EUR per month (up to 10 companies in group, 3 OLAP users and one excel add-in, unlimitet number of reporters)