CREATING CUBES USING COGNOS POWERPLAY

Step 1: Start->Programs->Cognos8(Frame Work Manager) ->Frame work manager
Step 2:Create new project-> Press ok
Step 3: Select the design language for the project
Step 4: Select Metadata Source->Next
Step 5: Select data source from the list or create new data source->Next
Step 6: Select the object according to the requirement->Next
Step 7: Generate the relationship->Import
Step 8: Finish the process->Finish
Step 10: Publish the package
Step 11: Open transformer, go to file_New_Model name (User defined)->Next
Step 12: New data source (DHW name), Source type name (Select cognos package)->Next
Step 13: package name  (browse the package)->Next
Step 14: Check the auto design check box, click finish database.
Step 15: Right click on Dim map->choose Insert Dimension-> Write the dimension name
Step 16: Right click on Customer1-> Select insert level->Click on Source-> click on more->select Customer_id->click ok
Step 17: Right click on power cube-> Select Insert power cube-> Define cube name->Ok
Step 18: Right click on the cube & select create selected power cube
Step 19: Processing the Cube
Step 20: A new model will be genrated with Dimension map, data source, measure, power cube,singons.Data Sources Measures Cube
step 21: From the generated cube you can create whatever reports you need.

Business Intelligence (BI) tools list

1.	Oracle Enterprise BI Server
2.	Business Objects Enterprise
3.	SAP NetWeaver BI
4.	SAS Enterprise BI Server
5.	IBM Cognos TM/1 & Executive Viewer
6.	BizzScore Suite
7.	WebFocus
8.	Excel, Performance Point, Analysis Server
9.	QlikView
10.	Microstrategy
11.	Hyperion System
12.	Actuate
13.	IBM Cognos Series 8

source
www.businessintelligencetoolbox.com

Cognos DecisionStream architecture

Cognos DecisionStream is a powerful ETL tool, comprised of a DecisionStream designer graphical design environment and an ETL engine acting as a server.
The Cognos Decision Stream designer is a graphical tool for implementing the ETL process. It lets users map data sources into data streams, define transformations of the data, organize facts and dimensions into a star or snowflake schema, etc.

The DecisionStream designer comprises of the following components shown below:

Dimension library

Dimension library browser with many dimensional templates. DecisionStream provides templates for managing surrogate keys and slowly changing dimensions (SCD).

Dimension and Fact builds

Dimensions and facts builds are defined by ETL developers, a module used for managing the ETL process

Visual design environment

ETL process designer which lets developers design a flow. The visual designer provides the main four views to manage the ETL process:
- Marketing perspective
- Data Stream
- Transformation Model

- Fact Delivery

Informatica Interview Questions

Over 500 interview questions related to Informatica and its Data Warehousing solutions. Reading those questions and answers should not be considered only as a preparation for an interview but also as a good source of information and tutorial which help learn

 http://www.geekinterview.com/Interview-Questions/Data-Warehouse/Informatica

Informatica Developer Network

The Informatica Developer Network (IDN) is a program designed to help software developers expand the business value of Informatica's data integration platform and data quality products through the development of innovative and compelling third-party

http://devnet.informatica.com/

Data Warehouse and Informatica ETL Tutorial

DWHlabs portal is exclusively designed for Data warhouse developers. Most of the content relates to data warehousing and ETL products with main emphasis on Informatica. The site provides a good Informatica ETL tutorial for beginners which covers such topics

http://www.dwhlabs.com/

Cognos PowerPlay Tutorial

Cognos PowerPlay Transformer technical tutorial with examples, sample solutions and a guide to develop data warehouse models in Cognos. The tutorial is aligned to a typical business scenario to facilitate the learning process. It is addressed to data

http://www.cognos-bi.info/tutorial.html

Cognos Analysis Studio quick tour

The Analysis Studio Quick Tour teaches the basic skills needed to analyze business results. The tutorial shows how to: Insert data into an empty crosstab, nest, replace, sort data in a cube Explore data by changing

http://cogpubbkp.cabq.gov/cognos8/documentation/en/tours/pshome.html

List of ETL tools

ETL tools are widely used for extracting, cleaning, transforming and loading data from different systems, often into a data warehouse. The following ETL tools were thoroughly examined on 80 criteria considered important for attaining high productivity Business Intelligence systems that actually add value to your organization. In random order.

