How to improve the performance of the report at the report
level?
Answer Posted / gauri
There are various things and they differ based on the case we are looking at.
Master detail relations defined on reports, having multiple singleton objects, poorly joined facts, in some cases having too many render variables also cause issues.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
hi my name is siraj i want to know cognos queriy language
How can we import Excel data in to FWM?Wt is mean by Ragged dimensions?where can we observe the Regular dimensions & measure dimensions?
Can you explain cognos planning?
How to deploy from one server to another server?
hi all i am searching for cognos jobs pls inform about the jobs to:santosh.koora@gmail.com
What is the importance of having monitor service in cognos?
How do you Parametermap variables in Quiries?
what is the main advantage of impromptu over cognos reportnet?
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 the values be passed to prompts in report studio? when a data item is dragged n dropped in to report, after the default query generated first which sql will the query query hit for processing means (native or cognos)? plz answers to these questions?
Write types of folders present in cognos?
Can you define drill down and drill up?
Hi All, Is there any way to check whether a value is selected in a Multi-select tree prompt? I have a tree prompt and want to get to know whetehr which values user has selected,i want to so that values on the top of the report. I Have used that paramDisplayValue('paramername'),But it will display only last selected value. For Example i have tree prompt with one level Region- >country->states If user select region Asia it will dislay the all the Countries in that region and then if user select India it will display the states related to india only Suppose Hierachy look like this: Asia->India->Andhra Pradesh. I want to show this hierachy on the top of the report How it is possible? Can you please help me?
Which studio is used to create reports?
What are all the different types of prompt in cognos?