September 2010
S M T W T F S
« Jun    
 1234
567891011
12131415161718
19202122232425
2627282930  

Did you know you probably already own PowerPoint integration with Cognos BI?

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.

Top Five Framework Manager Do’s and Don’ts

Framework Manager is the brains of IBM Cognos 8. It is often misunderstood and therefore abused by the misguided. So let’s talk about Framework Manager do’s and don’ts.

Do you understand the words that are coming out of my mouth?

Report writing is difficult for most people. It requires a level of detail and skill that most people simply don’t have the patience to learn let alone apply. Historically, most report writers are primarily Information Technology (IT) people with very little business experience which makes it impossible to explain why a transaction must be a debit instead of a credit. The language gap between report writers and users can be the difference between speaking English and Spanglish. The report writer might understand basic information about the business but not enough to optimize a report or the user doesn’t understand real constrains such as data quality, database design, or application limitations to understand why a report can’t be written just like their excel spreadsheet.

Report writer I have two words for you … Analysis Studio learn it, love it, use it. Business user I have the same two words… wait for it … Analysis Studio. Let’s assume that you have the groundwork covered such as a multidimensional Framework Package and you have Analysis Studio deployed, you can use Analysis Studio drop and drag functionality to bridge the gap between report writer and business user.