Purchase your Section 508 Compliance Support guide now!

Purchase your Section 508 Compliance Support guide now!

IBM Cognos 8 job in San Diego

http://c8jobs.blogspot.com/2010/08/c8-job-in-san-diego.html

Cognos8 Help : Part 2 -- “IBM Cognos 8 Business Intelligence: The Official Gu...

Karl Malone has sent you a link to a blog:

Hey Dave, had you had a chance to review this book yet? I'm on Chapter 5 and it's helping me on my latest BI project. I have a few questions that might be better asked for IBM Cognos instead of the author.

Blog: Cognos8 Help
Post: Part 2 -- “IBM Cognos 8 Business Intelligence: The Official Guide” Introduction to Performance Management and IBM Cognos 8 BI
Link: http://cognos8help.blogspot.com/2010/08/part-2-ibm-cognos-8-business.html

--
Powered by Blogger
http://www.blogger.com/

Distributing Framework Manager Components

Distributing Framework Manager Components

Framework Manager can be installed on a computer that contains other IBM Cognos 8 reporting components or on a computer that is separate from other IBM Cognos 8 reporting components.

To publish packages so that they are available to users, you must configure the modeling tools to use a dispatcher, either directly or through a gateway. If IBM Cognos Connection is secured, you must have privileges to create data sources and publish packages in IBM Cognos Connection.The modeling tools communicate with server components using one of two methods:

Where you install Framework Manager, and how you configure it, can depend on how large your metadata models are and on which Web server you use.

Web Servers Other Than Microsoft IIS

For Web servers other than Microsoft Internet Information Services (IIS), no functional difference exists between the two communication routes between the modeling tool and the Application Tier Components dispatcher. For either route, the modeling tool uses the BI Bus SOAP API. If you use the Web server route, and you have medium- and large-sized packages (approaching 1 MB), the models are broken into smaller pieces (chunked) for transmission.

If you use a Web server other than Microsoft IIS, we recommend that you configure the modeling tool to communicate through your Web server gateway (using the first route). This eliminates the need to set up additional communications channels if you use firewalls to separate the modeling tool, Web server, and Application Tier Components.

Firewall Considerations

When the modeling tool is outside a network firewall that protects the Application Tier Components, communication issues with the dispatcher can occur. For security reasons, the default IBM Cognos 8 configuration prevents the dispatcher from accepting requests from the modeling tool when it is outside the network firewall.

Configuration Requirements

Framework Manager communicates with the Application Tier Components, which can be installed on one or more application servers. To publish packages, you must configure Framework Manager to communicate with the dispatcher, either directly or through a dedicated gateway.

You must ensure that Framework Manager can communicate with IBM Cognos 8 server components. On the computer where Framework Manager is installed, configure the following environment properties:

  • Gateway URI
  • Dispatcher URI for external applications

If the modeling tool is using a dedicated gateway instead of communicating directly with the dispatcher, you must also configure the Dispatcher URIs for gateway property on the dedicated gateway computer.

Cognos 8 on mobile devices such as blackberrys or iphones

Does anyone have any experience with developing Cognos 8 dashboards or reports for mobile devices such as Blackberrys or iPhones?  Email us at businessintelligencecentre@gmail.com in order to discuss futher.

Cognos 8 BI forLinux on System z

You can gain a lot of synergy by incorporating InfoSphere components with Cognos 8 BI for Linux on System z.

 

For example, you can define your business terms in InfoSphere Information Server Business

Glossary on Linux on System z, so that you can provide common terminology for both

business users and Cognos report developers. Once the terminology is defined, it is

extremely easy for any Cognos user to discover the definition of the term. The big benefit for

organizations is that it leads to trusted information by providing a means for everyone to use

common terminology when accessing or displaying the same piece of information. This

reduces complexity and misunderstanding.

 

If you use the InfoSphere Business Glossary from within Cognos 8 BI, you can access the

glossary from any of the following data objects in Report Studio:

_ Query subject

_ Query item

_ Measure

_ Dimension

_ Hierarchy

_ Level

_ Property/attribute

_ Top node member

_ Member

_ Level item

 

There is also synergy between the InfoSphere Warehouse on System z and Cognos 8 BI for

Linux on System z because you can have your Cognos reporting functions in close proximity

