 |
|
|
|
Saving Report Output to the Server File System
This document was created to provide a single point of instructions to successfully enable the “saving report output to the file system” feature in IBM Cognos 8.
|
|
27 Nov 2009 |
|
| |
Data Importing using IIF function for IBM Cognos Controller
This document will explain how to use IIF functions with importing data into IBM Cognos Controller.
|
|
23 Nov 2009 |
|
| |
Gauge SQE use in DB2 for i 6.1
This article explains how to collect a SQL Performance Monitor and understand how many of the SQL queries are using SQE and why other SQL statements continue to use CQE. SQE is the strategic query engine on DB2 for i, with better performance, scaling and tooling such as the SQL Plan Cache.
|
|
22 Nov 2009 |
|
| |
Guidelines to building Cash Flow in IBM Cognos Controller
This document will describe the process to create cash flow in IBM Cognos Controller.
|
|
19 Nov 2009 |
|
| |
Guidelines in including subgroup companies in datamart
Document will provide guidelines on how to include subgroups in datamart template.
|
|
19 Nov 2009 |
|
| |
U2 SELECT verb list extension
This article provides a general solution to the problem of record selection based on a large
list of non-primary-key values. It is a step-by-step guide to building a new verb which selects records based on a
match between dictionary values and standard UniData SAVE.LIST and SELECT buffer lists.
For those who like to build their own tools, it offers an interesting project. For those who prefer to use tools
others have built, the completed verb source code is available as a download.
|
|
19 Nov 2009 |
|
| |
Build FileNet BPM applications using IBM ECM Widgets, Part
3: Expanding ECM Widgets using third-party widgets
With IBM Enterprise Content Management Widgets (ECM Widgets), business
analysts can easily design and create new enterprise applications to meet
business requirements. The ECM Widgets application provides rich user
interfaces to communicate with third-party widgets. Business analysts can
create their own widgets or use existing widgets to connect with ECM Widgets
to gain more business value. This article, the third and last in the series,
shows you the IBM iWidget event mechanism, the ECM Widgets event framework,
and how to develop an application that combines third-party widgets and ECM
Widgets.
|
|
19 Nov 2009 |
|
| |
Understanding the New Contributor Web Grid
This document will discuss the technology used in the new Contributor Eclipse based grid, as well as install routines, and setting modifications. It will also cover logging.
|
|
18 Nov 2009 |
|
| |
Installing Business Viewpoint with SQL Server
This document provides a guideline for installing and configuring IBM Cognos 8 Business Viewpoint into a SQL Server 2005 environment.
|
|
18 Nov 2009 |
|
| |
Configuring SSL for Business Viewpoint
This document walks through generating the SSL certificate, and making the necessary configuration changes in Business Viewpoint to allow the use of SSL.
|
|
18 Nov 2009 |
|
| |
Guidelines to IBM Cognos Controller Functions
This document will provide information on the IBM Cognos Controller Excel Functions.
|
|
17 Nov 2009 |
|
| |
Building Period Close Schedules in IBM Cognos Controller
This document will provide guidelines to building period ending closing schedules for IBM Cognos Controller.
|
|
17 Nov 2009 |
|
| |
Use Technology Explorer for IBM DB2 to manage user and group
authentication for DB2 for Linux, UNIX, and Windows
Learn how to use the Technology Explorer (TE) for IBM DB2(R) to control
user and group authentication to DB2 through the use of a security plug-in
called db2auth. The plug-in uses a DB2 database for storing authentication
information instead of an external authentication repository, such as an
operating system or Kerberos. The plug-in allows for a smoother migration from other
database software such as MySQL, which also stores authentication information
within the database. This article also describes how the support in TE for the
db2auth plug-in was implemented. [2009 Nov 13: Updated to show Linux support.
--Ed.]
|
|
13 Nov 2009 |
|
| |
Integrating IBM Cognos 8 with Perforce
This article shows you how to integrate the widely used Configuration Management System, Perforce, with IBM Cognos.
|
|
13 Nov 2009 |
|
| |
Integrating IBM Cognos 8 with CA Siteminder
This document describes how to integrate IBM Cognos 8 with the CA Siteminder for authentication. It will describe how to leverage CA Siteminder with IBM Cognos BI in particular but mention general concepts and things to know about when integrating with other IBM Cognos products as well.
|
|
13 Nov 2009 |
|
| |
Guidelines to Yearend Procedures for IBM Cognos Controller
This document will provide guidelines to closing yearend and starting a new yearend in IBM Cognos Controller Application.
|
|
13 Nov 2009 |
|
| |
Build FileNet BPM applications using IBM ECM Widgets, Part
2: Constructing a business process management solution
IBM Enterprise Content Management Widgets (ECM Widgets) is a new
Web 2.0 application based on mashup technology. ECM Widgets is an important
component of the IBM Agile ECM FileNet(R)
portfolio. It provides a set of widgets for business designers, analysts,
IT specialists, and end users. The ECM Widgets application is highly flexible, easy to use, and
convenient to expand. A user can quickly construct a FileNet business process
management (BPM) solution by
dragging and dropping widgets to easily configure the solution. ECM Widgets
can significantly reduce the cost of implementation for enterprise business
process management. This article focuses on how to construct a BPM solution
using ECM Widgets 4.5.1 from a business designer's perspective and from a
business analyst's perspective.
|
|
12 Nov 2009 |
|
| |
Copy your SAP ERP system across platforms using DB2 redirected restore
With DB2 Version 8 or later you can use redirected restore operation to copy an SAP system from one platform to another.
This article provides you with the step-by-step instructions on how to do this and
describes the resources you need before you start.
|
|
12 Nov 2009 |
|
| |
Guidelines to logging out users and times out for IBM Cognos Controller
This document will provide guidelines to logging out users from IBM Cognos Controller.
|
|
12 Nov 2009 |
|
| |
Guidelines to setting up menu items for IBM Cognos Controller
This document will provide information on customizing Menu Items in IBM Cognos Controller.
|
|
12 Nov 2009 |
|
| |
Guidelines to Consolidation by Steps or Status - IBM Cognos Controller 8X
This document will provide guidelines to running consolidation by status or by steps.
|
|
12 Nov 2009 |
|
| |
Build a pureXML and JSON application, Part 3: Create OpenSocial gadgets for pureXML
With the Web 2.0 technology of OpenSocial gadgets, developers can easily
include their applications in popular Web sites, such as iGoogle, MySpace, Hi5,
LinkedIn, and others. In this article, explore OpenSocial gadgets through hands-on construction of an application that leverages the pureXML
capability of DB2. This article is the last in a series of three that illustrates how to build a
pureXML application whose user interface is a gadget that you can deploy in any OpenSocial compliant
Web site. Follow the steps in this article to build a user interface that stores and retrieves the
JSON data described in the first article through JSON Universal Services created in the second article.
|
|
10 Nov 2009 |
|
| |
Build a pureXML and JSON application, Part 2: Create Universal Services for pureXML that expose JSON
The pureXML Universal Services for JSON (abbreviated to JSON Universal Services in this article) are a set of database operations, including insert, update, delete, and query, exposed as Web services. These services enable an application to persist JSON in pureXML and to query it easily through HTTP with WebSphere Application Server. Get started with configuring and testing JSON Universal Services in this article.
|
|
10 Nov 2009 |
|
| |
Build a pureXML and JSON application, Part 1: Store and query JSON with DB2 pureXML
JavaScript Object Notation (JSON), a popular textual notation in Web 2.0, is used to represent objects (or data structures) as serialized text when clients and servers exchange information. Some applications benefit from persisting JSON objects to maintain state across sessions. In this article, learn how DB2 pureXML can store, manage, and query JSON when you adopt a simple JSON-to-XML mapping.
|
|
10 Nov 2009 |
|
| |
Build FileNet BPM applications using IBM ECM Widgets, Part
1: Introducing IBM Enterprise Content Management Widgets
IBM Enterprise Content Management Widgets (ECM Widgets) is a new
Web 2.0 application based on mashup technology. As an important part of the FileNet
P8 product, the application provides
several widgets that developers can use as-is or can customize to easily create
content-centric business process applications for FileNet(R) P8. This first
artlcle in the series introduces ECM Widgets features and advantages.
|
|
05 Nov 2009 |
|
| |
Detect resource leaks using IBM DB2 tracing and the Eclipse Modeling Framework
Using the IBM DB2 tracing mechanism to detect database resource leaks can be
challenging.
However, with the Eclipse Modeling Framework (EMF),
you can easily design and implement an intuitive tool
that you can use to quickly detects leaks.
|
|
05 Nov 2009 |
|
| |
Creating Mailing Lables in IBM Cognos 8 Report Studio
This document will outline how to create mailing labels in IBM Cognos 8 Report Studio.
|
|
03 Nov 2009 |
|
| |
Creating an XML electronic forms solution with an Adobe PDF form and IBM DB2 pureXML
The eForms solution described in this article involves three components: an electronic form, a web service, and a database. Because all three speak XML, there is no need for complex data mapping or conversion steps between components. The XML data format used in this example implementation is a very simple structure but you can easily expand the format to meet specific needs or even base the format on one of the many XML-based industry standards for data exchange such as NIEM for government, ACORD for insurance, or FIXML for financial markets. This solution places the collected data into the XML business format at collection time and keeps that format throughout submission and storage for a streamlined process that culminates in the business format being stored in a database where it is available for downstream processes or business analysis. You can follow the steps in this article to build and run the three components needed for this efficient XML electronic forms data collection solution.
|
|
03 Nov 2009 |
|
| |
Leveraging pureXML in a Flex microblogging application, Part 3: Using pureXML Web services to publish microblog entries to an HTML page
The pureXML capabilities of IBM DB2 allow you to store XML natively in a database
without modification, while Adobe Flex applications can read XML directly and
populate Flex user interfaces. In this three-part article series, you will create
a microblogging application that takes advantage of pureXML, Web services, and
Adobe Flex; and even allows you to publish your microblogging updates on Twitter.
In Part 1 of the series, you learned about Web Services and how they are enabled
using DB2 pureXML as you created the microblog database and tested it. Part 2
tapped into Adobe Flex and ActionScript to create the user interface of your application. In this article, the final part of the series, you will learn how to use your pureXML Web Services to publish your microblog entries to an HTML page.
|
|
03 Nov 2009 |
|
| |
Leveraging pureXML in a Flex microblogging application, Part 1: Enabling Web services with DB2 pureXML
The pureXML capabilities of IBM DB2 allow you to store XML natively in a database without modification, while Adobe Flex applications can read XML directly and populate Flex user interfaces. In this three-part article series, you will create a microblogging application that takes advantage of pureXML, Web services, and Adobe Flex; and even allows you to publish your microblogging updates on Twitter.
|
|
03 Nov 2009 |
|
| |
Leveraging pureXML in a Flex microblogging application, Part 2: Building the application user interface with Flex
The pureXML capabilities of IBM DB2 allow you to store XML natively in a database
without modification, while Adobe Flex applications can read XML directly and
populate Flex user interfaces. In this three-part article series, you will create
a microblogging application that takes advantage of pureXML, Web services, and
Adobe Flex; and even allows you to publish your microblogging updates on Twitter.
In Part 1 of the series, you learned about Web Services and how they are enabled
using DB2 pureXML as you created the microblog database and tested it. In this
article, Part 2 of the series, you will tap into Adobe Flex and ActionScript to
create the user interface of the application.
|
|
03 Nov 2009 |
|
| |
Licensing distributed DB2 9.7 servers in a high availability (HA) environment
Are you trying to ensure you're licensing your DB2 servers correctly in a high availability environment? Don't have the time nor the will to read through the announcement letters, PLETs, or your licensing sheets? Author Paul Zikopoulos explains it all in plain English for the DB2 9.7 release that became generally available on June 17th, 2009.
|
|
29 Oct 2009 |
|
| |
Which distributed edition of DB2 9.7 is right for you? (With a dash of DB2 9.8 pureScale)
Learn the details on what makes each edition of DB2 9.7 for Linux, UNIX, and Windows unique. The author lays out the specifications for each edition, licensing considerations, historical changes throughout the DB2 9.7 release cycle, and references to some interesting things customers are doing with DB2. This popular article is updated during the release for any intra-version licensing changes announced in a Fix Pack as well. This article also discusses some details of the DB2 9.8 release that's the shipment vehicle for the new DB2 pureScale feature.
|
|
29 Oct 2009 |
|
| |
Consume Web services using Informix 4GL
Enable IBM Informix 4GL (I4GL) as a service consumer to leverage and
reuse existing Web services and business logic coded in I4GL or other
programming languages. Enabling I4GL as a service consumer opens up many
possibilities of using I4GL to communicate with any programming language while
still enjoying the ease of coding using I4GL.
|
|
29 Oct 2009 |
|
| |
Using DB2 incremental backup
Incremental backup is one of the key high availability features in DB2 9.5 for Linux, UNIX, and
Windows in a data warehouse environment.
This article describes how incremental backup works, when you might want to use it, and strategies for ensuring smooth recoveries. This article
has been updated for DB2 9.5.
|
|
29 Oct 2009 |
|
| |
Compare the distributed DB2 9.7 database servers
In a side-by-side comparison table, author Paul Zikopoulos makes it simple to
understand the basic licensing rules, functions, and feature differences between the members of the distributed
DB2 9.7 server family as of its general availability date of June 19th, 2009.
|
|
29 Oct 2009 |
|
| |
Use IBM Informix 4GL to develop applications that support UTF-8 character sets
After an introduction to the UTF character set, this article
describes some of the Informix(R) 4GL capabilities, including searching, editing UTF
characters, displaying UTF characters, and creating reports with UTF-8 characters.
After reading this article, you will know how to configure Informix 4GL
7.50.xC1 to support the UTF-8 character set.
|
|
29 Oct 2009 |
|
| |
DB2 and IBM's Processor Value Unit pricing
A number of years ago (3Q06), IBM Software Group (SWG) announced a new methodology for processor-based pricing and
introduced the concept of the Processor Value Unit (PVU) as a way to determine the processor rating of a server. This article describes
how DB2 for Linux, UNIX, and Windows (DB2) is licensed with the new PVU methodology for unlimited users.
|
|
29 Oct 2009 |
|
| |
Enabling Kerberos SSO in IBM Cognos Express
This document describes and demonstrates the basic steps that are required in order to enable Integrated Sign On (or Single Sign On) with Active Directory in IBM Cognos Express using the Microsoft IIS 6 Web server.
|
|
28 Oct 2009 |
|
| |
Best practices for DB2 for Linux, UNIX, and Windows: Cost reduction strategies with DB2
Learn how to use the Configuration Advisor, the Design Advisor, and autonomic features, such as the self-tuning memory manager,
to reduce the human costs associated with DB2 maintenance. Help your organization develop a holistic view of reducing costs across hardware, software, and maintenance
over time as part of the lost-cost evolution.
|
|
28 Oct 2009 |
|
| |
How IBM Cognos Planning Scales
This document will help technical and administrative users of IBM Cognos Planning to understand the nature of some scaling behaviors.
|
|
27 Oct 2009 |
|
| |
Get started with Informix Dynamic Server user interface tools
Learn about the user interface utilities that help to access,
administer, and monitor IBM Informix Dynamic Server (IDS). This article
highlights the utilities DB-Access, AGS Server Studio, Open Admin Tool, and
Informix Server Administrator. In addition, learn about some new features that
help you leverage IDS capabilities using these tools.
|
|
22 Oct 2009 |
|
| |
Prompt for Groups of Data with Common Syntax in IBM Cognos 8 Report Studio
In some cases users would like to return groupings of data based on common words found in the data itself. This document illustrates how authors can incorporate data grouping prompts using macros in a report filter.
|
|
22 Oct 2009 |
|
| |
News Bytes: IBM Data Management magazine Oct. 2009 Edition
News and updates from IBM Data Management magazine
|
|
20 Oct 2009 |
|
| |
Customizing XML storage in DB2
A review of best practices for when and how to customize your XML storage
|
|
19 Oct 2009 |
|
| |
Public Service Gets Smarter
A look at how governments and public-sector organizations are using data warehousing and BI
|
|
19 Oct 2009 |
|
| |
Top Performance Features in DB2 9 for z/OS
A look at indexing on expressions and index compression in DB2 9 for z/OS
|
|
19 Oct 2009 |
|
| |
High-performance data mining
An examination of the capabilities of IBM InfoSphere Balanced Warehouse through a scoring performance study
|
|
19 Oct 2009 |
|
| |
Change, Challenge and the Data Warehouse
A look at how data warehouse managers are tackling five industry trends
|
|
19 Oct 2009 |
|
| |
Programmers Only: Reducing Conversations with DB2 for z/OS: Part 1
A look at SQL that's unnecessary and should be eliminated, SQL that is executed more times than necessary, and SQL that should be replaced
|
|
19 Oct 2009 |
|
| |
Tuning Job Servers in Cognos Planning
How to tune job servers in Cognos Planning to allow for maximum hardware usage, and less locking delays.
|
|
16 Oct 2009 |
|
| |
Using the script option to rename PDF files to the Burst Key value
Burst output can be directed to a file system rather than being stored within the Content Store. This process produces uniquely named output files created with a generated key. A script can be used to rename these files according to the burst key value.
|
|
15 Oct 2009 |
|
| |
Durable Models
This document discusses some of the concepts behind designing a durable model to help with the lifecycle of a model in an organization.
|
|
15 Oct 2009 |
|
| |
Writing great code with the IBM FileNet P8 APIs, Part 3: Take a number
Yes, you, too, can have an ECM-backed corner bakery with a tidy customer queue! Just have them take a number. This article discusses
implementation techniques for getting reliably unique sequence numbers from a FileNet P8 repository. Some of the obvious approaches have hidden dangers,
but a correct and useful approach is simple and performant. Along the way to solving this common problem, we'll see some things about
P8 development that have a much wider scope.
|
|
15 Oct 2009 |
|
| |
Use Optim software to manage privatized test data from design to
deployment
With Optim(TM) Development Studio 2.2, built-in integration with Optim
Test Data Management enables developers and database administrators to use
copy-and-paste function to generate an Optim Test Data Management request. The
request can then be used for the efficient creation of a consistent,
right-sized, referentially intact subset of data for testing. This methodology
also enables you to enforce data privacy standards that were originally
defined in the data model that used InfoSphere(TM) Data Architect. Developers
can see which columns are private to ensure that the generated script enforces
the requirement to include the Optim Data Privacy option for de-identifying
private data. This article offers an end-to-end example scenario depicting a
data architect, a database administrator, and a developer completing the steps
needed for the solution.
|
|
15 Oct 2009 |
|
| |
Sharing Knowledge, Driven by Passion
The IBM Information Champion program recognizes dedicated IBM product advocates who share their opinions and years
of experience with others in the same field. Meet two of the newest (and youngest) recipients.
|
|
13 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 |
|
| |
Distributed DBA: Using Materialized Query Tables
This article explains what MQTs are, shows you how to create and populate a system-maintained and a user-maintained MQT, and details some situations where
using MQTs can be beneficial.
|
|
13 Oct 2009 |
|
| |
System z Rocks (Again)
Why IBM System z and DB2 are not only a popular combination for BI, but the primo platform for data warehousing
|
|
12 Oct 2009 |
|
| |
Data Manager: Right-Sized Analytics
A regional furniture retailer uses better insights (and analytics) to target customers more effectively
|
|
12 Oct 2009 |
|
| |
Smarter is: Boosting the IQ of Galway Bay
Learn how the Marine Institute Ireland SmartBay information project is netting impressive results with the help
of IBM InfoSphere Streams software.
|
|
12 Oct 2009 |
|
| |
How to identify unused indexes in DB2 for Linux, UNIX, and Windows
During database application development, developers tend to define a large number of
indexes on tables to guarantee that each and every query performs well.
After application development has been
finished and a database has gone into production, the existence of too many indexes turns
out to be a cause for decreased
database performance.
Many indexes mean more work for the database system when executing UPDATE, INSERT, and
DELETE (UID) operations.
In addition, regular maintenance activities like RUNSTATS and REORG also run
considerably longer in cases where many indexes are present.
Therefore, to achieve the best database performance, it is
critical to be able to determine which indexes are necessary for query execution and which
indexes you can
safely drop without impacting query runtimes.
This article explains several methods that a DB2 for Linux, UNIX, and Windows (DB2 LUW) database
administrator (DBA) can use to identify unused and seldom used indexes.
|
|
08 Oct 2009 |
|
| |
Using collaborative technologies for healthcare in the home
The number of people in the U.S. diagnosed with diabetes is now
reaching 24 million. Diabetes requires monitoring. In this article, get an
introduction to the concept of continuing care, particularly in the home. This
article describes how diabetes monitoring can be improved through
collaborative technologies. See how software from MyCareTeam, IBM, and other
organizations are used in an example in support of diabetes monitoring.
Understand information and Web-based technologies, such as XML storage and
services (for example, through IBM DB2 pureXML) in the
context of continuing care, as well as related initiatives, such as the
Continua Health Alliance's role in selecting appropriate standards. This
article summarizes the impact of these technologies on the building of agile
and collaborative systems for healthcare, and highlights the significant
benefits of collaborative continuing care that include cost reduction and
increased quality of healthcare.
|
|
08 Oct 2009 |
|
| |
IBM Cognos TM1 Back-up and Recovery Guide
This document provides guidance on implementing a backup and recovery policy for IBM Cognos TM1 data.
|
|
07 Oct 2009 |
|
| |
Efficient Report Design using Excel addin
This document will provide guidelines to designing reports using the Excel add-in link.
|
|
06 Oct 2009 |
|
| |
Transfer Data from TM1 to IBM Cognos Controller with a TM1 Process
This document will provide information on using Turbo Integrator with IBM Cognos Controller.
|
|
05 Oct 2009 |
|
| |
Guidelines to importing data using lookup splits - IBM Cognos Controller
This document will provide information around using lookup splits to break different types of balances and move them from asset to liability account.
|
|
01 Oct 2009 |
|
| |
Building efficiencies into a DBA's day
Optim Database Administrator (ODA), previously known as Data Studio Administrator, helps improve Database
Administrator (DBA) productivity by providing advanced change management capabilities as well as support for common database
administration tasks. The SQL and XQuery Editor in ODA (also available as part of Data Studio and other Optim products) provides contextual
help that makes command editing quick and command execution less error-prone.
This article shows you how to
use templates and create customized templates to improve your productivity when using database commands.
It also shows you how to test your customized templates and export them to share with other members of your team.
|
|
01 Oct 2009 |
|
| |
Integrating IBM InfoSphere Master Data Management Server for Product
Information Management with WebSphere Commerce
This article describes the Product Information Management (PIM) for
Commerce accelerator and best practices on how to use it. You will learn about
the different components and how you can use them to accelerate an integration
between the IBM InfoSphere Master Data Management for PIM and WebSphere
Commerce.
|
|
30 Sep 2009 |
|
| |
Configuring Intercompany Dividend Elimination - IBM Cognos Controller 8x
This document will provide guidelines to configuring the elimination dividends using the intercompany control tables.
|
|
29 Sep 2009 |
|
| |
IBM Cognos Special Edition - Installation and Configuration
This document gives extra instruction on the installation and configuration of the IBM Cognos 8.4 Special Edition.
|
|
29 Sep 2009 |
|
| |
IBM Cognos 8 and WebSphere Clustering
This document describes how to set up IBM Websphere clustering for a IBM Cognos 8.4 Environment.
|
|
29 Sep 2009 |
|
| |
Configure SAP Application Server against IBM Cognos 8.4
This document give extra instructions to set up SAP Application server against IBM Cognos 8.4.
|
|
29 Sep 2009 |
|
| |
Installing and Configuring the JBOSS Application Server for IBM Cognos 8
This document give extra instructions to set up JBoss against IBM Cognos 8.4 environment.
|
|
29 Sep 2009 |
|
| |
SAP Web Configuration and IBM Cognos 8 Deployment
This document is for those who have limited experience with SAP Web Application Server (SAP WAS) and who wish to set up a SAP WAS environment. The document consists of detailed instructions that explain the steps required. The primary goal is to set up a basic environment for testing purposes and not necessarily a high performance production environment.
|
|
29 Sep 2009 |
|
| |
Sun Java Systems Application Server (SJSAS) Installation
This document give extra instructions to set up Sun JSAS against IBM Cognos 8.4.
|
|
29 Sep 2009 |
|
| |
BEA WebLogic Configuration and IBM Cognos Application Deployment
This document give extra instructions to set up BEA Weblogic against IBM Cognos 8.4.
|
|
29 Sep 2009 |
|
| |
Installing and Configuring the IBM Cognos Application
This document give extra instructions to set up IBM Cognos 8.4.
|
|
29 Sep 2009 |
|
| |
Installing and Configuring Oracle 10g Application Server for IBM Cognos 8.4
This document give extra instructions to set up Oracle 10g against IBM Cognos 8.4 environment.
|
|
29 Sep 2009 |
|
| |
BEA WebLogic - Installing the Application Server
This document descibes how to setup and configure BEA Weblogic against IBM Cognos 8.4 BI.
|
|
29 Sep 2009 |
|
| |
Eliminating Interco Dividends using Automatic Journals
This document will provide guidelines to using automatic journals to eliminate intercompany dividends.
|
|
28 Sep 2009 |
|
| |
System Management Methodology
Documentation and resource files for System Management Methodology.
|
|
24 Sep 2009 |
|
| |
U2 Compact Framework
Rapidly evolving client needs are driving advances in information technology that are
making the world seem smaller and flatter.
One of the basic underlying requirements of these needs is
access to information anywhere, on any device, at any time.
The U2 UniObjects for .NET Compact Framework (UO.NETCF) library makes this
kind of access possible.
This article provides an example of how to take an existing PC-based application
that communicates with a U2 database, and use it as the
basis for developing a new mobile application using UO.NETCF.
|
|
24 Sep 2009 |
|
| |
Multi-row fetch support with type 2 connectivity in DB2 V9 for z/OS
Multi-row FETCH (MRF) can provide you with better performance than retrieving one row with
each FETCH statement.
This article explains what MRF is and how to use it.
The article also includes a sample Java program that illustrates how to set
MRF in an application.
For IBM Data Server Driver for JDBC and SQLJ type 2 connectivity on DB2 for z/OS,
multi-row FETCH can be used for forward-only cursors
and scrollable cursors.
For other types of connectivity, multi-row FETCH can be used
only for scrollable cursors.
|
|
17 Sep 2009 |
|
| |
Global Deployment Guide
Locale considerations for a IBM Cognos Series 7 deployment.
|
|
16 Sep 2009 |
|
| |
Developing a Web 2.0 application using the InfoSphere Business Glossary REST API
IBM InfoSphere Business Glossary enables users to create, manage, and share an enterprise vocabulary and classification system.
In version 8.1.1, the Business Glossary team introduced a REST API that makes
glossary content easier to consume by enabling the development of custom applications based on particular needs.
This article provides step-by-step instructions on how to develop a portable, dynamic
read-write widget that uses the IBM InfoSphere
Business Glossary REST API in conjunction with various Web 2.0 technologies.
The widget enables users to find terms, examine the term's details, and make basic edits.
Our goal is for InfoSphere Business Glossary customers to
use the knowledge gained through building this sample widget as inspiration
for using the REST API to create their own custom applications.
This article is intended for software engineers who are familiar with Web 2.0
technologies and product designers who can apply the tools provided here to real world situations.
|
|
10 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.
|
|
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 |
|
| |
IBM InfoSphere DataStage and DB2 pureXML, Part 2: Building an XML-enabled data warehouse
Learn how to integrate business-critical XML data into your data warehouse using IBM InfoSphere DataStage 8.1 and DB2 9.5 pureXML.
This two-part article series provides step-by-step instructions for using pureXML as both
a source and target data source for InfoSphere DataStage jobs.
|
|
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 |
|
| |
Understanding Unexpected Drill-Through Behavior in IBM Cognos 8
This document is intended as a reference guide for various IBM Cognos 8 BI drill-through scenarios in which the results may be unexpected.
|
|
02 Sep 2009 |
|
| |
Text Analysis in InfoSphere Warehouse, Part 3: Develop and integrate custom UIMA text analysis engines
In the first two articles of this series, you learned about IBM InfoSphere Warehouse text analysis capabilities,
how to use regular expressions and dictionaries to extract information from text, and how to publish the results with
a Cognos report.
This article describes how to use the Unstructured Information Management Architecture (UIMA) framework to create a custom
text annotator and use it in InfoSphere Warehouse.
The ability of InfoSphere Warehouse to use UIMA based annotators in analytic flows is a powerful feature.
You can write
custom annotators that can extract almost any information from text.
Plus you can use UIMA based annotators that are provided by IBM, other companies, and
many universities.
For example, you can find UIMA annotators that tokenize words and extract
concepts such as persons or sentiments.
|
|
27 Aug 2009 |
|
| |
New options for XML data integrity and validation in DB2 V9.5
DB2 introduced pureXML technology in Version 9. This technology allows you to store XML data in its native
form, maintaining the hierarchical structure and permitting you to query it using SQL/XML and XQuery. Just as with relational data, the ability to
ensure the integrity of XML data stored in DB2 is mandatory. The methods and mechanisms for ensuring the integrity of XML data, however, are a bit
different than the methods for traditional relational data integrity.
In this article, you'll learn about XML data integrity in the context of DB2, and explore the various options you have to guarantee integrity in
different scenarios.
|
|
27 Aug 2009 |
|
| |
DB2 9.7: Using PL/SQL anonymous blocks in DB2 9.7
IBM DB2(R) for Linux(R), UNIX(R), and Windows(R) 9.7 introduces support
for PL/SQL anonymous blocks: a feature that enables PL/SQL application
developers to test, troubleshoot, and prototype new procedural code, simulate
application runs, and dynamically build complex ad-hoc queries and reports.
This article describes the concept of anonymous blocks in DB2 9.7 and
illustrates the use of this feature using common database scenarios.
|
|
27 Aug 2009 |
|
| |
IBM Cognos 8 Go! Dashboard FP1 and FP2 Companion Guide
This document will help assist any installation issues that might occur while installing, configuring and using IBM Cognos 8 Go! Dashboard FP1 or IBM Cognos 8 Go! Dashboard FP2.
|
|
26 Aug 2009 |
|
| |
IBM InfoSphere DataStage and DB2 pureXML, Part 1: Integrate XML operational data into a data warehouse
Learn how to integrate business-critical XML data into your data
warehouse using IBM InfoSphere DataStage 8.1 and DB2 9.5 pureXML. This
two-part article series provides step-by-step instructions for using pureXML
as both a source and target data source for InfoSphere DataStage
jobs.
|
|
20 Aug 2009 |
|
| |
Developing with PL/SQL in IBM Data Studio 2.2 and Optim Development Studio 2.2
This article describes how you can use
IBM Data Studio 2.2 and
Optim Development Studio 2.2
to develop routines that use Oracle PL/SQL.
It shows you how to create, edit, deploy, and debug PL/SQL packages,
procedures, and functions for the following databases:
DB2 for Linux, UNIX, and Windows Version 9.7,
Oracle 10g, and Oracle 11g.
|
|
20 Aug 2009 |
|
| |
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.
|
|
20 Aug 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 |
|
| |
An IBM Mashup Center plug-in to convert HTML to XML
Learn how to build a plug-in for the IBM Mashup Center that can convert HTML into
XML, opening the door for some simple data extraction from HTML pages using the Feed Mashup Editor.
|
|
18 Aug 2009 |
|
| |
