IBM Cognos Express Webminar

Join unveil IBM Cognos Express – the first and only integrated, one-stop BI and planning solution purpose-built and priced for midsize companies.
http://www-01.ibm.com/software/data/cognos/cognos-express/index.html?mc=-eb_ibm_hp
Thanks and regards
Abhishek

IBM Cognos Express Webminar

Join unveil IBM Cognos Express – the first and only integrated, one-stop BI and planning solution purpose-built and priced for midsize companies.
http://www-01.ibm.com/software/data/cognos/cognos-express/index.html?mc=-eb_ibm_hp
Thanks and regards
Abhishek

Load Balancing In Cognos 8

Automatic Load Balancing

In a distributed environment, Cognos 8 balances request load automatically. By default, as servers are added to the system, each server dispatcher processes the same number of requests. If there is more than one instance of a given service, the dispatcher distributes requests to all the enabled instances of the service that are registered in Content Manager.

Load Balancing Dispatchers

Without a software or hardware load balancing mechanism, each Cognos 8 gateway is aware of
only one dispatcher, and distributes all requests to that dispatcher. The dispatcher then distributes the requests among Cognos 8 servers. Because every request initially goes through the same dispatcher on one server, the load on that server is increased. An extra step is needed to automatically balance the load, as shown in the following diagram.

Load Balancing Without an External Mechanism

Since gateway servers often have less load than Cognos 8 servers, you may achieve better performance by configuring dispatchers together with the gateways, as shown in the following diagram.

This ensures that the processing capacity of the Cognos 8 servers is directed toward serving report requests rather than load balancing requests.

You can also achieve load balancing by having gateways direct all traffic to a Cognos 8 server
computer that is dedicated to dispatching, as shown in the following diagram.

This configuration also removes dispatching load from the Cognos 8 servers. However, it does
require separate dispatching computers.

How to use Pass Through SQL in Report Studio

If you place curly braces ({}) around your SQL statement in a Tabular SQL object, that SQL statment will be sent directly to the database. Note that no validity checking is done on the SQL, so the report author is fully responsible for the correct operation of the SQL statement.
Steps:
Create a Tabular SQL object.
Write you SQL statement. Ensure that it is surround by curly braces. For example, if your SQL statement isSELECT * FROM ORDER_HEADERyou need to write it as:
{SELECT * FROM ORDER_HEADER}

Cognos 8 Cubes Information

Web Portals
The IBM Cognos 8 Web portal is IBM Cognos Connection. IBM Cognos Connection replaces
Upfront and the PowerPlay Table of Contents as the portal for accessing PowerPlay reports.

IBM Cognos Administration also allows you to run the Migration Assistant to move your IBM
Cognos Series 7 PowerPlay content to IBM Cognos 8 PowerPlay.

Data Sources

IBM Cognos 8 uses data sources contained in packages. Connections to the data sources are
maintained in IBM Cognos Administration.
For IBM Cognos 8 PowerPlay, a package contains a data source connection to a PowerCube. When you publish a PowerCube, that is, when you create a data source connection to a PowerCube, you can optionally create a package for the cube. PowerPlay users can then build reports from that cube by using the package.

IBM Cognos 8 Transformer allows you to create cubes and to publish them to
IBM Cognos Connection for use in Cognos 8 studios.

All IBM Cognos 8 studio users access data from published packages. PowerPlay accesses data only from packages that use PowerCubes as data sources. Other IBM Cognos 8 studios can access data from packages that use different types of data sources, including PowerCubes.
IBM Cognos 8 PowerPlay Studio and IBM Cognos 8 PowerPlay Client do not support data source
connections to OLAP data sources other than PowerCubes, nor do they support compressed
PowerCubes.

Security

IBM Cognos 8 can use your existing IBM Cognos Series 7 namespace, however, you will need to
continue using IBM Cognos Series 7 Access Manager to administer the namespace.

Security information in your PowerPlay content will be maintained when you migrate to IBM
Cognos 8. Only users and user classes referenced in NewsBoxes and NewsItems being migrated are migrated. Password protected cubes will remain password protected. If you use user class security in your cubes, the security is maintained and you must continue to use your IBM Cognos Series 7 namespace in your IBM Cognos 8 environment.

In IBM Cognos 8 PowerPlay, you cannot access a cube password that is stored in IBM Cognos
Series 7 Access Manager. An administrator must add the cube password to the data source signon when they create the data source connection in IBM Cognos Administration. Also, you cannot open local cubes that are secured against a namespace using IBM Cognos 8 PowerPlay Client. As an alternative, you can use password protected local cubes.

Request Flow

In IBM Cognos Series 7, incoming requests are sent from the gateway to the PowerPlay server and from the PowerPlay server to a query processor. In the default configuration, the query processor sends the response directly to the gateway, bypassing the PowerPlay server. To do this, the gateway listens for connections on a server socket and the query processor opens a socket connection back to the gateway. This requires open outbound ports in firewalls between the Web tier and the Application Tier Components. In IBM Cognos 8, responses always travel back through the same socket connections that the request arrived on. This is the same as enabling the restrict outgoing port configuration option in IBM Cognos Series 7.

The Migration Service

Migration is a service in the IBM Cognos 8 service-oriented architecture. The migration service
migrates PowerPlay content from IBM Cognos Series 7 to IBM Cognos 8 PowerPlay. The migration service also migrates PowerPlay reports to an IBM Cognos 8 report specification when a user opens the report in Report Studio or Analysis Studio.

Note: There are two migration services; one is an IBM Cognos Series 7 service and one is an IBM Cognos 8 service. Both services must be started before you can migrate your content. The IBM Cognos Series 7 Migration service is started from the Windows Services manager or on UNIX using the command ./configure.sh --start. The IBM Cognos 8 migration service is run by the IBM Cognos 8 dispatcher and is automatically started when you start the IBM Cognos 8 service.

Replacing or Updating Cubes

If you are using IBM Cognos 8 Transformer version 8.4, you can update PowerCubes using new
deployment features without having to restart services, disable cubes, or use scripts. If you are using IBM Cognos Series 7 PowerCubes in IBM Cognos 8, you can also take advantage of new deployment features using a utility named pcactivate.

Types of SQL generated by Cognos 8

Cognos SQL:
Generic representation of a Query.
More verbose than native sql
Formatted for readability and comprehension and generated by CQE
Native SQL:
Designed to use the database optimizers.
Leverages features of databases wherever possible.
We cant use Native SQL in a Query subject that references more than one data source query subjects
Pass-through SQL:
Use When a database vendor does not extend support for a particular construct in a sub-query.
Cognos 8 will pass anything you type directly to the database.
With Pass-through SQL what ever you type is passed to the Data base processing with out the intervention of the Cognos 8 Query Engine

CAFE (Cognos Analysis for Excel) Basic

Just wanted to share a video about the integration of Cognos8 with Excel.