1.	Oracle Warehouse Builder (OWB)	11gR1	Oracle
2.	Data Integrator & Services	XI 3.0	Business Objects, SAP
3.	IBM Information Server (Datastage)	8.1	IBM
4.	SAS Data Integration Studio	4.2	SAS Institute
5.	PowerCenter	8.5.1	Informatica
6.	Elixir Repertoire	7.2.2	Elixir
7.	Data Migrator	7.6	Information Builders
8.	SQL Server Integration Services	10	Microsoft
9.	Talend Open Studio	3.1	Talend
10.	DataFlow Manager	6.5	Pitney Bowes Business Insight
11.	Data Integrator	8.12	Pervasive
12.	Transformation Server	5.4	IBM DataMirror
13.	Transformation Manager	5.2.2	ETL Solutions Ltd.
14.	Data Manager/Decision Stream	8.2	IBM Cognos
15.	Clover ETL	2.5.2	Javlin
16.	ETL4ALL	4.2	IKAN
17.	DB2 Warehouse Edition	9.1	IBM
18.	Pentaho Data Integration	3.0	Pentaho
19	Adeptia Integration Server	4.9	Adepti

source
http://www.etltool.com/etltoolslist.htm

Enabling cognos security

Cognos 8 components run with two levels of logon: anonymous and authenticated. By default,anonymous access is enabled .You can use both types of logon with your installation. If you choose to use only authenticated logon, you can disable anonymous access .For authenticated logon , you must configure Cognos 8 components with an appropriate namespace for the type of authentication provider in your environment. You can configure multiple namespaces for authentication and then choose at run time which namespace you want to use. Cognos 8 components support the following types of servers as authentication sources:

● Active Directory Server

● Cognos Series 7

● Custom Authentication Provider

● LDAP

● eTrust SiteMinder

● NTLM

● SAP.

      After you configure an authentication provider for Cognos 8 components, you can enable single signon between your authentication provider environment and Cognos 8 components. This means that a user logs on once and can then switch to another application without being asked to log on again.

To use an authentication provider

Disable Anonymous Access

By default, Cognos 8 components do not require user authentication. Users can log on anonymously.If you want to use authenticated logon only, you can use Cognos Configuration to disable anonymous access.

Steps

1. On each Content Manager computer, start Cognos Configuration.

2. In the Explorer window, under Security, Authentication, click Cognos.The Cognos resource represents the Cognos namespace. The Cognos namespace stores information about Cognos groups, such as the Anonymous User, contacts, and distribution

3. In the Properties window, click the box next to the Allow anonymous access property and then click False.

4. From the File menu, click Save. Now, users are required to provide logon credentials when they access Cognos resources.

Restrict User Access to the Cognos Namespace

Access can be restricted to users belonging to any group or role defined in the Cognos built-in

namespace. By default, all users belong to several built-in groups or roles. To restrict access, you

must:

● enable the property to restrict access

● remove the Everyone group from the Cognos built-in roles and groups

● ensure that authorized users belong to at least one Cognos role or group

Steps

1. On each Content Manager computer, start Cognos Configuration.

2. In the Explorer window, under Security, click Authentication.

3. In the Properties window, change the value of Restrict access to members of the built-in

namespace to True.

4. From the File menu, click Save.

You must now use the portal to remove the Everyone group from the Cognos built-in roles and

groups and then ensure that authorized users belong to at least one Cognos built-in role or group.

For information about adding or removing members of a Cognos group or role.

Configuring Cognos 8 Components to Use Active Directory Server

If you install Content Manager on a Windows computer, you can configure Active Directory as your authentication source using an Active Directory namespace.If you install Content Manager on a UNIX computer, you must instead use an LDAP namespace to configure Active Directory as your authentication source. If you install Content Manager on Windows and UNIX computers, you must use an LDAP namespace to configure Active Directory on all Content Manager computers. When you use an LDAP namespace to authenticate against Active Directory Server, you are limited to LDAP features only. By default, Active Directory Server uses port 389.

To use an Active Directory Server namespace and to set up single signon, do the following:

 Configure Cognos 8 components to use an Active Directory Server namespace

 Enable secure communication to the Active Directory Server, if required

 Enable single signon between Active Directory Server and Cognos 8 components

Configure an Active Directory Namespace

You can use Active Directory Server as your authentication provider. You also have the option of making custom user properties from the Active Directory Server available to Cognos 8 components. For Cognos 8 to work properly with Active Directory Server, you must ensure that the Authenticated users group has Read privileges for the Active Directory folder where users are stored.

Steps

1. On every computer where you installed Content Manager, open Cognos Configuration.

2. In the Explorer window, under Security, right-click Authentication, and then click New resource,Namespace.

3. In the Name box, type a name for your authentication namespace.

4. In the Type list, click the appropriate namespace and then click OK. The new authentication provider resource appears in the Explorer window, under the Authentication component.

5. In the Properties window, for the Namespace ID property, specify a unique identifier for the

namespace.

6. Specify the values for all other required properties to ensure that Cognos 8 components can

locate and use your existing authentication provider.

