Category Archives for "COGNOS BI"

Understanding IBM Cognos BI Security

Managing security within your reporting environment can be a difficult and risky task if you don’t fully understand your software’s security structure. In this blog, we will discuss the various levels of security and how you can mix and match to come up with the best security plan for your business.

Security within IBM Cognos BI is object oriented. That means you can set security on many different objects within Cognos, but the lowest level of security will win if you have multiple levels of security. In order to understand security and permissions, let’s talk about two examples:

Continue reading

IBM Cognos 10 BI – Worth the Hype?

IBM has released Cognos 10 and there are some skeptics out there wondering if it is worth the hype. In my opinion, the release warrants a conversation because it is a major release. Note that they went from Cognos 8 right to Cognos 10 and there are major differences. Some of the additions and changes are great … really … so I will give you the quick and dirty. You can read the complete release information in the upgrade whitepaper, so I won’t bore you with too much tech talk.

Continue reading

What to Know In Cognos 10 BI

As I’m sure you heard, IBM unveiled Cognos 10 at IBM’s annual Information on Demand (IOD) event in Las Vegas recently.

Cognos 10 is the first major BI release since Cognos 8 was published in 2005. Don’t worry, you didn’t miss version 9 – in an effort to have the numbers of all the various modules in line, IBM jumped to 10. Cognos 10 presents a more integrated user interface along with a broader offering of analytics and technology. The recent acquisitions by IBM of SPSS , TM1 (Applix) and Clarity are now a part of the offering.

Continue reading

When to Use Cognos Event Studio

IBM Cognos Event Studio is often an underutilized Studio but has its place. I think it would be better to explain how you can use this Studio in your everyday duties instead of the traditional white paper approach. I will use a couple of examples that I think highlight how a business group (departments) can use Event Studio and how a database modeler can use Event Studio.

Continue reading

Cognos Go Office: PowerPoint Integration w/ Cognos

Your Mission: Complete the company presentation and merge data from 5 different places. And here’s the kicker, the numbers have to be CORRECT.

So, you put on your thinking cap, you fit more windows in your tiny computer screen than you can really read, and you begin the task you dread every month. You first make sure you have all the data that you need to compile. Check. Then you open last month’s presentation and start removing all the reports, graphs and data from last month. Check. You open your Excel spreadsheet that checks your numbers to make sure they are correct. Check. You are armed with the tools and ready to go to battle because that is really what this whole process is.

But does it really have to be that painful? ABSOLUTELY NOT!!! Welcome to IBM Cognos Go! Office – you probably own it and aren’t using it.

Continue reading

Cognos BI Promptmany Macro Function Error

The promptmany macro function error message is such a letdown. Error QE-DEF-0406 is normally generated when you try to use the function to pass multiple values to a Sql stored procedure. By nature if a stored procedure have parameters, you can only set the parameter equal to a single. This is a problem if you want and need to pass multiple values to a stored procedure. Traditionally, Sql programmers use cursors to handle passing individual values one at a time to a procedure. Of course programmers would rather bite off their arm than willingly write a cursor if there is another viable alternative.

Continue reading

2 Cognos Report Studio Nested If Statements – HELP!

Have you ever tried to do a nested IF THEN ELSE statement inside IBM Cognos Report Studio? If you have, you might run screaming because you can’t get the syntax just right. Granted, you could read the tips at the bottom as you build the syntax but shoot yourself in the head if you are not a programmer. You probably could pickup Chinese faster.

Continue reading