TM1在设计实现销售渠道报表系统的应用  

Implementation of TM1 in Designing Sales Channel Report System

作　　者：林碧英 刘亮 

机构地区：[1]华北电力大学(北京)控制与计算机工程学院,北京102206

出　　处：《计算机系统应用》2012年第3期46-50,共5页Computer Systems & Applications

摘　　要：销售渠道报表在企业应用中十分广泛,这类报表产生时普遍存在数据采集困难、报告格式单一、数据冗余和数据利用效率低等问题。为了解决这些问题,以实际项目为背景,借助IBM Cognos TM1工具设计并部署了一个销售渠道报表系统。重点研究了通过不同的数据采集模板,结合多种数据来源和数据展现设计了一个完整的数据模型,提供了灵活的报表格式以及如何根据不同的条件动态产生报表。经企业实际数据验证,该系统运行稳定,减少了报表制作过程中的人力和物力,充分挖掘了数据本身的潜在信息,大大提高了数据的利用率。Sales channel reports are applied widely in enterprise. There are common problems in generating these reports, such as hard in data acquisition, single on report format, data redundancy, low efficiency on data utilization and so on. To tackle these problems, a sales channel reports system are designed and implemented with IBM Cognos TMI on the background of one real project. Design a whole data model via different data acquisition templates and combining with several kinds of data sources and data visualization are mainly researched, flexible report format and how to generate reports dynamically according to different conditions are provided. Verified by actual data of enterprise, the system is running steadily, reduces manpower and resources in the process of reports production, fully taps the potential of information of data itself, improves the utilization of data greatly.

关 键 词：报表 多维数据集 报表系统 数据源 模板 IBM COGNOS TM1 

分 类 号：TP311.52[自动化与计算机技术—计算机软件与理论]