本文已被:浏览 1690次 下载 3992次
Received:July 08, 2011 Revised:August 19, 2011
Received:July 08, 2011 Revised:August 19, 2011
中文摘要: 销售渠道报表在企业应用中十分广泛,这类报表产生时普遍存在数据采集困难、报告格式单一、数据冗余和数据利用效率低等问题。为了解决这些问题,以实际项目为背景,借助IBM Cognos TM1 工具设计并部署了一个销售渠道报表系统。重点研究了通过不同的数据采集模板,结合多种数据来源和数据展现设计了一个完整的数据模型,提供了灵活的报表格式以及如何根据不同的条件动态产生报表。经企业实际数据验证,该系统运行稳定,减少了报表制作过程中的人力和物力,充分挖掘了数据本身的潜在信息,大大提高了数据的利用率。
Abstract: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 TM1 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.
keywords: report cube report system data source template IBM Cognos TM1
文章编号: 中图分类号: 文献标志码:
基金项目:
引用文本:
林碧英,刘亮.TM1 在设计实现销售渠道报表系统的应用.计算机系统应用,2012,21(3):46-50
LIN Bi-Ying,LIU Liang.Implementation of TM1 in Designing Sales Channel Report System.COMPUTER SYSTEMS APPLICATIONS,2012,21(3):46-50
林碧英,刘亮.TM1 在设计实现销售渠道报表系统的应用.计算机系统应用,2012,21(3):46-50
LIN Bi-Ying,LIU Liang.Implementation of TM1 in Designing Sales Channel Report System.COMPUTER SYSTEMS APPLICATIONS,2012,21(3):46-50