to the data that is being reported. This is really apparent when a report needs a large amount

of data because of the ability to use HiperSockets on the System z machine. HiperSockets

allows a 6 MBps connection between Cognos 8 BI for Linux on System z and the InfoSphere

Warehouse on System z.

In addition, by combining Cognos with WebSphere Portal, you can easily provide trusted

information through easy to create Web pages.

 

Other synergies between Cognos and InfoSphere include:

_ The IBM Smart Analytics System is a preconfigured and optimized system that provides

Business Intelligence Capabilities with Cognos 8 BI, Advanced Analytics with InfoSphere

Data Mining, and a scalable Data Warehouse platform with InfoSphere Warehouse.

_ InfoSphere Information Server can generate data lineage data based on DataStage jobs

that allow the analysis of data lineage using Metadata Workbench from source to target.

Cognos 8 BI has data lineage capabilities from report to data warehouse table/views. With

the integration, Cognos data lineage data can be imported into Information Server, which

allows data lineage from source to report.

_ InfoSphere Warehouse Cubing Services provides large scale OLAP capabilities inside the

data warehouse. Cognos can provide powerful analysis capabilities.

Identity Management for IBM Cognos 8 with IBM Tivoli Identity Manager

IBM Cognos 8 does not authenticate users itself but rather relies on third-party authentication providers such as LDAP or Microsoft Active Directory to do so. This concept means that IBM

Cognos 8 presents logon data (essentially credentials) entered by the user or obtained through single sign-on (SSO) mechanisms to the third-party authentication providers on behalf of the user. Then, when authenticated, IBM Cognos 8 must read the user's groups and roles from the authentication provider as well and make them available to the authorization functionality. This task is implemented by authentication providers.

 

After the users, groups, and roles are visible in the Cognos Connection, authorization policies can be created wherein a user can be assigned to a group or role depending on the business requirements.

 

The flow of an authentication request in Cognos 8

 

When a user requests authenticated access to IBM Cognos 8, the flow is as follows:

1. The user clicks a report or analysis to view it, and the request goes through the gateway and the dispatcher to the presentation service.

2. The gateway accepts the request and sends it to a dispatcher

3. The dispatcher notes that no passport is attached to the request, and sends the request to Content Manager.

4. Content Manager sends the request to Access Manager.

5. Anonymous access is disabled in this IBM Cognos 8 system, so Access Manager sends the request back to Content Manager with a fault attached. The fault contains information about what is needed to log on. For example, if multiple namespaces exist, the user will be required to select a namespace. If only one namespace exists, the user might be required to provide a user ID and password.

6. Content Manager returns the request with the attached fault to the dispatcher.

7. The dispatcher sends the request to the presentation service.

8. The presentation service creates the appropriate logon page for the user, and returns the page through the dispatcher and the gateway to the user.

9. The user enters the required information, such as a user ID and password. The information is attached to the original request and sent through the gateway to the dispatcher.

10.The dispatcher sends the request to Content Manager.

11.Content Manager sends the request to Access Manager.

12.Access Manager talks to the authentication provider through the Authentication Service to verify the supplied credentials. If all the required information is correct, Access Manager issues a Passport ID, attaches it in the HTTP header to the original request, and sends the request back to Content Manager. If the required information is incorrect or incomplete, the request faults back to step 9.

13.Content Manager sends the request to a dispatcher.

14.The dispatcher processes the request and sends it to the presentation service.

15.The presentation service sends the Welcome page back through the dispatcher and the gateway to the user.

 

Authorization and the CAMID

When a user is authenticated, the passport that is issued is the object that holds the visas. For each namespace, a visa is issued by the authentication provider after successful authentication has been established. In this case, the passport will hold a one-to-many numbers of visas. The Passport ID is the reference to the passport object, which is maintained, in memory, by the Content Manager component. The Passport ID is inserted in the cam_passport cookie, which is used to confirm that the user has successfully been authenticated in his or her current session before. Here, a user’s identity is established,

confirming access to the Cognos Portal content.

 

IBM Cognos 8 indicates which groups and roles the user is a member of, directly or indirectly, through inheritance (nested group memberships). This is true for groups and roles from the namespace for which the particular Passport ID has been issued, plus groups and roles from the Cognos namespace.

 

