Thursday, July 21, 2011

Tight Integration of IBM COGNOS within an application


The basic idea is to bring the reports to the user and not asking the user to go the reports .  Integrating BI into your application always help. The project had few things:

End users don't have to go to a different location to run their reports.  
Tighter integration for security
Utilization of the BI GUI
P.S - No SDK required

Let me put down an example / scenario

You have a portal where business users login. Here, you want them to view few specific reports that can alert them. In my case the front end of the application is java and I am familiar with simple java coding. What we did here is, using iFrames we pass the URL of the report with the prompt values ( for security reasons). So as soon as this link is clicked, it runs the cognos report. we have given a small window size of 400 by 400 for the cognos viewer and have designed the reports accordingly. Believe me, it has come out beautifully and the performance is amazing as the framework was designed based on these particular reports. Only disadvantage here, the end user cannot open anything but just watch the cognos viewer. No print options, no email, no output formatting etc. Advantages , it's lighting speed, security, GUI.

I have tried to put a rough sketch of how it looks. The red section is where you will see the cognos viewer.  Each individual box here is a separate report and not 1 single dashboard. This way the user can drill down on individual report without affecting the other. 

No comments: