Run Time Solutions

Runner WareHouse 2000

The analysis of data relating to business and the ability to make decisions based on information received, are strategic factors for the success of any organization. In a competition era, every day companies and their managers have to answer questions that relate directly to their ability to remain competitive to face market changes. In practice this translates into the need to understand better the relationship with its customers to be able to intervene quickly, grasping the changes that the market requires in terms of services offered, taking advantage in time and streamlining costs. For all companies, this simple observation involves fully the company information systems (and not only) that must now be placed in a position to provide answers to business questions even complex and must do it in short time. The solution is DataWarehouse. Over the past 10 years the use of data warehouse systems has demonstrated the importance and usefulness of these systems for businesses, but manytimes these projects are also manufacturers of large failures. Market surveys have shown that the reasons of success or failure are independent of the particular technology adopted for the design of data-warehouse, as well as for the BI applications. The main cause of failure is due to the following factors:

• Insufficient analysis of the information flow from business information system
• Incorrect configuration of hardware and RDBMS
• Reporting tools are too complex for users
• The use of "black box" is not very adaptable to business needs

The purpose of achieving a solution that gives an immediate added value to the business can not be achieved by methods and generic technologies, but only with specification and a particular focus. The experience gained from RUN TIME Solutions in developing management reporting systems, decision support layer for the control company (marketing, sales, management control), allowed to consolidate a proposal based on a solid substrate and on methodological use of technological tools for specialized companies to ensure the success of their applications DecisionWare (Business Intelligence and Data Warehouse).

It is important to know how to handle with care technology that is offered by the market to achieve successful solutions. In this context RUN TIME Solutions, through significant experience in the field of large distribution, proposes itself as the system integrator technology able to assist you in all project steps, integrating its own modules of BI and reporting with the most suitable technology to customer needs in order to obtain the greatest return of investment. Through Runner Warehouse 2000 companies measure turnover, costs, units sold number, etc. They use analysis to have a greater visibility of data such as the percentage of profit, contribution margin, return on investment. Runner Warehouse consists of three modules.

Warehouse Architect

Warehouse Organizer

Warehouse Presentation

Runner WareHouse Architect

It is the back-end module and the repository of the data warehouse system. It is designed to ensure a high flexibility in accessing data efficiently and economically, with the best performance. In this module we find the DBMS and the ETL server (Extract Transform Load) for the population of the database. The data house is Oracle 8i, which now allows the highest level of scalability, allowing you to design solutions to fit any business need. The database design and the definition of data capture process, updating and distribution of data, provides for the use of technological tools that better integrate with the information in the company through the ERP (SAP, JdEdward) and CRM (Siebel) for which Runner Warehouse Architecture offers interface modules already preconfigured. The consolidation process after the acquisition "cleans" the data and makes them more accessible to users without the necessary creation of complex queries. The information is stored in the way business is organized, sales per month to the region, the margin per customer per product line in the last quarter etc. All of this allows instant access to information to make the best decisions. With Runner Warehouse Architect is not necessary updating and adding new dimensions in the system to allow users to analyze data by new points of view because this process is completely automated and dynamic.

Runner WareHouse Organizer

In this data warehouse module, administrators and managers of information dealing with the complete data from ERP systems.
In particular we find:

• User and user groups administration: Users of information may be various from internal users such as the administration, control management, commercial director, to external users such as agents, branches, customers, business partners. This module allows you to set rules that will allow you to access to data by both reports in client server mode, and by the WEB with different driven menu depending of the user's privileges.
• Hierarchy products definition
• Hierarchy sales network definition
• Hierarchy customers definition
• Hierarchy discounts and marketing campaign definition

The data in these structures could be handled by the data client server procedures that are in the module or populated from Runner Warehouse Architect directly.

Runner WareHouse Presentation

So that users can take maximum advantage of the provided information, they must be able to access so diversified. The optimal solution requires a Web browser interface to provide information on the Internet to users who must use the standard reports. There is needed also a client-server interface on windows platform through which it is possible analyze the exceptions and explore the data in every single detail. This module contains both the features of the information publication.
The client-server sezioneIl paid to management, management control, sales director and all persons who must verify the data and analyze it in detail. From here you can view or create sophisticated report. To achieve these goals should have specific knowledge. The results are exportable dynamic relationships with a significant reduction in operating costs. The Web Server section allows an effective and economical data delivery. The information is aimed mainly to agents, subsidiaries, customers, business partners. This type of solution provides the maximum performance and better response times. Users who navigate via web can receive quickly the predefined reports. Both solutions allow users to use easily known tool such as Microsoft Excel. This powerful functionality is also used to extend the capabilities of analytical of the business intelligence instruments to the simulation data and projections, functionality not otherwise possible with a standard tool of analysis.

BENEFITS To be cost-effective the solution must be highly automated and should require a minimum level of intervention. Runner Warehouse is a fully automated and scheduled solution to ensure an intervention level near to zero.

Datawarehouse consulting in this area, RUN TIME Solutions consulting concerns the prior activities of analysis and design, and the development of management applications with features of "query & reporting." Our offer is therefore open on two fronts: Analysis Activity

• Needs and decision making processes analysis.
• Analysis and definition of the "information cycle" in the company.
• Analysis of the problems of collection, processing and distribution of information.
• Identification of indicators for a conscious and strategic management.

Development and implementation

• Data and architecture modeling.
• Choice of components appropriate for the customer.
• Application of the techniques and methods of information processing.
• Collection, extraction and processing of origin data.
• Prototyping and development of applications.
• Optimization of existing procedures.

RUN TIME Solutions operates in the decision support field from seven years. This experience has enabled us to develop a Decision Ware solution that was born on the field and is continuously enriched by the experience of our professionals. RUN TIME Solutions deals with all elements of the value chain in which the project is decomposable: starting from an analysis of needs and decision making processes, through data modeling and architecture, the choice of components appropriate for the client , the collection, extraction and processing of data origin, until technology and functional project delivery of information to users.