Authorization in IBM Cognos 8 applies to basically all objects that make up an IBM Cognos 8 application. All content (reports, analysis, folders, packages, and so on) and a wide range of functions and capabilities of systems can have permissions attached to them (for example, access to Studios). Permission defines who, a user, group or role, has what privileges on an object/capability/function.

 

The five privilege levels within IBM Cognos are:

_ READ

_ WRITE

_ EXECUTE

_ TRAVERSE

_ SET POLICY

 

Internally, those privilege levels do not contain the names of users, groups, or roles, but instead contain an internal ID named CAMID3. The CAMID is constructed by the authentication provider for each object read in from an external authentication provider. This also applies to the internal authentication provider, so all the objects of the Cognos namespace have a CAMID assigned to them. By the user of this CAMID, IBM Cognos stores and verifies access to objects, when authorization is necessary. The CAMID of objects in the user’s identity is compared to the permissions assigned to an object, and if they match, the

privileges are granted or denied. Although the CAMID is built differently among authentication providers, they all use a common layout. The CAMID layout is a string, consisting of two fields that are concatenated:

 

CAMID:="CAMID(<NamespaceID>:<AuthProviderSpecificID>)"

The NamespaceID is the ID that is specified in Cognos configuration for the namespace. The AuthProviderSpecificID is an ID that is constructed internally by the authentication provider.

 

Two examples are as follows:

 

_ Example 1, User:

CAMID("LDAP:u:uid=admin,cn=admin,ou=support")

 

Where:

LDAP is the NamespaceID

uid=admin, is the user Relative Distinguished Name (RDN®)

cn=admin, ou=support, is the Distinguished Name (DN)

 

_ Example 2, Group:

CAMID("LDAP:g:cn=admin,ou=support")

Where:

LDAP is the NamespaceID

cn=admin, ou=support, is the Distinguished Name (DN)

 

Leveraging Tivoli Identity Manager with Cognos 8

Cognos 8 supports various authentication providers, such as Microsoft Active Directory Server, LDAP, SAP, NT LAN Manager (NTLM), Cognos Series 7, and so on. These authentication providers store users, roles, and groups that can be used inside the Cognos environment while enabling the authentication mechanism. On the other side, the Tivoli Identity Manager supports most of such authentication providers as managed resources that it can manage. Tivoli Identity Manager provides capabilities of provisioning users and groups on most of the managed resources that Cognos uses as authentication providers. The

Microsoft Active Directory server, IBM Tivoli Directory Server, or Sun ONE Directory Server are examples of such authentication providers.

 

Leveraging Tivoli Identity Manager for managing users and groups on the authentication provider can deliver an ideal combination with the Cognos 8 security model. Further sections provide details about how Tivoli Identity Manager can be integrated with an authentication provider and leveraged with Cognos deployments.

 

Several key advantages for Cognos 8 when Tivoli Identity Manager is used with the Cognos authentication provider (or providers) are:

 

_ Tivoli Identity Manager provides a centralized, policy-driven and automated end to end provisioning solution. Administrators can use the Tivoli Identity Manager Web-interface to manage users and groups on multiple authentication providers and performing administrative tasks on it rather than directly operating on the authentication providers' individual user interfaces.

_ Tivoli Identity Manager allows provisioning policies that can be defined and customized as per the need. A provisioning policy can help to ensure an appropriate user getting provisioned with appropriate access rights.

_ Approval workflows and e-mail notifications can be configured with all user provisioning activities, such as creating a user account on the authentication provider, user requesting an access to certain groups, and so on.

_ Tivoli Identity Manager provides a self-care user interface that allows users to perform basic operations on their own without an administrator's involvement, such as resetting password, requesting access to groups, viewing and updating of personal information, and so on.

_ Tivoli Identity Manager provides the ability to certify and validate a user's access to IT resources on a regular interval. An administrator can define a recertification policy that recertifies user accounts as well as access rights defined on the authentication provider.

_ Auditing and reporting users and their access rights is one of the critical needs of most organizations. Tivoli Identity Manager's User and Access Reports can be leveraged to extend the existing Cognos auditing capabilities by providing auditing and reporting (traceability) of identity information of the authentication provider that accesses Cognos contents.

_ Provisioning users on the authentication provider, based on the organizational roles that are defined in Tivoli Identity Manager (advanced scenario), can provide a role-based access control mechanism and the following benefits:

