WHAT SHOULD BE DONE WHEN A REPORT RUNNING TIME WILL TAKE
LONG TIME IN CONGNOS?
Answers were Sorted based on User's Feedback
Answer / joydeep
go through the generated sql and try to compare it with the
regular sql code by running the sql in the navigator. that
will give you an estimate of the time difference.
secondly try to check the joins. avoid outer joins as far
thirdly try to add prompts and filters if possible to
reduce the number of records to be pulled into the query.
|Is This Answer Correct ?||5 Yes||1 No|
Answer / ajay
deselect the option auto-aggregate&sumarry option if it
selected it takes much time to get the data
|Is This Answer Correct ?||4 Yes||1 No|
What is catalog and types of catalogs in cagonos and which is better?
What is a Transformer?
how u publish the packages in framework manager
What is TRAP in Framework manager?What's the use of TRAP? Where We are using this?
What are the advantages of using cognos sql?
Tell me about Dnamic and Static Dashboards?
What is the use of 'individual data source' option while using filter in query studio?
I have tables like tableA&tableB,in tableB columns(sno,month,netrevenue,year),by using both the tables we hava to create list columns like(country,month,net revenue)when i run the report if my retrevenue'0'this plasa i want to display'NULL'
What is the difference between a cascading report and drill through the report?
What do you understand by the cognos?
If we run a report, that has 2 pages, i want to display one page in HTML format and another page wil display in pdf format. What is the procedure?
-------------How you design DWH?