COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: shrini on 18 Nov 2009 12:55:46 AM

Title: Need A Good Example For Drill Up And Drill Down
Post by: shrini on 18 Nov 2009 12:55:46 AM
Hi Frns
        I need a good example to know abt drill up n drill down.I was trying to get it but invain so frns let me know if any one can help me out


Thanx n Rgrds
Shrini
Title: Re: Need A Good Example For Drill Up And Drill Down
Post by: angela on 19 Nov 2009 01:43:37 PM
Many examples come with installing the Great Outdoors sample packages.
Title: Re: Need A Good Example For Drill Up And Drill Down
Post by: shrini on 20 Nov 2009 02:33:45 AM
Quote from: angela on 19 Nov 2009 01:43:37 PM
Many examples come with installing the Great Outdoors sample packages.


But if u know any pls let me know
Title: Re: Need A Good Example For Drill Up And Drill Down
Post by: jatin.popat on 23 Nov 2009 01:02:12 AM
Drill up and down generally refers to moving up and down a hierarchy.

consider a time dimension having levels as year->month->day.

Now if we use this dimn. in our report.


Initially all year will be dispalyed say for ex  - 2006,2007 and 2008.

Now if u click 2006 then all the months of that particular year will be displayed and then if click any month , all the days within that month will be displayed.

In this way we moved down in a hierarchy of a time dimension.

And I m not sure whetheer drill up works in report studio.
But in cubes both drill up and down works ..



Title: Re: Need A Good Example For Drill Up And Drill Down
Post by: shrini on 24 Nov 2009 05:12:09 AM
HI
I know how it works but inorder to know the navigational part i need an example

Regards
Vasu