– Role hierarchy helps to simplify and reduce the cost of user administration by enabling the use of an organizational role structure.

– Separation of duties can strengthen security and compliance by creating, modifying, or deleting policies that exclude users from membership to multiple roles that may present a business conflict.

Cognos 8 multi-tiered architecture diagram

View the BI Centre August 2010 Newsletter

Click here to view the BI Centre August 2010 Newsletter

Cognos8 Help : “IBM Cognos 8 Business Intelligence: The Official Guide” book ...

Karl Malone has sent you a link to a blog:

If you require an IBM Cognos 8 BI reference manual then you should read this book review of the book called IBM Cognos 8 Business Intelligence: The Official Guide.

Blog: Cognos8 Help
Post: “IBM Cognos 8 Business Intelligence: The Official Guide” book review
Link: http://cognos8help.blogspot.com/2010/08/ibm-cognos-8-business-intelligence.html

--
Powered by Blogger
http://www.blogger.com/

Part 6 -- “IBM Cognos 8 Business Intelligence: The Official Guide” Conclusion

Part 6 -- “IBM Cognos 8 Business Intelligence: The Official Guide” Conclusion

The “IBM Cognos 8 Business Intelligence: The Official Guide” walks you through an orientation of performance management and business intelligence fundamentals and then dives into practical examples where you can get hands on experience with using Cognos 8. The book isn’t one dimensional and only focusing on individual tools such as Framework Manager, Report Studio or Cognos Connection and then leaving you guessing how it all fits together. There are enough chapters that will provide you with enough detail if you are only interested in learning more about specific areas such as Analysis Studio, Cognos Administration or creating a drill down report.




If you’re like me and always get coffee spills, like to highlight key pages and throw it into your knapsack when leaving the office each day then you might want to consider buying a used copy from Amazon.com. They are normally 20-30% off of the listed price.

Once you buy your copy then I’d like to get your feedback on where the book can improve.

Happy reading!


Enter here for your chance to win a free copy of “IBM Cognos 8 Business Intelligence: The Official Guide”.

…read the previous post -- Part 5 -- “IBM Cognos 8 Business Intelligence: The Official Guide” Administration of IBM Cognos 8 Business Intelligence

Part 5 -- “IBM Cognos 8 Business Intelligence: The Official Guide” Administration of IBM Cognos 8 Business Intelligence

Part 5 -- “IBM Cognos 8 Business Intelligence: The Official Guide” Administration of IBM Cognos 8 Business Intelligence

I personally lvoe building Framework Manager models so I enjoyed Chapter 15’s explanation of how to build a Framework Manager model from the beginning. Framework Manager can be one of the scary areas for new BI developers since it’s the foundation for your models, reports and deployment packages. Any doubt here will cascade its way through, so a review of this section of the book is highly recommended.




Here’s a tip on how to clear the MRU list that I could have used at my last client site.

1. Navigate to: \c8\configuration\bmt.ini
2. Open the file in Notepad
3. Remove the references to the unwanted projects
4. Save the file with UTF-8 encoding

The book shows you how to publish your model and then apply a security model that protects your data. More advanced Framework Manager techniques are discussed such as building a measure dimension within Framework Manager and how to manage projects within a multi-user developer environment.

In large organizations the administrative features of IBM Cognos 8 are managed by a central group, whereas in smaller organizations your report developer is also you Cognos admin. Either way Chapter 18 gives you clear direction on the administrative tasks that are typically required for your Cognos 8 installation.

…continued in Part 6 -- “IBM Cognos 8 Business Intelligence: The Official Guide” Conclusion

…read the previous post -- Part 4 -- “IBM Cognos 8 Business Intelligence: The Official Guide” Authoring IBM Cognos 8 Business Intelligence Content

Part 4 -- “IBM Cognos 8 Business Intelligence: The Official Guide” Authoring IBM Cognos 8 Business Intelligence Content

Part 4 -- “IBM Cognos 8 Business Intelligence: The Official Guide” Authoring IBM Cognos 8 Business Intelligence Content


This section of the book includes chapters that cover self-service query authoring, advanced reporting techniques, Analysis Studio, Scorecards and Metrics, and Event Management.



If your job function is as a Cognos report developer then you’ll love this section of the book.

