IBM Cognos 助力李宁报表展现
IBM Cognos BI 动态查询大数据分析说明书
®Big Data Analytics with IBM Cognos BI Dynamic QueryIBM Redbooks Solution GuideIBM® Cognos® Business Intelligence (BI) helps you make better and smarter business decisions faster. Advanced visualization capabilities bring your data to life, and you can consume your Cognos BI reports, scorecards, and dashboards through Internet browsers and mobile devices or have them sent to your email inbox. With intuitive self-service interfaces, you can explore your data and collaborate over the insights you uncover.The Cognos BI server interprets user gestures and report specifications and translates them intodata-retrieval queries that are tailored to the most popular RDBMS, OLAP, CRM, and ERP sources. The term dynamic query refers to the planning and execution of queries using the Java-based extensible query engine in the Cognos platform. Leading practices, learned over decades of BI software development, were applied to its design.This IBM Redbooks® Solution Guide introduces IBM Cognos Dynamic Query and has an overview of its features, benefits, and architecture. This information is intended for Cognos BI administrators, authors, modelers, and power users who need to understand the business value of the dynamic query layer.Figure 1 illustrates how the Cognos Dynamic Query layer is integrated into the Cognos BI stack.Figure 1. IBM Cognos Dynamic Query integrated into the Cognos BI stackDid you know?Over 2.5 quintillion bytes of data are created daily.●The architects working on the design of the Cognos query engine literally have multiple decades (over ●25 years) of experience in business intelligence.The lessons learned over decades of leading the BI industry culminated in the design of this next●generation query engine.Business valueThe success of your business depends on your ability to analyze information, quickly find the right answers, and make timely responses. To meet this challenge, IBM® Cognos® Business Intelligence provides an enhanced Java-based query execution mode.The heart of the Cognos platform is its service-oriented architecture (SOA). It is built on a true set ofpeer-to-peer services that are interoperable and extensible through standard interfaces and protocols. This feature enables organizations to consume their big data analytics through the Web, mobile devices, or via e-mail right to the user's in-box. A low footprint, highly automated solution that can distribute the content mindful of security however your users want to consume it; whether it be through a browser or mobile device.Table 1 outlines benefits of the dynamic query mode for common business problems organizations are facing today.Table 1. How the dynamic query mode helps your organizationBusiness problem SolutionYour organization has or is moving to Java-based architectures and you require JDBC or Java connectivity to data sources.The dynamic query mode provides expanded data reach to support connectivity to various data sources. New data sources are frequently added.More database vendors exclusively support 64-bit platforms. You want your applications to take advantage of your investment in 64-bit technology.The IBM Cognos Business Intelligence query platform supports 64-bit environments, which provide better memory management and improved scalability and performance.Business users want to quickly find answers when looking at information. The IT organization wants to provide this capability while maintaining the security of the applications.With the dynamic query mode, business users get the correct information quickly without compromising security.In-memory caching stores both the query plan and the query results while maintaining the security permissions for each user.Your organization invested in OLAP and relational technologies and you want to optimize and gain the maximum value from your investment.The dynamic query mode provides optimized access to OLAP data sources. It provides customized and enhanced MDX for the specific source and version of your OLAP technology, and it harnesses the intelligence of the OLAP data source.The dynamic query mode provides SQL generation optimizations for relational data sources.It is a challenge to easily troubleshoot what happens when a query is planned and executed.The dynamic query mode provides detailed logging and query visualization. IBM Cognos Dynamic Query Analyzer enables you to visualize the logs and helps you troubleshoot.Solution overviewIBM Cognos Business Intelligence provides reports, analysis, dashboards, and scorecards to help support the way people think and work when they are trying to understand business performance. You can freely explore information, analyze key facts and quickly collaborate to align decisions with key stakeholders.The Cognos BI server interprets user gestures and report specifications and translates them intodata-retrieval queries that are tailored to the most popular RDBMS, OLAP, CRM, and ERP sources. The term dynamic query refers to the planning and execution of queries using the Java-based extensible query engine in the Cognos platform. Leading practices, learned over decades of BI software development, were applied to its design. Dynamic query retains result sets and metadata captured from optimized queries to data sources in a 64-bit, in-memory cache. It can reuse these result sets and metadata to minimize the wait times for future requests.The dynamic query layer was developed to meet requirements for interactive reporting and ad hoc analysis. It employs sophisticated, multiphase query optimization techniques and can dynamically alternate between SQL and MDX processing, depending on what best suits the scenario. Dynamic query has a number of advantages. Advanced in-memory caching and aggregation can reduce data warehouse workload. Users are provided with a consistent experience, no matter what the data source. In addition, simple cache administration and query visualization tools help reduce total cost of ownership. IT organizations can also take advantage of improved query performance thanks to the reduction in query planning and execution, along with lighter database server workloads.The dynamic query layer refers to the query service of IBM Cognos 10, which is powered by an extensible query engine written in Java. The query layer offers the following key capabilities:Open access to the most popular RDBMS, OLAP, CRM, and ERP data sources●Query optimization techniques to address complex analytical requirements, large and growing data●volumes, and expectations for timelinessEnterprise-level scalability and stability●Intelligent combinations of local and remote processing●Federation of multiple heterogeneous data sources●OLAP functionality for relational data sources when using a dimensionally modeled relational (DMR) ●package or Cognos Dynamic CubesSecurity-aware caching●64-bit processing●JDBC connectivity to relational data sources●Query visualizations for ease of maintenance●New projects in IBM Cognos Business Intelligence version 10.2.1 and later are set to dynamic query mode, which is powered by an eXtensible Query Engine (XQE) written in Java. XQE, the engine behind the Cognos BI query service, embraces the principles of abstraction and extensibility, allowing it to evolve into a more efficient query planner, processor, and executor with every new version of IBM Cognos BI.Solution architectureFigure 2 shows the internal architecture of the query service, which consists of the following major components:Transformation engine and transformation libraries●Query execution engine●Metadata cache●Data cache●RDBMS and OLAP adapters●Figure 2. Internal architecture of the query serviceThe transformation engine does not implement any query planning logic by itself. Instead, it provides an execution environment for query transformations in the transformation libraries, thus separating planning logic from the engine. The transformations implement query planning logic for all supported query types and functionality. When there are no more transformations to be applied, query planning is complete and the transformation engine passes the resulting run tree to the query execution engine.The query execution engine can execute any query request, independent of the type of query and target data source. The engine represents all query results in memory in a single format that encompasses both dimensional style (with axes, dimensions, and cells) and relational style (with a tabular format of rows and columns). This allows the engine to combine SQL and MDX queries in a single run tree, thus enabling simplicity of representation, flexibility in post-processing, and streamlined query performance. To process the two types of queries, the query execution engine contains both SQL and MDX engines.The SQL engine obtains data directly from the RDBMS adapter. The query execution engine updates the secure data cache with dimensional data for future reuse. The MDX engine obtains dimensional data either directly from the OLAP adapters or from the data cache. It also updates and reuses dimensional metadata in the secure member cache. The cache security features ensure that, by default, no sharing of secured data ever occurs between users with different security profiles.The RDBMS and OLAP adapters translate IBM Cognos SQL and MDX queries to a query dialect suitable and optimized for each data provider. The adapters send the query and fetch results through the provider’s proprietary interface or a supported standard interface such as JDBC. There is only one RDBMS adapter, which uses a JDBC interface, because all supported relational providers are accessible through JDBC. The RDBMS adapter supplies data to the SQL engine in the query execution engine; the OLAP adapters supply data to the MDX engine.Usage scenariosIBM Cognos offers several query technologies to address your analytical needs. This section provides guidance that will lead you to the best solution for your requirements.Table 2 summarizes the guidance regarding when to employ pure relational, IBM Cognos TM1®, Cognos Dynamic Cubes, or DMR analytics for different application objectives.Table 2. Summary of analytic technology selection guidanceApplication objective Preferred technologyReporting on leaf-level recordsPure relational●Static reports (no user requirements for●navigating through business hierarchies)Simple list reports●IBM Cognos TM1Users writing back to the same data source●being analyzedWhat-if analysis●Volatile data due to planning and budgeting●applicationsIBM Cognos Dynamic CubesSelf-service interactive analysis●High performance on large and growing data●volumesData warehouse structured in star or snowflake●schemaDimensionally modeled relational (DMR) Interactive analysis on operational or●transactional databaseTight control over caching●Tight control over security●IntegrationIBM Cognos Dynamic Query is tightly integrated into the Cognos Business Intelligence stack, and its data can be surfaced through any of the Cognos interfaces. With this method, existing customers can integrate this technology into their application environment without affecting existing users. Such users are already familiar with interfaces such as Report Studio, Business Workspace, and Business Workspace Advanced (previously named Business Insight and Business Insight Advanced).The query service accepts data and metadata requests (through the report service component) from authoring interfaces such as IBM Cognos Report Studio, IBM Cognos Report Viewer, and other clients. It returns the requested data or messages in a structured response to the report service component that formats the result for the client. Figure 3 presents the workflow of requests and responses between these components.Figure 3. Query service request and response workflowSupported platformsFor information about software environments that are supported in IBM Cognos Business IntelligenceV10.2.1, see the IBM Cognos Business Intelligence 10.2.1 Supported Software Environments web page: /support/docview.wss?uid=swg27037784Ordering informationOrdering information is listed in Table 3.Table 3. Ordering program numbers and program namesProgram number Program name5724-W12IBM Cognos Business Intelligence V10.2.15724-W68IBM Cognos Business Intelligence PowerPlay® V10.2.05724-W19IBM Cognos Business Intelligence Reporting V10.2.05724-W13IBM Cognos Data Manager V10.2.05724-W20IBM Cognos Mobile V10.1.0Related informationFor more information, see the following documents:IBM Cognos Dynamic Query, SG24-8121●/abstracts/sg248121.htmlIBM Cognos Dynamic Cubes, SG24-8064-00●/abstracts/sg248064.htmlBig Data Analytics with IBM Cognos Dynamic Cubes, TIPS0942●/abstracts/tips0942.html?OpenIBM Cognos Business Intelligence V10.1 Handbook, SG24-7912●/abstracts/sg247912.html?OpenIBM Cognos Business Intelligence V10.1: Intelligence Unleashed, REDP-4693●/abstracts/redp4693.html?OpenCognos Business Intelligence 10.2.1 documentation●/support/docview.wss?uid=swg27037021IBM Cognos Business Intelligence 10.2.1 information center●/infocenter/cbi/v10r2m1/index.jspCognos software product page●/software/analytics/cognos/IBM Offering Information page (announcement letters and sales manuals)●/common/ssi/index.wss?request_locale=enOn this page, enter IBM Cognos Business Intelligence, select theinformation type, and then click Search. On the next page, narrow your search results by geography and language.NoticesThis information was developed for products and services offered in the U.S.A.IBM may not offer the products, services, or features discussed in this document in other countries. Consult your local IBM representative for information on the products and services currently available in your area. Any reference to an IBM product, program, or service is not intended to state or imply that only that IBM product, program, or service may be used. Any functionally equivalent product, program, or service that does not infringe any IBM intellectual property right may be used instead. However, it is the user's responsibility to evaluate and verify the operation of any non-IBM product, program, or service. IBM may have patents or pending patent applications covering subject matter described in this document. The furnishing of this document does not give you any license to these patents. You can send license inquiries, in writing, to:IBM Director of Licensing, IBM Corporation, North Castle Drive, Armonk, NY 10504-1785 U.S.A.The following paragraph does not apply to the United Kingdom or any other country where such provisions are inconsistent with local law: INTERNATIONAL BUSINESS MACHINES CORPORATION PROVIDES THIS PUBLICATION "AS IS" WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESS OR IMPLIED, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF NON-INFRINGEMENT, MERCHANTABILITY OR FITNESS FOR A PARTICULAR PURPOSE. Some states do not allow disclaimer of express or implied warranties in certain transactions, therefore, this statement may not apply to you. This information could include technical inaccuracies or typographical errors. Changes are periodically made to the information herein; these changes will be incorporated in new editions of the publication. IBM may make improvements and/or changes in the product(s) and/or the program(s) described in this publication at any time without notice.Any references in this information to non-IBM Web sites are provided for convenience only and do not in any manner serve as an endorsement of those Web sites. The materials at those Web sites are not part of the materials for this IBM product and use of those Web sites is at your own risk.IBM may use or distribute any of the information you supply in any way it believes appropriate without incurring any obligation to you. Information concerning non-IBM products was obtained from the suppliers of those products, their published announcements or other publicly available sources. IBM has not tested those products and cannot confirm the accuracy of performance, compatibility or any other claims related to non-IBM products. Questions on the capabilities of non-IBM products should be addressed to the suppliers of those products. This information contains examples of data and reports used in daily business operations. To illustrate them as completely as possible, the examples include the names of individuals, companies, brands, and products. All of these names are fictitious and any similarity to the names and addresses used by an actual business enterprise is entirely coincidental.Any performance data contained herein was determined in a controlled environment. Therefore, the results obtained in other operating environments may vary significantly. Some measurements may have been made on development-level systems and there is no guarantee that these measurements will be the same on generally available systems. Furthermore, some measurement may have been estimated through extrapolation. Actual results may vary. Users of this document should verify the applicable data for their specific environment.COPYRIGHT LICENSE:This information contains sample application programs in source language, which illustrate programming techniques on various operating platforms. You may copy, modify, and distribute these sample programs in any form without payment to IBM, for the purposes of developing, using, marketing or distributing application programs conforming to the application programming interface for the operating platform for which the sample programs are written. These examples have not been thoroughly tested under all conditions. IBM, therefore, cannot guarantee or imply reliability, serviceability, or function of these programs.© Copyright International Business Machines Corporation 2013. All rights reserved.Note to U.S. Government Users Restricted Rights -- Use, duplication or disclosure restricted byGSA ADP Schedule Contract with IBM Corp.This document was created or updated on September 11, 2013.Send us your comments in one of the following ways:Use the online Contact us review form found at:●/redbooksSend your comments in an e-mail to:●**************.comMail your comments to:●IBM Corporation, International Technical Support OrganizationDept. HYTD Mail Station P0992455 South RoadPoughkeepsie, NY 12601-5400 U.S.A.This document is available online at /redbooks/abstracts/tips1057.html . TrademarksIBM, the IBM logo, and are trademarks or registered trademarks of International Business Machines Corporation in the United States, other countries, or both. These and other IBM trademarked terms are marked on their first occurrence in this information with the appropriate symbol (® or ™), indicating US registered or common law trademarks owned by IBM at the time this information was published. Such trademarks may also be registered or common law trademarks in other countries. A current list of IBM trademarks is available on the Web at /legal/copytrade.shtmlThe following terms are trademarks of the International Business Machines Corporation in the United States, other countries, or both:Cognos®IBM®PowerPlay®Redbooks (logo)®TM1®The following terms are trademarks of other companies:Java, and all Java-based trademarks and logos are trademarks or registered trademarks of Oracle and/or its affiliates.Other company, product, or service names may be trademarks or service marks of others.。
IBM Cognos 商业智能软件整体简介.ppt
Cognos BI 软件具有三大特点：
简单 –为平民化的商业智能软件，又是一个易用 的报表系统。它可以让不懂计算机的业务人员定 制自己需要的业务报表而无需程序开发。
完整 – 能够在单一的、已证的体系结构上提供所 有BI功能的BI产品。
扩展性强 – Cognos 支持主流的 UNIX 和 Windows，在各个平台上的功能没有任何区别。 Cognos 的数据探查,分析,报表功能不依赖于任何 第三方的支持，都能提供同样强大的功能和出色 的表现。
Cognos, 隶属于 IBM公司是业务智能 (BI) 和绩效管理解决方案的全球 领导者。我们提供世界一流的企业BI、计划和合并软件和服务，可以 帮助企业计划、了解和管理财务和业务绩效。
IBM Cognos是公认的商业智能和绩效管理解决方案的行业领袖和最 大供应商之一，在全世界拥有超过25,000名客户和3,000多个合作伙 伴和经销商。收购前员工数量达到4000多人。
更广泛的专家技术
独一无二地合成了行业、功能和技术技巧 可以接触到全世界的大量BI & PM 从业人员，他们能够提供顶尖的思想和最佳实
践
பைடு நூலகம்
IBM Cognos 会给您创造以下巨大 的价值：
更加简单
可释放信息的商业价值的集成解决方案 更少的管理和更快的部署 增强的全球单点登录支持
无与伦比的开放性和灵活性
支持开放式标准 能够继续利用异构信息系统的灵活性 能够交付对多个应用程序和流程的洞察力
极佳的可扩展性和增长能力
满足最大范围的需求和用户社区的能力 高度可扩展的信息管理、BI和绩效管理平台，经过基准测试的检验
2008年，IBM 中国公司将秉承“成就客户、创新为要、诚信负责”的 核心价值观，在全球化的视野和布局下，努力成为中国客户的创新伙 伴，为中国建设“创新型国家”尽一份心力。
Cognos报表制作实例
1.打开impromptu administrator.2.选择菜单Catalo－>open打开数据库连接文件.文件路径为：E:\CSMS-RS-Cognos-Cubes。
选择RSTT.cat。
3.输入数据库连接user/password.4.选择菜单Catalo－>table.导入所需的表单。
5.选择菜单File－>new.新建Simple List.６．将Catalog Data中选择所需表的字段加入到Query data中。
7.保存IMR文件到指定路径，文件路径为：E:\CSMS-RS-Cognos-Cubes8.另存为IQD文件。
文件路径与IMR文件相同。
９．打开PowerPlay Transfomer.10.选择菜单File－>new.新建Model.新建Model name,next11.输入Data source name。
Data source type：Impromptu Query Definition.Next.12.选择IQD文件。
Next.13.选择Finish.输入user/password.14.选择log on打开编辑界面。
打开New Data source窗口。
输入Source table name,选择IQD文件,导入Source data table。
修改Source table 字段。
选择菜单View －>data source viewer.打开SQL 窗口。
Modify，修改Source table SQL.选择OKtable 修改完毕。
入Dimension Map中。
对应时间类型的Dimention，要打开Dimention属性，修改Dimention type:time.可按照需求修改Dimention name等其它属性。
修改Dimention下的各Level的属性，如level Name,Label,Order By等属性。
2024版Cognos BI 10教程：第一张复杂报表
03
社交媒体共享
集成社交媒体分享按钮，方便用户将报表分享到社交媒体平台。
01
生成报表链接
在Cognos BI 10中生成报表的URL链接，方便用户直接通过链接访问报表。
02
嵌入代码
提供嵌入代码功能，允许用户将报表嵌入到自己的Web页面或应用程序中。
共享报表链接或嵌入代码
报表访问统计
记录报表的访问次数、访问时间等信息，以便了解报表的使用情况。
04
如果遇到连接失败的情况，可以检查网络连通性、认证信息正确性等方面的问题，并查看系统日志获取更多错误信息。
04
CHAPTER
复杂报表制作步骤详解
打开Cognos BI 10，创建一个新的报表。
将图表对象拖拽到报表设计区域，并调整其大小和位置。
在工具栏中选择合适的图表类型，例如柱状图、折线图、饼图等。
复制/粘贴
02
01
03
04
05
常用工具栏操作演示
03
CHAPTER
数据源连接与配置
打开Cognos BI 10，点击“数据源”图标，选择“新建数据源连接”。
填写数据源连接的基本信息，如数据源名称、描述、服务器地址、端口号等。
创建新的数据源连接
在弹出的对话框中选择合适的数据源类型（如关系型数据库、多维数据集等）。
系统会尝试连接到指定的数据源，并显示连接结果。
如果连接成功，则说明数据源配置正确；如果连接失败，则需要检查配置信息并重试。
测试数据源连接成功性
注意事项及常见问题解答
01
确保在创建数据源连接时填写正确的服务器地址、端口号、认证信息等。
02
根据实际情况选择合适的数据源类型和相应的驱动程序。
Cognos图表报表制作参考手册教学文案
Cognos报表制作参考手册1.打开浏览器，在地址栏输入http://localhost:9300/p2pd/servlet/dispatch后回车进入Cognos Portal：可以在界面上看到，在“公共文件夹”里出现了我们刚才发布的立方体“cube_ETL_DEMO”。
2.点击右上角的“启动”，然后在下拉菜单中选择“Report Studio”：一般情况下，“Business Insight”及“Business Insight Advanced”都是专门用来制作图表报表的；而“Query Studio”则是用来进行简单的数据查询并显示报表；“Analysis Studio”则会被用来查看数据立方体内的数据内容；“Report Studio”则是一个功能强大的报表制作工具，本示例就是利用它来制作一个离线的报表；“Event Studio”则是用来设计报表的调用及监控报表运行完成情况。
3.在弹出窗口中选择我们刚才发布的数据立方体作为该报表的数据源：4.点击“新建”：5.选择“空白”然后点击“确定”：6.系统会读取数据立方体的数据，读取完成数据后，在窗口的左上解可以看到所有立方体内的维度及度量数据都显示出来了：7.为了方便报表界面布局，先在报表上放置一个3X3的表格组件：8.将一个“文本”对象拖放到表格中：并在弹出的窗口中输入以下文字后点击“确定”：再点击按钮将文件居中显示。
9.将一图表对象拖放到表格中：在弹出的窗口中选择“折线图”后点击“确定”：再点击按钮将图表居中显示。
10.按下图进行图表X轴数据设置：11.按下图进行系列的设置：12.按下图进行图表Y轴的设置：13.利用鼠标单击选中该对象，然后修改该对象的“自定义标签”属性值为“显示”：14.双击，在弹出的对话框中输入“水位(cm)”：15.利用相同方法，将图表中X轴及系列中的标签修改如下图所示：16.修改报表标题字体：17.选中该图表，然后修改其“标题”属性为“显示”：18.将该标题文字修改如下：19.利用相同方法，将另一图表拖放到报表中，并将“默认度量”值设置为“RAINFALL”度量值，标题修改为“各监测站降雨量趋势”，最终结果如下图所示：20.接下来设置图表的钻取，如下图所示：21.报表完成，最终效果如下图所示：。
cognos报表开发教程
自定义颜色和字体
通过自定义颜色和字体，可以让报表更加符 合企业形象和用户喜好。
利用图表动画效果
适当添加图表动画效果，可以让数据展示更 加生动和有趣。
04 数据处理与计算
数据筛选、排序和分组操作
数据筛选
使用Cognos的查询功能，通过设置筛选条件，从数据源中选取需要的数据。支持简单的条件筛选，如等于 、不等于、大于、小于等，也支持复杂的组合条件筛选。
问题2
如何提高报表性能？
解答
通过优化数据源连接、减少数据冗余、使用缓存等方法 提高报表性能。
经验分享
在开发过程中，注意避免不必要的复杂计算和大量数据 传输，合理利用Cognos提供的性能优化功能。
拓展学习资源推荐
Cognos官方文档
深入学习Cognos产品的使用方法和最佳实践。
在线教程和视频课程
观看专业讲师的在线教程和视频课程，系统学习Cognos报表开发技能。
数据汇总
Cognos提供丰富的汇总函数，如 求和、计数、最大值、最小值等 ，用于对数据进行汇总分析。可 以在报表设计时指定汇总方式和 汇总字段，也可以在运行时由用 户动态选择。
平均值计算
使用Cognos的平均值函数，可以 轻松地计算指定字段的平均值。 同时，还支持计算加权平均值和 其他复杂的平均值计算方式。
图表联动效果实现方法论述
销售数据与库存数据的联动分析
当用户选择某个销售数据时，联动图表将展示与该销售数据相关的库存数据，以便用户更好地了解销售与库存之 间的关系。
不同区域销售数据的比较分析
用户可以选择不同区域，主图表将展示各区域的销售数据，而联动图表则展示各区域销售数据的占比情况。
cognos查询与报表和多维分析工具
COGNOS查询与报表和多维分析工具国家信息中心北京优信佳信息系统有限公司查询与报表工具 2标准报表 2 即席报表 3 I MPROMPTU信息目录 4 部署伸缩性 4 I MPROMPTU W EB Q UERY 5多维分析工具——POWERPLAY 5数据探察 6 特殊性报告的排序7 快速、高效的信息提取7是业界领先的商务智能工具供应商，其最主COGNOS要的产品是查询与报表工具Imprompwu和多维分析工具PowerPlay。
本文简要介绍这两种产品。
查询与报表工具Impromptu是企业级交互式数据库查询与报表生成系统，由于它不仅可以分发给任意Impromptu用户，而且由于Impromptu支持Web 功能，报表也可以在组织机构内任意一台桌面发布和浏览。
对于IS 来说，Impromptu的面向对象的体系结构确保了在所有用户和所有报表之间的控制和管理一致性。
标准报表基于预定义规则和常规报表是最为普通的报表活动——Impromptu以比其他任何报表工具更迅速和更省力的方式为整个企业创建大量标准报表。
对那些阅览标准报表的人们来说，Impromptu灵活性意味着报表内容可以轻易地加以提炼以适合个人所需。
通过简单的点击工具条，用户可以容易地对信息进行分组、排序和过滤。
选取表和提示符以及异常报表也增加了分布式标准报表的价值。
选取表和提示符使用户具有在报表中选择特定查看项目的灵活性。
当汇总一份Impromptu报表时，报表作者可以创建一些项值称为“选取表（picklists）”，用户可以单击鼠标从表中选择一个项值，对于包含众多项值的报表，Impromptu给出提示符，以允许用户指定他们想看的项值或项值范围。
行列选取表进一步缩小了用户在报表中选取信息的范围。
Impromptu给经理们提供了三种处理异常数据（落入指定值域外的数据）的选择方案：★条件过滤器、仅提取落在特定限值之外的项值，用户可以指定他们特定的项值，也可以从一预定义的表列中选取。
cognos开发帮助手册
目录第一章创建报表 (2)1.1 指定数据包 (2)1.2 选择基本报表布局 (2)1.3 添加数据 (2)1.4 验证报表 (2)1.5 保存报表 (2)1.6 运行报表 (2)第二章列表 (3)第三章图表 (3)第四章交叉表 (3)第五章地图 (3)第六章活动报表 (3)第七章追溯访问 (3)第一章创建报表创建报表时，实际上是在创建报表规范。
报表规范定义用于检索数据的查询和提示，以及用于数据的布局和样式。
1.1指定数据包指定将为报表提供项目的数据包。
用于生成报表的数据包基于建模工具ibm cognos framework manager中创建的模型。
模型是一组相关对象。
1.1.1开始1.1.2运行1.1.3结果1.2选择基本报表布局1.3添加数据1.4验证报表1.5保存报表1.6运行报表第二章列表2.1创建列表列表可以显示数据库中的明细信息。
列表以行列显示信息每列均用来显示数据库中的一个数据项。
列表还能显示出该列数据的汇总信息。
当需求使用列表时，点击工具栏在工具栏中拖拽列表到指定位置。
效果如图2.2编辑列表2.2.1向列表中插入值从数据来源拖拽数据至列表中，数据会在列表中按插入顺序排列。
也可以直接多选多个数据项。
效果如图效果图：2.2.2修订列表样式列表插入之后我们按照项目的要求需要对列表进行修改以达到预期效果。
1.位置的修订当我们想把列表放在固定的位置无法直接修改，需要在插入列表之前在报表中扎入布局或表格，再将列表拖进指定位置。
2.面积的的修订当项目有要求是我们将对列表进行大小的修改。
首先用鼠标点击图标以选中列表，再在属性中的定位中选择”大小和溢出”在弹出框中进行编辑,效果如图3.边框得设定选中列表在属性的边框中对列表进行编辑4．隐藏列表的列当我们想要隐藏某个列在运行报表时不显示该列。
首先选中需要隐藏的列，单击属性栏标题上的“选择父项”选择列表的单个列，然后在列可见性出进行编辑，选择隐藏。
Cognos_10_介绍
Conditional item in legend
IBM Cognos Mobile: Serving Business Intelligence on the Hip
iPhone Blackberry, Symbian, and Win Mobile
• 增强的用户界面: – 不同设备和应用，相同的风
IBM COGNOS 10: INTELLIGENCE UNLEASHED
6
Cognos 10 redefines traditional BI
适应不断变化的员工需求
– 每个人都可以使用一个BI工作台进行分析 – 提升个人技能去解答关键业务问题
提升团队决策能力
– 集体智慧，内置协作和社会网络 – 连接人和业务洞察力，取得一致见解
协作:
添加注释和注解给报表 导出内容与他人分享 协助平台 集成 Lotus Connections
IBM Cognos Business Insight Advanced
What is Business Insight Advanced?
为业务用户提供新的即席查询和分析界面 提供了一致，简化，丰富的界面为自助报表和分析
Insight集成
–审计流程, 提交确认,任务的所有权和状态信息都可追踪
© 2010 IBM Corporation
Enhanced Event Management
察看任务规则、审批、提醒---My Inbox
My Inbox的内容可以显示在 Business Insight 窗口
Business Analytics
格和功能:
3
• 加强操作交互 --- 钻取、提示、
导航
• 新的Web App更好地支持 iPhone • •
利用CognosReportStudio建立复杂企业报表
利用CognosReportStudio建立复杂企业报表简介：本文首先介绍了 Cognos Report Studio 的基本内容，然后利用一个项目管理复杂报表的实例介绍了 Report Studio 建立报表的步骤，同时实例中介绍了如何利用地图管理器来自定义地图文件继而利用该文件生成地图报表。
公布日期： 2010 年11 月25 日级别：初级前言Cognos 是面向企业的业务智能与绩效计划软件的全球领导者。
企业的解决方案能够通过实现计划与预算、绩效度量与监视、报表与分析等管理环节的关键步骤来提高调整企业绩效，而 Cognos 是唯一能够在一个完整的解决方案中为这些重要的管理活动提供支持的软件。
Cognos 解决方案通过与财务预算、规划与财务报表工具的整合，提供了企业报表、财务分析与记分卡工具。
Cognos 产品包含：Cognos8 BI、Cognos TM1、Cognos8 Go ！、Cognos8 计划、Cognos Now、Cognos8 Controller 及 Cognos8 劳动力绩效软件。
Cognos BI 提供了报表、分析、记分卡、仪表盘及事件管理等方面的内容。
Cognos BI 具有三层架构：Web 服务层、应用层与数据层，各层间有网络防火墙进行分割。
如图 1：图 1.Cognos 框架结构图从结构图中能够看出，在三层架构的基础上为用户接口层，其分为基于 Web 与基于 Windows 的两种接口形式。
Cognos BI 具有基于 Windows 的五种组件：FrameWork Manager、Metric Designer、Transformer、Map Manager 及 Cognos8 Go Office! 与基于 Web 的七种用户组件接口，分别为：Cognos Connection、Cognos Administration、Query Studio、Report Studio、Analysis Studio、Event Studio 与 Metric Studio。
- 1、下载文档前请自行甄别文档内容的完整性，平台不提供额外的编辑、内容补充、找答案等附加服务。
- 2、"仅部分预览"的文档,不可在线预览部分如存在完整性等问题,可反馈申请退款(可完整预览的文档不适用该条件!)。
- 3、如文档侵犯您的权益，请联系客服反馈,我们会尽快为您处理(人工客服工作时间：9:00-18:30)。
1 / 2
智慧的分析洞察
ibm.com/bao/cn
IBM BA软件助力李宁数据整合及报表展现
[摘要]
李宁，这家由中国体操世界冠军创建的品牌，已经成为中国运动品牌当之无愧的领导者。1990
年，李宁有限公司在广东三水起步，经过二十年的发展，已逐步成为了代表中国的、具有东方元
素的、国际领先的运动品牌公司。李宁有限公司创立之初即与中国奥委会携手合作，透过体育用
品事业推动中国体育发展，并不遗余力赞助各种赛事。1995年，李宁公司成为中国体育用品行
业的领跑者。2005年，李宁公司继续保持行业领先地位，销售额创下历史新高，向着国际一流
品牌的目标冲刺。
业务挑战
数据中心建设伊始，李宁公司共规划出200-300张决策类型的报表。由于种类过于繁杂、维度过
多，反而没有达到预想的效果。2007年，李宁重新定义了维度、指标、体系，将报表数量缩减
至不足100张。但同时新的问题又出现了: 报表系统的效率很低，生成一张报表需要5分钟甚至
更长的时间，用户无法使用。
在总结这一阶段经验的时候，李宁集团信息技术系统总监沙爽谈道: “我们前面的建设一直在关
注业务逻辑、维度、指标的统一和业务应用的体系建设，解决了企业内部关于数据应用、信息应
用的多方面报表分析问题，针对所有遇到的分析需求就用相应的工具来实现，但忽略了数据中心
系统架构上的体系化建设。这导致数据中心各方面工具繁多，没有形成整体的系统技术体系，系
统技术框架不能满足高速发展的要求。”
应对策略
李宁有限公司借鉴了IBM的整体应用工具体系建议和Cognos的商业智能标准，从服务器平台、
应用平台、工具平台、数据管理，即底层的数据仓库、数据建模的尺寸等方面入手，进行整体规
划，建立了由负责收集一线数据的POS系统、进行数据ETL的数据中心和报表展现的Cognos
三层架构组成的李宁“旗舰店POS分析系统”。系统分为门店分析、产品分析、顾客分析三大
部分，为公司的产品、销售、市场部门人员提供详尽的POS数据分析报告。
在报表展现层，系统应用了Cognos FrameworkManager、Cognos Transformer、Cognos
2 / 2
Report Studio、QueryStudio、Analysis Studio、Event Studio等，从建模、数据抽取、报表展
现、数据分析到事件管理等方面一应俱全，生成的报表为各部门源源不断地提供着及时准确的决
策信息。为了满足不同用户的差异化需求，数据中心还基于门户(Portal)将不同系统的数据整合
起来，例如李宁CEO能够看到的报表包括销售的仪表盘、执行率仪表盘等等，而大区经理看到
的更多是流水、库存、库销比等等。为了保证数据的统一、准确，李宁选择了InfoSphere
Information Server来收集分别存在于ERP和POS系统等多个不同系统中的数据，从而提炼IT
资产。
（此文档省略部分内容，可登录IBM官方网站立即前往IBM官网了解全部内容）
成效
李宁的“旗舰店POS分析系统”整合了数据中心的底层架构，支持了公司内部近100种报表的
数据收集和呈现，为公司的产品、销售、市场等各部门人员提供详尽的数据分析报告，辅助了决
策、提升了整体效率，报表生成的时间也降低到15秒甚至更少。目前，在李宁公司内部约有
150人左右在使用这一系统，其中就包括李宁的CEO，他也是最经常使用这一系统的用户之
一。此外，在李宁TOP10的经销商中有7家使用的是李宁公司的报表。目前，“旗舰店POS
系统”已经覆盖了李宁全国8000多家店中的将近6000家，今年，李宁计划实现全部覆盖的目
标。
关于IBM Cognos BI和绩效管理
IBM Cognos商业智能(BI)和绩效管理解决方案提供了世界领先的企业规划、合并和BI软件、支
持和服务，帮助公司规划、理解和管理财务和运营绩效。IBM Cognos解决方案整合了技术、分
析应用、最佳实践和广泛的合作伙伴网络，给客户一个开放的、适应性的、完整的绩效解决方
案。世界各地超过135个国家的23,000多名客户选择了IBM Cognos解决方案。
智慧的分析洞察相关内容：
IBM 智慧的分析洞察-美味的数据
BAO帮公开赛处理数据