What are the best practices while building a Cognos Framework Manager Package ?
As in, what calculations would you not like to be handled in FM and rather get it directly from Database.

Answer Posted / sandeep8000861

I would say, push ALL the calculations that are used in multiple reports onto DB server. The allows Cognos server to just 'read' data instead of 'calculate' date.

Use the powerful analytical functions and other rendering features of Cognos to enrich the user experience

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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?

1644


What is the use of Cognos scenario?

720


What is the difference between set functions and filter function in dimensional data?

2510


Give the advantages of cognos?

571


What are all the types of gateway used in Cognos?

548






What you mean by drill across and what is the difference between drill through, drill across?

548


What is looping and how to avoid it in framework manager?

658


How to create a cube in Transformer? What is the process? Please mention process thank u

1328


What is the diff between cognos 8.1 & cognos 8.2 & cognos 8.3? Measn whet are the enhancements are added in new versions(8.2& 8.3)?

3917


Please explain the different stages in creating a report in cognos report net?

564


What are all the advantages of Cognos?

635


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?

4208


Can you define set to be cardinality?

585


What do you understand by user class in cognos?

532


Can the expiration parameter of 365 in the cognos 8 configuration how to increase common symmetric key lifetime in days

3150