The book walks a user through creating a query within Query Studio and generating a filtered report. It then moves onto more advanced reporting techniques by adding calculations, layouts, drill downs, prompts and query management using Report Studio.

The Go Data Warehouse is used as the basis for learning Analysis Studio in this section. A review of dimensions and measures is provided to help you create your own report. The ever present Time Dimension is covered as the book continues into more advanced reporting techniques.

Creating a metric from a dimensional source is illustrated by the GO METRICS package. Metric Studio is taught to us by a concise example of adding metrics to a scorecards within Metric Studio on page 403.

Event Management are covered in Chapter 14 and we are given several examples of using Event Management for day-to-day operations such as Modify a Task on page 434.


…continued in Part 5 -- “IBM Cognos 8 Business Intelligence: The Official Guide” Administration of IBM Cognos 8 Business Intelligence

…read the previous post -- Part 3 -- “IBM Cognos 8 Business Intelligence: The Official Guide” Accessing and Using IBM Cognos 8 Business Intelligence

Part 3 -- “IBM Cognos 8 Business Intelligence: The Official Guide” Accessing and Using IBM Cognos 8 Business Intelligence

Part 3 -- “IBM Cognos 8 Business Intelligence: The Official Guide” Accessing and Using IBM Cognos 8 Business Intelligence




This section includes chapters that cover Cognos Connection, Cognos 8 Go ! Office, Cognos 8 Go ! Search, and Cognos 8 Go ! Mobile and an overview of IBM Cognos 8 BI Consumer modes.

Cognos Connection is a web based portal that allows users to run reports, queries, metrics, and analyses; perform administrative functions; and access other Cognos 8 content. The book walks you through how to provide customization to Cognos Connection, create portlets, add alerts, and how to utilize Cognos Connection’s features.

The book discusses using IBM Cognos 8 Go ! Office and provides a clear example of how to connect to Microsoft Office. A walkthrough of using BI Analytics within Microsoft Excel has us using the Sales and Marketing MDC in order to illustrate how to create a drill down report in Microsoft Excel on page 140.


…continued in Part 4 -- “IBM Cognos 8 Business Intelligence: The Official Guide” Authoring IBM Cognos 8 Business Intelligence Content

…read the previous post -- Part 2 -- “IBM Cognos 8 Business Intelligence: The Official Guide” Introduction to Performance Management and IBM Cognos 8 BI

Part 2 -- “IBM Cognos 8 Business Intelligence: The Official Guide” Introduction to Performance Management and IBM Cognos 8 BI

This section includes chapters that cover Performance Management, an overview of the IBM Cognos 8 BI studios and roles, and Cognos 8 Planning.



Performance Management helps you to align the disparate business aspects to create a single representation to empower an organization. The book discusses the differences between: measuring & reporting; reporting & analysis; planning, budgeting, & forecasting. The How?, What?, and Why? Can all be mapped to the IBM Cognos 8 BI software that enables and automates answers.

Aligning business and technical objectives will help to enable an organization gain greater insight to their performance. It will help to create a sustainable model for moving forward with your organization’s objectives.

Dashboards are created using Report Studio, whereas Scorecards are created using Metric Studio. The book helps to clarify their usage and benefits for understanding their data.

When you implement your IBM Cognos 8 BI application you must keep users’ needs in mind. The book provides clear definitions for the primary roles and abilities for each within the IBM Cognos 8 BI studios.

The IBM Cognos 8 Planning application is a powerful tool for streamlining the planning, budgeting, and forecasting processes. The book provides a visual example of setting up the Framework Manager model extension wizard for Cognos 8 Planning on page 48.


…continued in Part 3 -- “IBM Cognos 8 Business Intelligence: The Official Guide” Accessing and Using IBM Cognos 8 Business Intelligence

…read the previous post -- Part 1 – “IBM Cognos 8 Business Intelligence: The Official Guide” book review contents at a glance

Part 1 – “IBM Cognos 8 Business Intelligence: The Official Guide” book review contents at a glance

Part 1 – “IBM Cognos 8 Business Intelligence: The Official Guide” book review contents at a glance



The best Section of IBM Cognos 8 Business Intelligence: The Official Guide Book is that it covers all aspects of Cognos 8 BI in four distinct sections.

