How can you improve performance in report studio level?
What is the difference between Cognos sql and Native sql?
How can you create cubes in framework manager?
Answer Posted / neelima
by using simple case statements and minimising the complex
calculations and applying the frequently used filter
conditions at the framework level instead of applying them
in the report level we can improve the performance.By
implementing distributed configuration we can improve the
performance.
we can create IQD's in the framework level and use these
IQD's to create cubes in powerplay.
| Is This Answer Correct ? | 12 Yes | 3 No |
Post New Answer View All Answers
Which studio is used to create reports?
What is meant by drill down?
I have a reports on cognos ep7series version3 with database SQl2000.Now i am migrating database SQL2000 to SQL2005.Then What happens to cognos reports and also there is reports cubes then how can i handle this problem please give me step by step solution b'coz i am new to cognos ep7series
What are types of batch available in cognos?
What are products of cognos?
A product manager is analysing the sales made for each product, he has requested a report containing data for specific products. To do this we will create a report that includes a prompt page that filters on specific products within specific product subcategory and category.
What is the use of powerhouse?
Can we create 2 conditions in report expression of a single data item..Eg: I added 2 new dataitems each one should show revenue for Q1 and Q2..Pls advice
what is log in cognos?
Mention the difference between ‘macros’ and ‘prompt’?
Explain difference between powerplay transformer and power play reports?
What is set to be Cognos configuration?
What is the difference between Standard and Metrics folder?
faq's on cognos
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?