Thursday, 27 November 2014

How to use Rank function in Cognos Report Studio?

There will be scenario when you need to display Top records in your Cognos report.It could be any fact measure over which you have to find out Top 10 or 20 records subject of requirement. As Cognos reports data extraction mechanism using SQL query to interact with data base so we must adhere with...

Wednesday, 26 November 2014

COGNOS Business Intelligence Architecture

Cognos BI Architecture is a 3 Tier Architecture separated as Presentation or Web Tier Application Tier Data Tier 3 Tier Architecture    Presentation Tier or Web Tier provides user session connectivity to IBM Cognos BI application   Component that fulfill this role are referred...

Saturday, 22 November 2014

Use of CAST function in Cognos Report Studio(RS).

In general cast function defines as who transforms one data type of a column to other one as defined in the function.                      Syntax : cast (Column name ,desired_datatype(needs to define)) In report studio cast function is used to make two query item with different data type compatible...

What is Business Intelligence(BI)?

To define business intelligence (BI) in single article is not justifiable as compare to broader area of BI. I am trying to define BI in simple words and time to time will enhance this topic. In my words , Business Intelligence is combination of business concept or set of techniques along with BI tools to transform raw or unstructured data into meaningful and useful information. There are list...

Saturday, 1 May 2010

HUMAN NOW A DAYS

Hi to all of you and Thanks in order to tolerate me now and onwards. well as of it my first blog and as you can see "first be a human being" sounds strange right as all of us are human being but as matter of science biologically we are but being a human have lots of things desirable which now a days almost lost!!!!!!!!!!!!!!!!! As now a days life particularly is a mixture of "professional...