Related links:
Title
|
Type
|
Date
|
|---|---|---|
| Policy monitoring reports security setup with InfoSphere Master Data
Management and Tivoli Directory Server
The Policy Monitoring component is introduced in IBM's InfoSphere
Master Data Management (MDM) v10.1 release. Using IBM Cognos Business Intelligence reporting tools, Policy
Monitoring enables organizations to report on data quality by using aggregated metrics
and to establish policies for compliance with data quality thresholds. This tutorial
provides detailed steps to set up a basic security model in IBM Cognos Business
Intelligence for providing authentication and authorization for Policy
Monitoring reports.
Also available in:
Portuguese
|
Tutorial | 29 Nov 2012 |
| Solving Operational Business Intelligence with InfoSphere Warehouse Advanced Edition
In this IBM Redbooks publication we explain how you can build a business intelligence system with InfoSphere Warehouse Advanced Enterprise to manage and support daily business operations for an enterprise, to generate more income with lower cost. We describe the foundation of the business analytics, the Data Warehouse features and functions, and the solutions that can deliver immediate analytics solutions and help you drive better business outcomes.
We show you how to use the advanced analytics of InfoSphere Warehouse Advanced Enterprise Edition and integrated tools for data modeling, mining, text analytics, and identifying and meeting the data latency requirements. We describe how the performance and storage optimization features can make building and managing a large data warehouse more affordable, and how they can help significantly reduce the cost of ownership. We also cover data lifecycle management and the key features of IBM Cognos Business Intelligence.
|
Redbooks | 08 Oct 2012 |
| Virtualized Business Intelligence with InfoSphere Warehouse
This IBM Redbooks publication discusses the deployment of a BI cloud solution. It includes details such as understanding the architecture of a cloud, planning implementation, integrating various software components, and understanding the preferred practices of running a cloud deployment. Essentially, this book can be used as a guide by anyone who is interested in deploying a virtualized environment for a BI cloud solution.
|
Redbooks | 08 Oct 2012 |
| Enabling Smarter Government with Analytics to Streamline Social Services
In this IBM Redbooks publication we describe a centralized reporting and alerting system for governmental social service organizations. We include information about how to integrate key IBM building blocks to bring social services data sources together into an effective structure that allows for reporting on key metrics required by higher levels of government to help secure funding for reporting on the effectiveness of the various social service programs, and to give case workers and care providers quick and easy access to all the services ever provided to a person and their family, which can aid in the reduction of duplicate persons, and therefore, payments, in addition to reducing fraud and abuse of social services funds.
|
Redbooks | 08 Oct 2012 |
| Online roll-out with table partitioning in InfoSphere Warehouse
Starting with DB2 9.7.1, the table partitioning feature is enhanced with
support for online roll-out using detach. With online roll-out, queries
continue to access the partitioned table while one or more partitions of the
table are being detached using the ALTER TABLE DETACH PARTITION command. This
article discusses how online detach improves the availability of the warehouse
and describes some best practices to leverage and monitor the new behavior. A
stored procedure is provided to help database administrators to script the
post-detach processing on the target table, that is, the new table created as
a result of the detach operation. The article also demonstrates how the same
procedure can be used to simulate synchronous detach behavior in certain
application scenarios. We conclude with frequently asked questions related to
detach.
Also available in:
Chinese
|
Articles | 27 Oct 2011 |
| Introduction to Business Analytics and Optimization
The combination of an increasingly complex world, the vast proliferation of
data, and the pressing need to stay one step ahead of the competition has
sharpened focus on using analytics within organizations. Students, partners, and
IT professionals can learn how to use Business Analytics software to streamline
and maximize data delivery, and help create a smarter planet.
Also available in:
Portuguese
|
Knowledge paths | 07 Oct 2011 |
| Configure and monitor InfoSphere Warehouse with Optim Performance Manager
Extended Insight
Optim Performance Manager Extended Edition provides end-to-end database transaction response time
monitoring capability for InfoSphere Warehouse applications with its Extended Insight capability. This
capability gives you insight into the transaction and SQL statement response time metrics of a database
application throughout all layers of the software stack; from the time that the SQL is issued in the application, and through
the network and database server. Special support is available for InfoSphere
Warehouse SQL Warehousing Tool (SQW)
applications by recognizing transactions and SQL statements from InfoSphere Warehouse Application Server
automatically. This article provides detailed information for installing, configuring, and validating
the Optim Performance Manager Extended Insight feature for InfoSphere Warehouse applications.
|
Articles | 25 Aug 2011 |
| Modeling trains with SPSS
The ability to predict a failure before it happens is tremendously valuable. Learn how an IBM team worked with a train manufacturer to develop this capability using IBM SPSS Modeler and IBM DB2. In this instance, the team used SPSS to identify patterns in data and DB2 to handle moderately complex mathematical calculations directly within SQL.
Also available in:
Chinese
|
Articles | 27 Jul 2011 |
| IBM Smart Analytics System
This IBM Redbooks publication introduces the architecture and components of the IBM Smart Analytics System family. We describe the installation and configuration of the IBM Smart Analytics System and show how to manage the systems effectively to deliver an enterprise class service. This book explains the importance of integrating the IBM Smart Analytics System with the existing IT environment, as well as how to leverage investments in security, monitoring, and backup infrastructure. We discuss the monitoring tools for both operating systems and DB2. Advance configuration, performance troubleshooting, and tuning techniques are also discussed.
|
Redbooks | 07 Mar 2011 |
| New world, new work: Data governance and the DBA
See how data governance tools and policies are redefining the role of DBAs in the healthcare and insurance industries.
Also available in:
Chinese
|
Articles | 14 Feb 2011 |
| Tracking IBM Cognos Express Client downloads
This document provides you with installation instructions and a general overview to enable you to track IBM Cognos Express Client downloads from within IBM Cognos Express Reporter.
|
Articles | 26 Jan 2011 |
| Efficient multidimensional data modeling with InfoSphere Data
Architect
Learn how InfoSphere Data Architect is efficiently used in
multidimensional data modeling.
|
Demos | 19 Nov 2010 |
| The Beginning of the Next Decade of IBM Informix
The story behind Informix 11.7, the new possibilities it brings, and what it will mean in the years to come.
Also available in:
Chinese
|
Articles | 03 Nov 2010 |
| SAP Cookbook For IBM Cognos 8 BI
This document is intended to provide a single point of reference for techniques and product behaviours when dealing with SAP BW and SAP ECC as data sources in IBM Cognos 8 BI. UPDATED
|
Articles | 13 Oct 2010 |
| Data Manager: Exploring Blue Insight: You catch more flies with honey
Merv Adrian offers five lessons learned from a massive business intelligence consolidation project at IBM.
Also available in:
Chinese
|
Articles | 10 Oct 2010 |
| Development Notebook: The evolution of the IBM Smart Analytics System
Two key IBM developers discuss the history and background of the IBM Smart Analytics System.
Also available in:
Chinese
|
Articles | 10 Oct 2010 |
| Data Architect: You want to govern what?
Robert Catterall is a database guy, and he needs to be convinced of the need for data governance. With help from Steven Adler, director of Information Governance Solutions at IBM, he explores the tenets of data governance and discusses how it can help database teams.
Also available in:
Chinese
|
Articles | 30 Jul 2010 |
| IBM Cognos 8 SDK Application To Merge Reports
A IBM Cognos 8 SDK application that merges reports created against the same package.
|
Articles | 21 Jun 2010 |
| InfoSphere Warehouse: A Robust Infrastructure for Business Intelligence
The InfoSphere Warehouse platform provides a fully integrated environment built around IBM DB2® 9.7 server technology on Linux®, UNIX® and Microsoft® Windows® platforms, as well as System z®. Common user interfaces support application development, data modeling and mapping, SQL transformation, online application processing (OLAP) and data mining functionality from virtually all types of information. Composed of a component-based architecture, it extends the DB2 data warehouse with design-side tooling and runtime infrastructure for OLAP, data mining, inLine analytics and intra-warehouse data movement and transformation, on a common platform.
|
Redbooks | 21 Jun 2010 |
| Understanding IBM Cognos 8 PowerPlay Performance
This document is intended to provide IBM Cognos Series 7 PowerPlay administrators an overview of the tuning mechanisms in place for IBM Cognos 8 PowerPlay.
|
Articles | 01 Mar 2010 |
| IBM Cognos 8 BI Report Request Service (c8ReportRequestService)
A IBM Cognos 8 SDK application that provides a web services interface to run an IBM Cognos 8 BI report.
|
Articles | 23 Feb 2010 |
| IBM Cognos 8: Installing Cognos 8 on webSphere Portal
Steps on how to intergate IBM Cognos 8 portlets in IBM Websphere Portal.
|
Articles | 14 Dec 2009 |
| IBM Cognos Planning: Creating BI Reports Using Virtual Dimensions from Planning
Use an IBM Cognos Planning virtual dimension as a time dimension in an IBM Cognos 8 BI report. The author discusses using different “Dimensions for Publish” in this scenario and how it changes the available fields in the Cognos 8 report.
|
Articles | 14 Dec 2009 |
| Link Cognos Now! Dashboard to External Links
This write-up will help IBM Cognos Now! users in understanding how they can establish a link between Cognos Now! dashboards and any external web link.
|
Articles | 10 Dec 2009 |
| Integrating IBM Mashup Center and IBM Cognos 8
This article describes an end-to-end process to integrate dynamic market metrics with rich Business Intelligence content. This is achieved by using IBM Mashup Center to easily assemble real time feeds into functional mash ups and IBM Cognos to integrate external data into on-demand reports through its parameterized URL interface.
|
Articles | 10 Dec 2009 |
| Cognos Business Viewpoint and IBM Cognos Controller
This document will provide guidelines to using IBM Cognos Business Viewpoint with IBM Cognos Controller.
|
Articles | 10 Dec 2009 |
| Eliminating Intercompany Gain or Loss on Sale of Fixed Assets
This document will provide guidelines to eliminating the intercompany gain and losses on sales fixed/depreciable assets.
|
Articles | 10 Dec 2009 |
| Configure TM1 9.5 Contributor with Apache Tomcat
Deploying the TM1 Contributor application in Apache Tomcat.
|
Articles | 07 Dec 2009 |
| Configure TM1 9.5 Contributor with Websphere CE
Deploying the TM1 Contributor application in IBM Websphere CE.
|
Articles | 07 Dec 2009 |
| Public Service Gets Smarter
A look at how governments and public-sector organizations are using data warehousing and BI
|
Articles | 19 Oct 2009 |
| 6 Keys to Real-Time Analytics
This article provides six best practices for data management professionals to ensure that their performance management and analytics initiatives are set up for success.
|
Articles | 13 Oct 2009 |
| Using virtual cubes in IBM InfoSphere Warehouse 9.7 to combine business
scenarios and to improve performance
Virtual cubes are one of the new Cubing Services features in IBM
InfoSphere(TM) Warehouse 9.7. A virtual cube provides a way to merge different
cubes together to allow a single query destination that returns merged results
from the cubes that compose it. Virtual cubes can be used to drastically
improve the response time of the cube server queries by using efficient data
partitioning for optimum cache utilization (in some cases, over 100 times
better response times). Virtual cubes also offer a solution for combining
results by merging different regional cubes into a country cube. They also
enable merging sales numbers with currency exchange rates to provide a global
view of the business. This article explains how virtual cubes are created, how
they work, and how to use them for InfoSphere Warehouse Cubing Services
9.7.
Also available in:
Russian
Portuguese
|
Articles | 10 Sep 2009 |
| Designing and deploying a security model using IBM InfoSphere Warehouse
Cubing Services
In IBM InfoSphere(TM) Warehouse V9.7, Cubing Services modify the way you
secure your cubes and provide a way for you to secure your dimensions. You
might need to limit access to your OLAP data at the level of the cube or at
the more granular level of the dimension, depending on your security
requirements. In this article, you will learn how to define security on cubes
and dimensions by creating roles, policies, and authorizations in the Design
Studio. This article describes how to export the security model to a file and
how to use the Administration Console to import the security model to the
InfoSphere Warehouse control database. After importing the security model, you
will learn how to instruct the Cube Server to enforce the rules in the
security model.
Also available in:
Portuguese
|
Articles | 03 Sep 2009 |
| Guidelines to Currency Translation in IBM Cognos Controller
Document will provide guidelines to handling investment adjustment when 100 percent ownership exists.
|
Articles | 02 Sep 2009 |
| Passing Use and Display Values on a URL
This document focuses on passing 'Display values' as the primary value, and also includes details on how to pass complex parameters such as ranges.
|
Articles | 18 Aug 2009 |
| Generate Cognos reports using InfoSphere Warehouse Cubes
Learn how to generate Cognos professional reports using InfoSphere Warehouse data models.
Cognos is SOA-based, light-weight, and user-friendly, and no programming skills are required to create reports.
This article serves as a start for users who may have used other tools in the past and now want to generate professional
Cognos reports using InfoSphere Warehouse cubes.
Also available in:
Portuguese
|
Articles | 18 Jun 2009 |
| Install and configure InfoSphere Warehouse on System z
This article takes you through the installation of InfoSphere Warehouse on a Linux partition on System z. Learn about pre-installation requirements, then walk through the steps for a successful installation.
|
Articles | 14 May 2009 |
| Get started with Informix Warehouse Feature, Part
1: Model your data warehouse using Design Studio
The new IBM Informix Warehouse Feature provides an integrated and
simplified software platform to design and deploy a warehouse repository on
your existing IBM Informix Dynamic Server (IDS) infrastructure. This tutorial,
the beginning of a series, gives you a first look at the Informix Warehouse
Feature and its components. It will first introduce you to the context behind
the new tools available and the value they add in a data warehouse scenario
based on Informix, and then, it will give you a hands-on and example-driven
view of the Informix Warehouse Client component, the Design Studio, by going
through the steps for creating a simplified data warehouse and data
extract-load-transform (ELT) project, identifying the source and the target
databases involved, and designing the database physical model you have planned
for your target Informix warehouse.
|
Tutorial | 27 Apr 2009 |
| Integrate InfoSphere Warehouse Data Mining with IBM Cognos
Reporting, Part 4: Customer segmentation with InfoSphere Warehouse and Cognos
In the previous articles of this series, you learned different
techniques for integrating InfoSphere Warehouse Data Mining and simple Cognos
reports. This latest article teaches you how to use some of the same
integration techniques to create a more complex report that focuses on the
task of customer segmentation. Customer segmentation allows companies to
cluster their customers into characteristic groups. One important issue in this task is to explain to
the user the meaning of the individual customer segments. Interactive Cognos
reports can help you do this. The article uses a step-by-step example, to
teach you how to create a report that visualizes cluster statistics and, thus,
allows you to find out which customers in a given segment are special. The
article also shows you how to enable drill-through for accessing details of
individual customers within a segment.
Also available in:
Vietnamese
|
Articles | 29 Jan 2009 |
| Create business reports for XML data using IBM DataQuant and DB2 pureXML
Use IBM's DataQuant all-purpose business intelligence tool for reporting on
XML data stored in DB2 pureXML. Follow steps to use DataQuant to access the XML
data stored in DB2 and make the individual data elements available in reports, charts, and dashboards for business insight and analysis.
Also available in:
Japanese
|
Articles | 15 Jan 2009 |
| Instant Information: Stream Computing
Talk about low latency. IBM's new InfoSphere Streams technology lets companies analyze data in motion, bringing results in milliseconds.
|
Articles | 02 Jan 2009 |
| Setting Up An IDE For Use With The IBM C8 SDK Samples
Shows how to setup the Cognos 8 Java and C# SDK samples within popular IDE's. This eliminates some of the restrictions of running and building the SDK samples using the batch files or shell scripts that are supplied with the product.
|
Articles | 01 Jan 2009 |
| Extended Handling Of IBM Cognos 8 Reports Saved To A File System
Java application that enhances the functionality provided by CM.OUTPUTLOCATION. See the file c8CmOutputProcessorNOTES.pdf for instructions on installation and operation.
|
Articles | 01 Jan 2009 |
| Styling Prompts
This document instructs report authors on styling prompts and prompt buttons with the use of object properties and classes.
|
Articles | 01 Jan 2009 |
| Cognos Connection Logoff Redirector (IBM Cognos 8 BI)
Java servlet for Cognos 8 to redirect a user's browser to a specified webpage after logging off from Cognos Connection. See the file LogoffRedirC8 Configuration.pdf for installation and configuration information.
|
Articles | 01 Jan 2009 |
| Application Servers and Cognos 8
High level overview of Application Servers and considerations for selecting which one to use with ReportNet or Cognos 8.
|
Articles | 01 Jan 2009 |
| Run Reports on Cube Update
An example of how to use Event Studio to check for updates within an OLAP source and then, when changes are detected, run a set of reports based on this OLAP data source.
|
Articles | 01 Jan 2009 |
| Managing Report Server Database Connections
A description of the differences between settings available within Cognos ReportNet 1.x warpproperties.xml and Cognos 8 rsvpproperties.xml regarding report server connections.
|
Articles | 01 Jan 2009 |
| Currency Coversions in IBM Cognos Planning
This document offers guidelines on designing currency conversion in Cognos Planning models. Two approaches are discussed: Centralized and De-Centralized currency conversions, examples and screenshots are included.
|
Articles | 01 Jan 2009 |
| Tabbed Prompt Report Workshop
A technique to improve performance of reports using many optional prompts. The isolation of the prompts into seperate tabs allows the processing to be split and allow the first set of prompts to be displayed more quickly to end users.
|
Articles | 01 Jan 2009 |
| IBM Cognos 8 Planning Analyst - Conditional Statements
This document covers best practices in creating Conditional Statements in Cognos Planning Analyst.
|
Articles | 01 Jan 2009 |
| Setting Up Single Sign-on with Upfront and EP
A troubleshooting guide to setting up single sign-on when Upfront and Cognos Planning are installed on different servers.
|
Articles | 01 Jan 2009 |
| Report Studio Workshop - Maps
An outline of Map properties such as Points, Regions, Layers, Titles, Custom Palettes, Data Dictionary, Translations, Map Manager, and Drill through.
|
Articles | 01 Jan 2009 |
| Wait Message in Cascading Prompts
This document shows the user how they can leverage Javascript to inform the user that the report is executing after selecting a prompt value from an auto submit prompt in Report Studio
|
Articles | 01 Jan 2009 |
| Report Studio Workshop - Shared Layout Components
An overview of the shared layout components that can be shared both within a single report and between multiple reports. The Layout Cache is also described and how it allows for automatic or manual updates of shared objects.
|
Articles | 01 Jan 2009 |
| Use of PowerCubes in Cognos 8
Use of PowerCubes in Cognos 8: PCOptimizer, retaining Category IDs, CubeSwap, ReadCache.
|
Articles | 01 Jan 2009 |
| Query Studio Workshop - Creating Multilingual Titles
A review of the Query Studio capabilities for creating reports with multilingual titles and sub-titles.
|
Articles | 01 Jan 2009 |
| Importing Controller 8.3 Data from Framework Manager
This document provides an example of importing data from an IBM Cognos Framework Manager Model to IBM Cognos Controller 8.3.
|
Articles | 01 Jan 2009 |
| Installation and Configuration IBM Cognos 8.3 Special Edition
Descibes the install and configure of the IBM Cognos 8.3 Special Edition
|
Articles | 01 Jan 2009 |
| Preparing multi fact calculations in Framework Manager
How to resolve multi fact calculations with null values in Framework Manager
|
Articles | 01 Jan 2009 |
| Formatting Report Parameters using layout Calculations
This document was created in response to a customer enhancement request for the ability to format parameter values displayed as Layout Calculations.
|
Articles | 01 Jan 2009 |
| Guidelines to using Change Tables - Controller
This document will provide guidelines to using Change Tables.
|
Articles | 01 Jan 2009 |
| Guidelines to using Linked Structures
This document provide guidelines to setting up and using linked structures.
|
Articles | 01 Jan 2009 |
| Tree Prompts
This document describes how you can build a dimension and use it to create a tree prompt to filter against a relational datasource. The zip file contains the document, model, report specification and an export of the MS SQL Server2005 datasource.
|
Articles | 01 Jan 2009 |
| Integration of InfoSphere Warehouse Data Mining with IBM Cognos Reporting, Part 3: Invoke mining dynamically from Cognos using a market basket analysis example
Association rules express which items, events or other
entities often occur simultaneously in large datasets. This knowledge
can be applied, for instance, in market basket analysis to
leverage cross-selling potentials by recommending products
that are ofter bought together.
You can apply association rule mining in InfoSphere
Warehouse and export the resulting model to Cognos reports,
similar to the way previous articles in this series did with Cluster and Classification models.
Since association rule mining is a highly interactive task, a better
solution would be to allow the user to call mining directly
from a Cognos report, possibly specifying additional
parameters. Such an approach can be denoted as dynamic or ad hoc mining.
In this article you will learn to achieve this.
|
Articles | 30 Dec 2008 |
| Create business reports for XML data with Cognos 8 BI and DB2 pureXML
Learn how creating relational views of hierarchical XML data as well as writing SQL-based queries over XML data can enable you to extract important information from XML documents and messages, integrate this information with existing relational data, and create reports for business analysts and executives.
|
Articles | 26 Nov 2008 |
| Integrate IBM InfoSphere Warehouse data mining with IBM Cognos
reporting, Part 2: Deviation detection with InfoSphere Warehouse and Cognos
Learn advanced techniques, such as drill-down and the extraction of
structured information from data mining models with Cognos. Using the included
business scenario and running example, understand the data mining task of
deviation detection, that is, the task of identifying unnatural data records.
See how to find such records with IBM InfoSphere Warehouse data mining, and
create interactive reports that allow interactive exploration.
|
Articles | 26 Nov 2008 |
| Integrate InfoSphere Warehouse data mining with IBM Cognos
reporting, Part 1: Overview of InfoSphere Warehouse and Cognos integration
architecture
Get an introduction to the basic integration architecture involved in
integrating InfoSphere Warehouse data mining with IBM Cognos reporting, in Part 1 of
this series. Also, examine a technical case study to gain a basic understanding of how to achieve the integration.
|
Articles | 30 Oct 2008 |
| IBM Cognos SDK Validation tool
Download and try the IBM Cognos Validation tool, a command line utility written in Java using the IBM Cognos SDK.
This tool can run a complete validation check of all the reports in the Content Store by automating the Report Studio validate process.
Also available in:
Russian
|
Articles | 07 Aug 2008 |
| Seven Essential Elements Whitepaper
This paper introduces 7 elements that are critical to ensure the highest degree of performance and scalability of information integration: data pipelining, dynamic and in-flight (re-) partitioning, design once andh deploy flexibly, supporting parallel databases, real-time data processing, performance optimization tooling, and extensible framework. We highlight the unique advantages of InfoSphere Information Server to achieve the highest level of performance and scalability with the best ROI.
|
Articles | 17 Jul 2008 |
| IBM Cognos 8 BI tips and techniques: Change the name of a PowerPlay report in Cognos Connection as it appears in
Upfront
Download a Java sample that gives you a way to rename Cognos PowerPlay
Enterprise Server views and reports so that they are the same as they appear in Cognos
Upfront. Get step-by-step instructions for implementing this code sample.
|
Articles | 19 Jun 2008 |
| Using Information Server in the Cognos 8 BI Data Manager environment
IBM Cognos 8 Business Intelligence Data Manager creates data warehouses and
repositories for reporting, analysis and performance management. When you integrate
the Information Server with Data Manager, you can capitalize on the data transformation
and cleansing capabilities of the Information Server in the Data Manager environment.
This tutorial offers two out-of-box integration scenarios. In one scenario, IBM WebSphere DataStage processes ETL flow and invokes Data Manager to load the data mart. In the other scenario,
Data Manager JobStream invokes DataStage ETL jobs and then loads the data mart.
These enable the Cognos report writer to have the latest information available to them.
Learn how to integrate Information Server and Data Manager environment, and how this integration can benefit your business.
|
Tutorial | 12 Jun 2008 |
| Use the Business Intelligence Reporting Tool with DB2 Data Warehouse
Edition, Part 4: Interactivity in reports and charts
The Business Intelligence and Reporting Tool (BIRT) is an open source,
relational reporting solution. It provides an Eclipse-based plug-in for report
development and testing, and it provides J2EE deployment and API that can be used in
custom Java applications. With IBM DB2 Data Warehouse Edition (DWE), use DWE Design
Studio to seamlessly integrate the BIRT development environment, and then deploy
those reports to an IBM WebSphere server. During the course of this tutorial, learn
how to add interactivity to your reports using BIRT in Design Studio.
Also available in:
Chinese
|
Tutorial | 06 Mar 2008 |
| Data integration with SAP NetWeaver Business Intelligence using IBM Information Server
Follow a step-by-step guide on how to use the IBM Information Server to load
data into the SAP BI. Also see, in detail, the procedure to leverage the IBM Information Server to extract data from the SAP BI.
Also available in:
Russian
|
Articles | 21 Feb 2008 |
| Meet the experts: Leah MacMillan talks about IBM Cognos 8 v3
This question and answer article features Leah MacMillan, VP, BI and Platform Product Marketing for Cognos, an IBM company. Leah talks to us about the latest version of IBM Cognos 8 BI and how the newest capabilities and platform enhancements strengthen the already solid foundation for performance management.
|
Articles | 06 Feb 2008 |
| Create Web services for real-time scoring using DB2 Warehouse V9.5
Build real-time scoring analytical Web services with DB2 Warehouse
V9.5 Design Studio. Compute cross-sell recommendations using
association models or compute risk scores using prediction
models in real-time to drive operational business decisions.
Also available in:
Russian
|
Articles | 06 Dec 2007 |
| Hints and tips for using the Business Intelligence and Reporting Tools
The open source, Eclipse-based Business Intelligence and Reporting Tools project brings advanced reporting capabilities to Information Management products such as DB2 Data Warehouse Edition and WebSphere RFID Information Center. This article shows you how to go beyond the basics to implement additional functions to meet the detailed reporting needs of your user community.
|
Articles | 09 Aug 2007 |
| Use the Business Intelligence Reporting Tool with DB2 Data Warehouse
Edition, Part 2: Create basic reports and charts
Learn the best practices of using BIRT in Design Studio. This tutorial is
Part 2 of a series aimed at demonstrating the best practices for installing BIRT,
using it to create reports on relational data, and then deploying them in a Web
server to view them.
Also available in:
Chinese
|
Tutorial | 12 Jul 2007 |
| Rapid Windows application development with IBM Informix Dynamic Server and IBM Database Add-ins for Visual Studio 2005
IBM introduced the IBM Database Add-ins for Visual Studio 2005 to allow rapid Windows application development, database schema development, and debugging, along with numerous other features. Now, support for Informix Dynamic Server (IDS) is added to this product, allowing IDS application developers to use some of the basic and important Visual Studio functionalities. In this article, you'll be introduced to the functionalities provided by IBM Database Add-ins for Visual Studio 2005 for Informix.
Also available in:
Chinese
|
Articles | 03 May 2007 |
| Improve DB2 query performance in a business intelligence environment
Running large queries efficiently is a top performance challenge in a business intelligence environment. Learn techniques for improving DB2 data server query performance in this environment. Walk through various methods, step-by-step, then experiment on your own system. Each method is applied to a single SQL statement, using the db2batch tool to measure performance.
|
Articles | 22 Mar 2007 |
| Advanced topics for DWE users Part 2: Best practices for choosing DB2 Data Warehouse Edition SQL Warehousing variable phases
Optimize your DB2 Data Warehouse Edition flow design with a good understanding
of variable usage in order to promote user satisfaction, support flow reuse, and help
reduce administration overhead. In this article, find recommendations and best practices on how to best utilize different variable phases to maximize the benefits of variable usage in SQL Warehousing Tool data flows and control flows during design time, and how each variable
phase can impact the runtime behavior when these flows are
executed.
|
Articles | 01 Feb 2007 |
| Enable OLAP report globalization feature using DB2 Alphablox with DB2 Cube Views
Learn how your global database application can support localization using IBM DB2 Cube View and DB2 Alphablox. These two products work together to create an integrated multidimensional OLAP Web application solution.
|
Articles | 09 Mar 2006 |
| Text Mining for associations using UIMA and DB2 Intelligent Miner
Get more value from your unstructured information. Explore how you can mine text using UIMA and DB2 Intelligent Miner to bridge from unstructured to structured information.
|
Articles | 02 Feb 2006 |
| Integrate DB2 Alphablox and DB2 Cube Views to build multidimensional OLAP Web apps
The integration solution of IBM DB2 Cube Views and DB2 Alphablox enables multidimensional OLAP Web applications based on relational database to be built easily and rapidly.
|
Articles | 02 Feb 2006 |
| Generate SQL queries based on DB2 Cube Views metadata
Build SQL queries on a data warehouse, based on the DB2 Cube Views OLAP
metadata.
|
Articles | 26 Jan 2006 |
| IBM Redbooks: Business Performance Management . . . Meets Business Intelligence
In this IBM Redbook, we discuss business performance management (BPM) and its integration with business intelligence. BPM is all about taking a holistic approach for managing business performance and achieving the business goals.
|
Articles | 16 Aug 2005 |
| Deliver an effective and flexible data warehouse solution, Part 1: Engage your customers in planning the data warehouse project
Take a flexible and effective approach to plan, design, and implement a basic data warehouse solution with this article series. Part 1 focuses on the customer engagement process and project planning.
|
Articles | 16 Jun 2005 |
| Business Intelligence solutions architecture
Build a data warehouse solution using IBM technology.
|
Articles | 26 May 2005 |
| Data mining with association rules using WebSphere Commerce Analyzer
This short tutorial shows how you can create association rule mining against the WebSphere Commerce operational database or against a WebSphere Commerce Analyzer data mart where the production system is not impacted. You can use the results from association rule mining to set up bundles of packages that customers tend to buy together.
|
Articles | 24 Nov 2004 |
| Build Web-based analytic applications with DB2 Alphablox and DB2 Information Integrator
IBM DB2 Information Integrator and DB2 Alphablox enable Web application developers to quickly build components that integrate data from a wide variety of sources into a single report or chart. Author C.M. Saracco shows how it's done.
|
Articles | 09 Nov 2004 |
| IBM DB2 Intelligent Miner Tutorials
Data mining is an innovative way of gaining new and valuable business insights by analyzing the information held in your company database. These insights can enable you to identify market niches, and they support and facilitate the making of well-informed business decisions. Essentially, data mining is a groundbreaking way to leverage the information that your company already has in order to plan a business strategy for the future.
|
Articles | 01 Nov 2004 |
| DB2 UDB ESE V8 non-DPF Performance Guide for High Performance OLTP and BI
This IBM Redbook provides detailed information on implementing high performance OLTP and BI applications in DB2 UDB ESE V8 environments involving AIX and Windows 2000 platforms. It is aimed at a target audience of DB2 application developers and database administrators (DBAs).
|
Redbooks | 29 Apr 2004 |
| Preparing for DB2 Near-Realtime Business Intelligence
This redbook is what you need to get prepared to implement near-realtime business intelligence in your environment.
|
Redbooks | 25 Mar 2004 |
| Tip: Using DB2 Governor with DB2 Query Patroller
This TIP discusses the processes used by DB2 Query Patroller and the rules of the DB2 Governor configuration file. It includes situations that can cause DB2 Governor to act against DB2 Query Patroller. Published February, 5, 2004.
|
Redbooks | 12 Feb 2004 |
| A technique for monitoring the warehouse population process
A warehouse administrator relies upon warehouse monitoring capabilities to check and be informed about the status or "health" of the warehouse. To this effect, DB2 Warehouse Manager provides the WIP, or "Work in Progress". In this paper, we show how the WIP capabilities can be extended to keep the past history of the WIP, and to gather additional changes in step status. We also provide sample queries that the warehouse administrator can use to check the history of the warehouse population process.
|
Articles | 29 Jan 2004 |
| Using DB2 UDB OLAP functions
Online analytical processing (OLAP) functions are very flexible and powerful. Using them, you may come up with simple solutions to some problems that would otherwise require either iteration through one or several cursors or recursion. In some other cases it is much easier to write a query using OLAP functions or auxiliary tables than to write an equivalent query not using them.
|
Articles | 22 Jan 2004 |
| Building business intelligence skills
Data warehousing and business intelligence projects require very specific and sound technical skills. It is no mean feat to collect data from many different sources and ensure it is validated, combined, structured, stored, distributed and analyzed reliably and correctly. This requires a sound knowledge of information analysis techniques, of data warehousing and business intelligence technology. Additionally, one also needs a level of business acumen to understand how business intelligence technology can support the decision making process within the organization.
|
Articles | 22 Jan 2004 |
| Create an intelligent and flexible solution with BPM, Business Rules, and Business Intelligence: Sense and respond in the data warehouse
In our first article, we introduced the overall concepts of ondemand business, business process management (BPM), business rules engine and business intelligence. In the second article, we demonstrated how a business rules engine can serve to externalize policy from the business process manager. In the third article, we discussed the details of how to make business intelligence data visible to the business process. In this final article in the series, we touch on analytics in concert with BPM can create a dynamic and flexible sense and respond environment.
|
Articles | 04 Dec 2003 |
| Create an intelligent and flexible solution with BPM, Business Rules, and Business Intelligence: Data warehouse visibility
This article focuses on the role of business intelligence in an intelligent and flexible BPM solution. It discusses the application of on-line analytical processing (OLAP) technology for advanced analytics, considering both OLAP access and integration. This includes drilling down to the technical details of implementing a dynamic pricing model. Finally, it introduces DB2 Cube Views, an extension to the OLAP paradigm which, when used with OLAP products, can be used to produce optimized OLAP solutions for enterprises.
|
Articles | 20 Nov 2003 |
| Mining Your Warranty Data Using IBM DB2 Intelligent Miner for Data
This paper starts with the concept of warranty and shows how IBM?s DB2 Intelligent Miner for Data can be used to analyze repair records.
|
Articles | 20 Nov 2003 |
