■About Dr. Sum

　　<Features of Dr. Sum>
● Users are free to form views on the information (Vertical, Horizontal, summed values etc.) It allows drill-down without constraints as it is not cube creating system.
●Data can be summed up in larger volumes since multi view makes it virtually possible to connect multiple number of tables in the local server
●Multi server function virtually connects the tables within multiple number of servers to Enterprise to create View in huge volumes. User can handle tallying in large volumes for this virtual View




●Large volumes of data can be tallied at high speed.
●It offers a better real data analysis environment without losing time in data importing from core system.



●It is allowed to build the system and make changes in the system with non-programming.
●It does not require specialized IT knowledge
●Extensive/abundant interface makes company-wide data operation.possible.


■ Services offered by LBC
Collection/ reduction of data
Existing reports are collected and the data obtained from these reports is evaluated and classified to break it down into patterns according to the purpose and vital data items

Interview for analysis needs
Existing data which is broken down into patterns is divided into relevant data and irrelevant data and the data that needs to be added is thoroughly distinguished.

Management related points/Freshness analysis
Analysis of management related points includes defining the management related points (For example, region, client, item no. etc.), management items (Such as sales volume, cost, budget, profit rate etc.) and summing them up in 2 dimensional table for both the parties.


Freshness analysis is to determine [Capture precision] and [Storage freshness]. relevant management items.
[Capture freshness] means exactly when to consider the data the latest.
[Storage freshness] in other words, means data storage period.

Dimension modelling
Data warehouse is the database which is the nucleus of BF system. Data warehouse is created with data base schema which is normally known as star schema. This schema is known as star schema because it is in star shape with a number of tables having the fact table in the middle consisting of the indices and numeric columns and the dimensions table surrounding it which is made up of attribute data.



Study of DWH common layout (Transaction data)
Study is conducted on the layout for transaction data (Such as sales, purchases, stock, production, expenses etc.) which forms the basis of DWH.
There is a need to verify if all types of KPI (ROE (Accounting capital profit rate), RPIC (Invested capital profit rate) etc.) can be fetched from these layouts.



Study on DWH common layout (Master data)
If it pertains to manufacturing business apart from Item Master, Business partner Master, Customer Master, etc., it also includes Components Structure Sheet (BOM).

Study of common code
There is a need to study the global coding system of all types of Master File. Further, it is also required to study how to maintain this coding system. Further, the study of common coding also includes disclosed segment based on [Management Approach].

↑To page top.