•Section 1 – Introduction to Performance Management and IBM Cognos 8 BI
•Section 2 – Accessing and Using IBM Cognos 8 Business Intelligence
•Section 3 – Authoring IBM Cognos 8 Business Intelligence Content
•Section 4 – Administration of IBM Cognos 8 Business Intelligence

Each section is broken down into several chapters that provide clear descriptions and working examples to guide you throughout the usage of your Cognos 8 BI software.

The author has intentionally organized the book a little differently than other technical books that you may have read. The book begins with providing an introduction to IBM Cognos 8 and the definitions of performance management and business intelligence so that a reader acquires or refreshes their understanding of the subjects before moving into more subject detailed chapters. Cognos 8 BI functionality is defined by user roles, and as such, those roles increase in technical depth and functionality. The book allows the reader to expand upon examples as they gain more knowledge along the way.

If you’re a seasoned BI veteran then consider it a refresher and skip right to the nitty gritty of using the tools. The book is setup so that you can skip chapters and focus on your primary areas of interest.

…continued in Part 2 -- “IBM Cognos 8 Business Intelligence: The Official Guide” Introduction to Performance Management and IBM Cognos 8 BI

…read the previous post -- “IBM Cognos 8 Business Intelligence: The Official Guide Book Review”

“IBM Cognos 8 Business Intelligence: The Official Guide” book review

“IBM Cognos 8 Business Intelligence: The Official Guide” book review



If you are a new or even an experienced IBM Cognos 8 user, then you will benefit from reading the IBM Cognos 8 Business Intelligence: The Official Guide Book. One of the problems that I always found with specializing in Business Intelligence is the lack of training resources available. Onsite classroom training exists but most of us are unable to handle both the course costs and travel expenses. It typically forces us to teach ourselves or browse through outdated project documentation in hopes of gaining more knowledge.

I’ll be posting a series of blogs that will provide a review of IBM Cognos 8 Business Intelligence: The Official Guide Book and show you that it’s a valuable desktop resource for anyone using Cognos 8. The book covers both the business and technical aspect of using IBM Cognos 8 BI software and is packed with examples accompanied with visual illustrations. If you’re an old MS Access dude that loved Northwinds then you’ll be glad to see references to Go Sales in the examples.

…continued in Part 1 – “IBM Cognos 8 Business Intelligence: The Official Guide” book review contents at a glance

Example - Add a Multimedia File to a Cognos 8 BI Report

Example - Add a Multimedia File to a Cognos 8 BI Report

You are a report author at The Great Outdoors Company, which sells sporting equipment. You want to insert a Windows Media Audio/Video file named GO.wmv in a template that serves as a cover page for all reports.

You must have Windows Media Player installed on your computer.
Steps

1.

Open Report Studio with the GO Data Warehouse (query) package.
2.

In the Welcome dialog box, click Create a new report or template and in the New dialog box, click Blank.
3.

In the Insertable Objects pane, on the Toolbox tab, drag the HTML Item object to the report.
4.

Select the HTML Item.
5.

In the Properties pane, double-click the HTML property.
6.

In the HTML dialog box, type the following:



When you run the report in HTML format, the multimedia file plays in Windows Media Player.

August 2010 BI Centre Newsletter

Click here to view the latest Cognos BI Centre Newsletter

The BI Centre August 2010 Newsletter iis available now

Hello everyone,

The August 2010 edition of the BI Centre newsletter is available now.  Click here.

Thank you.
--
BI CENTRE
http://bicentre.blogspot.com


Island Home For Sale

Cognos 8 Go!Office

After an upgrade from IBM Go!Office 8.2 to IBM Go!Office 8.4.1 and an upgrade from Microsoft Office XP to Microsoft Office 2007, the IBM Cognos 8 pane did not show the links for the functions "Search", "Import content" and "View report". The related icons were shown correctly.

 

Symptom

In the IBM Cognos 8 pane of IBM Go!Office 8.4.1 the following three links were not available:

  • Search
  • Import content
  • View report


Only the three related icons were displayed. See the screenshot below:

 

 

Cause

This was due to an 3rd party add-on (customer coded add-on) that was also installed in Microsoft Office 2007.

 

 

Resolving the problem

Uninstall or deactivate the 3rd party add-on (customer coded add-on).