envisn on twitter envisn on linkedin envisn on facebook envisn on google+ youtube feed for envisn cognos blog




free ebook: download the content store survival guide newly revised

Envisn's IBM Cognos Blog

Current Articles | RSS Feed RSS Feed

Using IBM Cognos 10 Audit Extensions

  
  
  
  
magnifying glass looking at data

March 31, 2014, by Paul Hausser, Envisn, Inc.
Released with the introduction of Cognos 10.1, IBM Cognos 10 Audit Extension was designed to fill in the cracks of audit coverage beyond the standard audit table coverage. Its purpose is to provide coverage of Cognos auditing into areas that customers have been asking for such as user data and capability assignments. Users have had difficulty complying with their licensing limits if they cannot track these on a day to day basis.

 


What’s Wrong with IBM Cognos Audit Data

  
  
  
  
data 1s and 0s

February 28, 2014, by Paul Hausser, Envisn, Inc.
The title of this article has to be taken in the context of how Cognos administrators would like to use Cognos audit data. Many would like to be able to use the activity data in multiple ways to better manage their environment and know what’s of value to their users as measured by actual usage. So our focus here is on understanding what’s available out of the box and as compared to the ultimate vision of what may be possible.

 


Is Cognos PowerPlay Dead?

  
  
  
  
cognos powerplay

January 30, 2014, by Paul Hausser, Envisn, Inc.
Introduced in 1990, Cognos PowerPlay set a new standard in terms of both ease of use and power in decision support technology. It quickly became the leading product in the OLAP market and helped make Cognos a leader in solutions that empower the user. Analysts credit PowerPlay and tools like it as having significantly broadened the market by bringing decision support tools into all levels of the organization. Users finally had the ability to align data with the questions they needed answers to.

Eight years after its introduction PowerPlay Web came along and it became one of Cognos’ most popular products ever.


IOD 2013 - What’s New in Cognos 10

  
  
  
  
10 painted on wood

November 27, 2013, by Paul Hausser, Envisn, Inc.
In the three years since the introduction of Cognos 10 IBM Cognos has introduced a number of new things for the product including Dynamic Cubes, Cognos Cloud, Cognos Workspace and performance increases. One wonders at this point what it will take to move to whatever comes after Cognos 10. There was no obvious answer to that question as IOD 2013 came to a close but there were still a lot new things there to look at.

Major Things

Four main categories of enhancements in the latest release of Cognos 10 (ver.10.2.1.1):


The Ultimate Cognos Answer Machine

  
  
  
  
flying machine

October 29, 2013, By Rick Ryan, Envisn, Inc.
Our NetVisn product was designed to go broad and deep in terms of providing Cognos administrators and developers with the ability to manage key tasks and get answers to all of their questions, quickly and easily. Among its broad list of features are powerful analytics that cover everything from database and package dependencies to all dimensions of security and get what you want organized the way you need to use it.

The Challenge

But as good as these are there are still some things people want to know that we’ve never heard users ask for before. So for these we have created what we call custom queries that enable the user to get exactly what they need. Some of the ones on the growing list include:


Cognos Security – When is it Time to Start Over?

  
  
  
  
graphic of digital padlock representing cognos security

September 30, 2013, by Paul Hausser, Envisn, Inc.
Cognos security is a key foundation of every successful Cognos BI environment. And while no environment likely ever fails because of security, unless it’s from a major breach, administrators frequently get to the point where the security model they have in place just isn’t working. This article is focused on some of the things Cognos administrators encounter that tell them they probably need to start over with security. Some of these are:

  1. The Cognos namespace is at odds with the external namespace, typically Active Directory or LDAP. The Cognos namespace may have been initially been based on the external namespace which is a good practice whenever it can be done. But over time they may have begun to diverge from each other making it difficult to leverage the external namespace structure in the Cognos namespace. Does this mean you cannot have a different structure between the two namespaces? Not at all. But it’s more efficient and easier to maintain the Cognos namespace over time if it’s able to leverage the external namespace. As they become more dissimilar over time it’s likely to be more difficult to manage Cognos security.
    The Cognos security model needs to be able to manage both growth and change over time and if it cannot do this effectively you may need to create a new one.
  2. The distinction between groups and roles has become muddled. Organizing members into groups and roles within Cognos is probably the most important factor in setting up an effective security model in Cognos. It’s best to use roles to control access to capabilities and groups to manage access to content. If this convention is not consistently followed security may become difficult to manage.
  3. Failure to understand access permission inheritance. Access permissions on content store objects are by default inherited from its parent. These of course can be overridden on an object and its descendants but security administration is easier when inheritance is enabled with a large number of objects. When security is overridden at lower levels it can be very hard to determine where overrides exist without specialized tools.
  4. Capabilities are not administered correctly. These are used within Cognos to control access to features and functions such as the reporting studios and the administrative tools. While it’s best to create new roles to manage user capabilities that match the distribution of your Cognos licenses, this is not always done making it very difficult to manage BI license compliance successfully.
  5. Too many people administering security. The real issue here is what often happens when there are too many people administering security inconsistently. Unless there is a common set of rules to use for Cognos security that are consistently applied then security problems are inevitable. For this reason it’s best to limit security administration to the fewest number of people practical and to make sure they clearly understand the security model and how it should be applied.

None of these issues are exclusive and there may be some overlap of these issues in any given Cognos environment. If you are running up against one or more of these issues on a regular basis you may want to think how to move to a security model that can better accommodate change and growth.



The Hidden World of Cognos Metadata

  
  
  
  
data stream

August 21, 2013, by Paul Hausser, Envisn, Inc.
People new to administering or managing Cognos BI often assume that a lot of the information they need to manage their Cognos environment and Content Stores is readily available. Basic information about key attributes such as size, what databases are used, failure rates, dependencies, etc. It’s disappointing to discover that there is not much of that information available right out of the box. Where it does exist at all, the information may be limited to a single object like a report or query.

 


Merging or Consolidating Cognos Environments

  
  
  
  
merge

June 27, 2013, by Paul Hausser, Envisn, Inc.
One of the many challenges that Cognos BI users often face is the need to consolidate or merge one or more Cognos environments into another one. This may come about because of an acquisition or simply to try and achieve economies of scale by merging Cognos environments. Not surprisingly, there are few, if any, guidelines on how best to approach this. This article will cover a couple of approaches to consider using for doing this.

 


Cognos BI Administration – Lessons From the Trenches

  
  
  
  
chalkboard reading lessons from the edge

May 31, 2013, 2013 by Paul Hausser, Envisn, Inc.

"Make everything as simple as possible, but not simpler." - Albert Einstein

We regularly get feedback from customers and prospective customers on the challenges they have to deal with as a Cognos BI administrator. Much of this makes its way into our CRM system in summary form and we recently sifted through this to see what learnings, if any, there might be. Below are some of the key lessons that we came across and they are in the approximate order of importance or frequency of mention.

 





Cognos Analytics and the Brave New World of Big Data

  
  
  
  
Big Data Vortex

March 29, 2013 by Paul Hausser, Envisn, Inc.
Confused by all of the headlines you see about Big Data? You’re not alone. Big Data is probably the most over-hyped term in the technology world since Client Server came on the scene decades ago. In reality Big Data is mostly the same data you already know supplemented by the surge in new ways of collecting data that did not exist until recently. Cars, GPS, mobile devices, online shopping and social media are some major examples – and they’re growing fast. What seems to be missing for many of us is a context with which to try and assimilate what all of this means and how to deal with it.

 


All Posts

Subscribe to the IBM Cognos Blog

Your email: