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 / durga

The performance of a report depends on the network speed
and as a developer the following things should be taken
care. Use less number of complex calculations in the
report. Avoid using of conditional blocks and also avoid
unions in the reports.

To create a cube we need to create an iqd. and use this
iqd to create a cube.

Is This Answer Correct ?    5 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Actually we have 500 users when they run the report display the flage image related country user? How its possible?

1565


WHAT ARE THE DISTNICT VARIABLES?

1740


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?

4203


What is a Pivot?

539


Can you define cognos impromptu?

622






------------------What is Inline Query?

1782


is there any difference between operational database and data base?if yes what r they?

1584


Can you define cognos decision stream?

596


what is power prompt in cognos ep7series?what is the use of this?

3199


I have ten columns that needs to be totalled... but some columns are empty...how do i get sum all the columns even if sum are empty? Can i get a total of the rows instead of columns? if yes, what is the function to be used?

1525


Can you define drill down and drill up?

631


What do you understand by the term ‘frame manager' in cognos and write all the layers of the framework manager model?

702


what are the special features in cognos reportnet?

607


What are the message flows?

553


What is the difference between a data mart and a data warehouse?

539