Technical library

  • spacer Filter by products, topics, and types of content

    (115 Products)

    (113 Topics)

    (15 Industries)

    (15 Types)

 

1 - 100 of 114 results | Next Show Summaries | Hide Summaries Subscribe to search results (RSS)

View Results
Title none Type none Date down
Create a business intelligence and analytics service in Ruby with Analytics Warehouse on IBM Bluemix
The Analytics Warehouse Service available in IBM Bluemix provides a powerful, easy-to-use, and agile platform for business intelligence and analytics. It is an enterprise-class managed service that is powered by the in-memory optimized, column-organized BLU Acceleration data warehouse technology. This article demonstrates how easy it is to incorporate the Analytics Warehouse service into your application so that you can focus on your application.
Also available in: Chinese   Japanese   Spanish  
Articles 10 Jul 2014
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  
Articles 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.
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
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
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
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 the IBM InfoSphere Warehouse 9.7 Administration Console, Part 1: Getting started and setting up
This series of articles introduces the IBM InfoSphere(R) Warehouse Administration Console 9.7, which is part of the IBM InfoSphere Warehouse product. The InfoSphere Warehouse Administration Console provides an integrated Web portal to administer, monitor, and configure related InfoSphere Warehouse components in an operational environment. This Part 1 of this series provides a general introduction to the new features delivered in version 9.7, and it covers topics related to configuration and resource management, including security configuration, system metadata configuration, configuration services management, logging services management, connection management, and system resource management.
Also available in: Russian  
Articles 21 Sep 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.
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.
Articles 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
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
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
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
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
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
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
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
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
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
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
IBM Cognos 8 Planning Analyst - Conditional Statements
This document covers best practices in creating Conditional Statements in Cognos Planning Analyst.
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
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
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
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
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
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
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
Preparing multi fact calculations in Framework Manager
How to resolve multi fact calculations with null values in Framework Manager
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
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
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
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.
Also available in: Chinese   Russian   Vietnamese  
Articles 30 Dec 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.
Also available in: Chinese   Russian   Vietnamese  
Articles 26 Nov 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.
Also available in: Chinese   Russian  
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.
Also available in: Chinese   Russian   Vietnamese  
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.
Articles 12 Jun 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
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.
Also available in: Chinese   Russian  
Articles 09 Aug 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.
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.
Also available in: Chinese   Russian  
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
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
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
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
Create an intelligent and flexible solution with BPM, Business Rules, and Business Intelligence: Proactive use of business rules
The second in a series of articles exploring on-demand scenarios that integrate business process management, business rules and business intelligence, this article focuses on integration of external business rules into a business process and looks at how business rules were integrated into the business process at a fictitious company.
Articles 23 Oct 2003
Create an intelligent and flexible solution with BPM, Business Rules, and Business Intelligence: Business process analysis
This is the first in a series of articles that will examine several scenarios for creating flexible, dynamic and responsive business solutions through the integration of business process management, business rules and business intelligence. This article uses an examination of the problems of a fictitious company to introduce the concepts.
Articles 09 Oct 2003

1 - 100 of 114 results | Next Show Summaries | Hide Summaries Subscribe to search results (RSS)