Saturday 17 March 2012

Active report ideas begin

Hi Guys,

So the question is where to start for Active reports.There is a redbook available on IBM site for Cognos 10 active reports which gives detail example of how to use each item .So download it and go through.So lets start with some interesting ideas on what we can make with Active reports

Below are Steps to create a basic active report.

It includes lot of concept of Master detail relationship and below active reports concepts

1)Data button bar
2)Data deck
3)Tab Control
4)Radio button group
5)Deck



Below are steps to create the report

1) Take 2 blocks
2) Data button bar
3) Data Deck
4) Click on interactivity and create new variable joining both of them
5) Add a tab control
6)In interactivity of tab control create a new variable Display_V
7) In Container select set Label in Display V
Behavior on select - When you have a tab control and you click on one of the tabs what you expect
it to do that is called behavior select
Container select is which tab to show from the list of tabs that we have

8) Add a repective items in the named tabs Like Bar,Pie and List
9) Add year data item to Pie query and create master detail relationship between data deck and
this tab control and this year
Note - You will have a interaction between data button and data deck First.Then you are going to have a master detail relationship between this data deck and tab control

10) In the list tab add 2 more blocks
11) Add a radio button group
12) Add a deck
13) Join the radio button group and deck based on label
14) add product and revenu and a rank calculation
15) Create a master detail relationship between top button adn list
16)creat deck for top 5 and top 10
17)create master detail relationship between both the decks top 10 and top 5
18)Note if you put something as deck it wont generate a query .When you put data deck it will
generated a query and you can have master detail relationship between only those which are called
deck

No comments:

Post a Comment