Cognos - what is the difference between a cascading report and drillthru report?why do we go for drill thru r

GeekInterview.com > Interview Questions > Data Warehousing > Cognos

Go To First | Previous Question | Next Question

Cognos | Question 7 of 180

what is the difference between a cascading report and drillthru report?why do we go for drill thru report?

Total Answers and Comments: 5

Last Update: January 23, 2008 Asked by: suresh babu

Sponsored Links

Best Rated Answer

—

Submitted by: binay.bk

Hi

Drill Through is used to link the master & detail reports.
After putting drill through if you click on a link (e.g. Order ID 1234) in the master report then the details will be displayed for that particular item (Order ID 1234).

Cascading prompt uses the value from the previous prompt to filter the value in the current prompt.

For Cascading no need of two reports.If a report having two related columns (e.g. Country & States),then we can cascade these two columns by adding two value prompts.

If you select a country (e.g INDIA),in the next prompt all the states will be displayed those which are under INDIA.

If you want to see the details for the state Tamilnadu,then select TN from the list which will display all the details for TN.

Above answer was rated as good by the following members:
channamoni, Pavanchandra, subhrajitbanerjee

February 23, 2006 05:24:57

johnsy786

Member Since: February 2006 Contribution: 3

RE: what is the difference between a cascading report ...

cascading report works based on the condition

but drill thru work based on the data item what we select as a drill thru options

Is this answer useful? Yes | No

May 31, 2007 06:51:27

ranganadh

RE: what is the difference between a cascading report ...

Cascading prompt means to extract the data from one prompt to using values from another prompt.

Drill through report means to extract the data by selecting a column in a report means to get the detailed information by clicking that column data.

Is this answer useful? Yes | No

October 13, 2007 15:06:42

Vipin vats

RE: what is the difference between a cascading report ...

The cascading could be defined in broad sense as joining of tables or data. In cascading of the data the resolution of the data remains the same. In the drill through i.e. up or down the data resolution changes

Is this answer useful? Yes | No

1 0

Overall Rating: +1

November 04, 2007 10:24:29

subbu

RE: what is the difference between a cascading report ...

cascading report contains one report and it work based on the condition.

drill through contains two reports parent report(summary) child report(detail report)

child report contains a parameter that must accept the values passed from parent report.

Is this answer useful? Yes | No

1 0

Overall Rating: +1

January 23, 2008 23:55:16

binay.bk

Member Since: January 2008 Contribution: 4

RE: what is the difference between a cascading report and drillthru report?why do we go for drill thru report?

Hi

Drill Through is used to link the master & detail reports.
After putting drill through if you click on a link (e.g. Order ID 1234) in the master report then the details will be displayed for that particular item (Order ID 1234).

Cascading prompt uses the value from the previous prompt to filter the value in the current prompt.

For Cascading no need of two reports.If a report having two related columns (e.g. Country & States) then we can cascade these two columns by adding two value prompts.

If you select a country (e.g INDIA) in the next prompt all the states will be displayed those which are under INDIA.

If you want to see the details for the state Tamilnadu then select TN from the list which will display all the details for TN.

Is this answer useful? Yes | No

3 2

Overall Rating: +1

Go To Top

User Name		Remember Me?
Password

Question Bank