Sunday 8 September 2013

Cognos: Creating Gantt Chart using Crosstab


Cognos do not include a Gantt chart as an available option in chart dialogs. We can achieve this by using Crosstab object. The steps below will discuss creating the Gantt chart.

1. Tables used
We are going to use following two tables
(I)Minute    
(II) Jobs
2. Create two Queries, Jobs and Minute, with all data items available in Jobs and Minute tables respectively.
3. Drag a third Query item and a Join object, which will join Minute and Jobs Query.
3. Double click Query1 and drag the data items into it.
4. Insert a Data Item called Range with following expression

5. Insert a filter to it with following condition:

[JOB] NOR Null

6. Insert a Crosstab object, Select the Query as Query1
7. Insert the data items into crosstab.
8. Sort the MIN column in ascending order.
9. Run the report, you can see the output
10.  Insert a Boolean Variable with following expression

[Query1].[Range]>0

11. Select Crosstab Intersection, Go to Condition Expression, Select Yes under Boolean Variable
12. Select Style Variable Property as Boolean1, Select Background and foreground color
13. After saving and Running the Report, You can see the following Gantt chart

4 comments:

  1. Very innovative post

    ReplyDelete
  2. I didn'nt know if this was possible in Cognos. Thank you for sharing such a wonderful post.

    ReplyDelete
  3. This comment has been removed by the author.

    ReplyDelete
  4. Hi Sumeet,

    Developing new gen developer friendly BI framework with unique features.Like to give you access and know your opinion Please do let me know of how to reach out to you. Would be launching product in 3 weeks from now.

    Regards,
    Anugraha

    ReplyDelete