Technical library

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

    (114 Products)

    (113 Topics)

    (15 Industries)

    (15 Types)

 

1 - 97 of 97 results Show Summaries | Hide Summaries Subscribe to search results (RSS)

View Results
Title 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  
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  
29 Nov 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  
27 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.
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  
27 Jul 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  
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.
26 Jan 2011
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  
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
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  
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  
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  
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.
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.
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.
23 Feb 2010
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.
14 Dec 2009
IBM Cognos 8: Installing Cognos 8 on webSphere Portal
Steps on how to intergate IBM Cognos 8 portlets in IBM Websphere Portal.
14 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.
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.
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.
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.
10 Dec 2009
Configure TM1 9.5 Contributor with Websphere CE
Deploying the TM1 Contributor application in IBM Websphere CE.
07 Dec 2009
Configure TM1 9.5 Contributor with Apache Tomcat
Deploying the TM1 Contributor application in Apache Tomcat.
07 Dec 2009
Public Service Gets Smarter
A look at how governments and public-sector organizations are using data warehousing and BI
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.
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  
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  
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.
03 Sep 2009
Guidelines to Currency Translation in IBM Cognos Controller
Document will provide guidelines to handling investment adjustment when 100 percent ownership exists.
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.
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  
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.
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.
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  
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  
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.
02 Jan 2009
Query Studio Workshop - Creating Multilingual Titles
A review of the Query Studio capabilities for creating reports with multilingual titles and sub-titles.
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
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.
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.
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.
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.
01 Jan 2009
IBM Cognos 8 Planning Analyst - Conditional Statements
This document covers best practices in creating Conditional Statements in Cognos Planning Analyst.
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.
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.
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.
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.
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.
01 Jan 2009
Styling Prompts
This document instructs report authors on styling prompts and prompt buttons with the use of object properties and classes.
01 Jan 2009
Guidelines to using Linked Structures
This document provide guidelines to setting up and using linked structures.
01 Jan 2009
Guidelines to using Change Tables - Controller
This document will provide guidelines to using Change Tables.
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.
01 Jan 2009
Preparing multi fact calculations in Framework Manager
How to resolve multi fact calculations with null values in Framework Manager
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
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.
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.
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.
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.
01 Jan 2009
Use of PowerCubes in Cognos 8
Use of PowerCubes in Cognos 8: PCOptimizer, retaining Category IDs, CubeSwap, ReadCache.
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  
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  
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  
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  
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  
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.
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.
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.
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  
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  
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  
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.
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  
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.
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.
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.
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.
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.
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.
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.
16 Jun 2005
Business Intelligence solutions architecture
Build a data warehouse solution using IBM technology.
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.
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.
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.
01 Nov 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.
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.
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.
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.
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.
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.
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.
09 Oct 2003
How to Build a Metadata Bridge for DB2 Cube Views
The DB2 Cube Views feature of DB2 makes it easier to integrate business intelligence applications with the data warehouse by sharing the multidimensional metadata between the relational database and business intelligence applications. Learn how you can enable your business intelligence applications or tools to take advantage of this great new feature.
22 May 2003
Developing Object-Relational Database Applications, Part 1: database analysis and design methodology
The following article was previously published in the Informix Tech Notes quarterly journal. The Tech Notes archive covers the years 1991 to 2001. This is the first article in a two-part series on developing object-relational database applications.
06 Jun 2002
Developing Object-Relational Database Applications, Part 2: application implementation
The following article was previously published in the Informix Tech Notes quarterly journal. The Tech Notes archive covers the years 1991 to 2001. This is the second article in a two-part series on developing object-relational database applications.
06 Jun 2002
Connector for SAP R/3: A Ready-to-go Warehousing Solution
Realize the value of integrating critical SAP R/3 data with other important business data for enhanced business intelligence. Incorporate SAP business objects into your DB2 data warehouse quickly and easily using Connector for SAP R/3.
01 Apr 2002
Web Click Stream Analysis using Linux Clusters
Marty Lurie describes how to use SQL to analyze the logs of a Web server to understand how people use the site and performance issues. Using Linux clusters with a shared nothing database can improve the performance of that processing. Examples are shown using IBM-Informix XPS Developers Kit.
24 Oct 2001
Operation Data Mining
This article explains the considerations in operationalizing data mining, how DB2 Intelligent Miner Scoring brings the model deployment process out of the hands of analysts into the standard database administrative process, and what data mining developments to expect in the future.
27 Jul 2001
Reading between the lines
This article discusses methods of mining unstructured data including three fundamental text mining operations: clustering, categorization, and information retrieval.
01 Mar 2001

1 - 97 of 97 results Show Summaries | Hide Summaries Subscribe to search results (RSS)