7. Specify the values for the Host and port property. To support Active Directory Server failover, you can specify the domain name instead of a specific domain controller. For example, use mydomain.com:389 instead of dc1.mydomain. com:389.

8. If you want to be able to search for details when authentication fails, specify the user ID and

password for the Binding credentials property.Use the credentials of an Active Directory Server user who has search and read privileges for that server.

9. From the File menu, click Save.

10. Test the connection to a new namespace. In the Explorer window, under Authentication,

right-click the new authentication resource and click Test.Cognos 8 loads, initializes, and configures the provider libraries for the namespace.

Make Custom User Properties for Active Directory Available to Cognos 8 Components

You can use arbitrary user attributes from your Active Directory Server in Cognos 8 components.

To configure this, you must add these attributes as custom properties for the Active Directory

namespace.The custom properties are available as session parameters through Framework Manager. For more information about session parameters, see the Framework Manager User Guide The custom properties can also be used inside command blocks that are used to configure Oracle sessions and connections. The command blocks can be used with Oracle light-weight connections and virtual private databases.

Steps

1. On every computer where you installed Content Manager, open Cognos Configuration.

2. In the Explorer window, under Security, Authentication, click the Active Directory namespace.

3. In the Properties window, click in the Value column for Custom properties and click the edit

button.

4. In the Value - Custom properties window, click Add.

5. Click the Name column and enter the name you want Cognos 8 components to use for the session parameter.

6. Click the Value column and enter the name of the account parameter in your Active Directory

Server.

7. Repeat steps 4 to 6 for each custom parameter.

8. Click OK.

9. From the File menu, click Save.

Enabling Secure Communication to the Active Directory Server

If you are using an SSL connection to the Active Directory Server, you must copy the certificate

from the Active Directory Server to the Content Manager computer.

Steps

1. On every Content Manager computer, use your Web browser to connect to the Active Directory

Server and copy the CA root certificate to a location on the Content Manager computer.

2. Add the CA root certificate to the certificate store of the account that you are using for the current Cognos session:

● If you are running the Cognos session under a user account, use the same Web browser as

in step 1 to import the CA root certificate to the certificate store for your user account.

For information, see the documentation for your Web browser.

● If you are running the Cognos session under the local computer account, use Microsoft Management Console (MMC) to import the CA root certificate to the certificate store for the local computer.

3. In Cognos Configuration, restart the service:

● In the Explorer window, click Cognos 8 service, Cognos 8.

● From the Actions menu, click Restart.

Include or Exclude Domains Using Advanced Properties

When you configure an authentication namespace for Cognos 8, users from only one domain can log in. By using the Advanced properties for Active Directory Server, users from related (parent-child) domains and unrelated domain trees within the same forest can also log in.

Authentication in One Domain Tree

If you set a parameter named chaseReferrals to true, users in the original authenticated domain and all child domains of the domain tree can log in to Cognos 8. Users above the original authenticated domain or in a different domain tree cannot log in.

Authentication in All Domain Trees in the Forest

If you set a parameter named MultiDomainTrees to true, users in all domain trees in the forest can

log in to Cognos 8.

Steps

1. On every computer where you installed Content Manager, open Cognos Configuration.

2. In the Explorer window, under Security, Authentication, click the Active Directory namespace.

3. In the Properties window, specify the Host and port property:

● For users in one domain, specify the host and port of a domain controller for the single

domain.

● For users in one domain tree, specify the host and port of the top-level controller for the

domain tree.

● For users in all domain trees in the forest, specify the host and port of any domain controller

in the forest.

4. Click in the Value column for Advanced properties and click the edit button.

5. In the Value - Advanced properties window, click Add.

6. Specify two new properties, chaseReferrals and MultiDomainTrees, with the following values:

Authentication for chaseReferrals MultiDomainTrees

One domain False False

One domain tree True False

All domain trees in the forest True True

7. Click OK.

8. From the File menu, click Save.

Cognos BI

The main objective of Business Intelligence is to bring the right information at the right time. Usually, the data is pulled from several sources and transformed into accurate and consistent information which is stored in the Data Warehouse.

Cognos Business Intelligence solutions help understand, monitor and manage business performance which includes business reporting & analysis, profitability measurement, budgeting, forecasting optimization and cost management.

Cognos is a fast and efficient technique to deliver multidimensional business intelligence data.Building a Data Warehouse and a complete and well performing Information Management system in an organization is a challenge both for the business and technical experts. The most important thing to have in mind is that Business Intelligence is not an IT driven area and it needs to come out as a need from the business and require tight and constant cooperation.That is why in order to deliver valuable information to the business and perform efficiently it is required to understand end-users needs and cooperate closely with the business before implementing Cognos applications.