What is difference between drill through and drill down?
Answers were Sorted based on User's Feedback
Answer / joydeep
drill through means navigating from one report to a
different report in order to get detailed data. while drill
up/down is done within the same report.
drill through can be done in relational, DMR and OLAP data.
relational to relational
DMR to DMR or relational
OLAP to OLAP, DMR or relational
drlii down/up can be done only on DMR and OLAP
| Is This Answer Correct ? | 40 Yes | 1 No |
Answer / mohit
drill through means navigating from one report to a
different report in order to get detailed data. while drill
up/down is done within the same report.
| Is This Answer Correct ? | 12 Yes | 1 No |
Answer / nasa
drill through means navigation from summary level to detail
level
http://pic.dhe.ibm.com/infocenter/cx/v10r1m0/index.jsp?
topic=%2Fcom.ibm.swg.ba.cognos.ug_cr_rptstd.10.1.0.doc%2Ft_id_
cr_rptstd_modrep_drill_through_access_110createadrill-
throughdefinition.html
drill down: it show the just next level not from summary to
detail...
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / s.srinivas
DRILL THROUGH ALLOWS U TO NAVIGATE FROM SUMMARY TO DETAILED
INFORMATION.DRILL DOWN AL SO SIMILAR KIND OF THING FOR
EXAMPLE WILL DO DRILL DOWN ON YEAR IF WU DRILL DOWN ON THIS
THE NEXT LEVEL WILL COME MEANS YEAR CONTAINS QUATERS, IT
CONTAINS MONTHS ,MONTHS CONTAINS WEEKS, WEEK CONTAINS
DAYS.SO,WE CAN VIEW ALL THE LEVELS THROUGH DRILL DOWN
| Is This Answer Correct ? | 1 Yes | 17 No |
What errors and types of errors you faced in Cognos ReportNet?
I have created a database "TestingDB" in MS SQL Server 2005. I have set the port properties and the Cognos Service is up. But I don't see anything in the Cognos. In the administration i have set the ODBC connection and it tested successfully.If i copy the samples to the appropriate directory then i can see the samples.But I don't know how to do the same thing with my own database "TestingDB". As i have configure the cognos in my company which is having a database (very near to production database).I am a novice in cognos. Please help me out.
Can u solve a small query on table the problem is whether it is possible to add extra cells for already existed table i.e if table contains 3 rows n 4 cols (3*4) it is possible to add another cell (4*4)
what is filter?give me one example that you created a report in your project?
WHAT SHOULD BE DONE WHEN A REPORT RUNNING TIME WILL TAKE LONG TIME IN CONGNOS?
2 Answers ABC Infotech, Virtusa,
my table having data like this year month revenue 2011 jan 100 2011 feb 200 2011 mar 150 like this i want My report 2011 jan 100 2011 feb 100+200=300 2011 mar 300+150=450 like this for this where we specify the condition how will specify? pls ans me pls...
Explain what is the main advantage of impromptu over cognos reportnet?
1.How can we driil through from a page report having query1 to list report having Query2 in master detail relationship n Drill through? 2.In database i have 50 records but when it is displayed on the report i'm getting 100 record with duplictes.How can we solve this to eliminate duplicates? 3.Exact Diff B/W Filter n Condition? 4.Render Variable? 5.I have leftouter join when right table does not have any matched records with left table what will be the output of the report whether it will be dispalying Null or blank in that particular row? 6.How to test the reports i.e Unit Testing? 7.How canwe drill through when there is no common column between the parent n child report? 8.How can we do performance tuning? I kindly request all the experts to give reply with correct answers and if possible send me some examples regarding that at srini.madhala@gmail.com
What are the types of security?
What is the difference between regular dimension and derminant?
Can we create a web page where the report directory and the output can be viewed directly across cognos connection?
What is set to be Cognos configuration?