Answer Posted / shree uday
Follow this Steps
1. Dont use the Not in function in the query.
2. Check the Governor Settings.
3. Check the table qualifying and weighting.
4. Check the client/server balancing.
5. Avoid using complex calculations
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What actually a project contains?
Suppose you run a report with empty data, how will you inform the end user that it has no data while running the report in report studio? Is it possible, if so how?
Does anybody have the sample of delivery document of cognos, or provide some link of websites Thanks
how many numbers of cubes can we create on a single model? How can we navigate between those cubes?
What junk dimension contains?
whats the difference between previous version of cognos and cognos 8 BI?
What are the themes in a data warehouse?
Synchroness 1.What are hash prompts? Ans: Tree prompts in which hierarchies can be seen,they can be said as hash prompts. 2.User wants to see 5 more coloums in the report.We have package and data base,how will u implement using it in report.? Ans: 3.What is automatic optimization?what is optimization?what are the properties you set for optimization in report studio? 4.what is command to display first 10 records from a table? IGATE 1.In FM if we change a fact symbol to attribute,will it effect the report? 2.If a report is slow in generating output. How do u perform tuning? How do u reduce joins in sql? Using left outer join is it going to improve the report performance? IBM 1.How do you configure ? 2.How do you drill through report from RS to Analysis studio?
How to deploy from one server to another server?
1)diff between shortcut-key and alias table? 2)what is unit testing? 3)what is scorecard?
describe the starschema grouping ?how can i add a new column for existing report ,when it is not present even in model & dataabase?
It is possible to test 2 query subjects at a time in CRN1.1 & C8 FWM?
hi i need to rename a file in cognos8? can anyone help me out how 2 do it? pls suggest some solution such as using a batch file or using a procedure node or anything to rename the file
i'm searching on cognos..i want to know real time scenarios..persons having real time exp or undertaking trainings or who searching on cognos...can send me the details...for proper guidence..for project and interview preparation..pls help me out..my mail-id is ammu2india@gmail.com..hope u will respond as soon as possible..thanks..
What are all types of Batches?
