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 / praveen k

best practices of framework manager are,
Create

1)Database view

   a)Import the Metadata from database.
   b)Check the usage properties of each query item
   c)manage the relationship and cardinality of Query            subjects
2)Business  view

  Rename the existing query subjects into business            understandable names.
3)Dimensional view

   a)Create regular and measure dimensions using business       view.
   b)set member caption and business key of regular            dimension.
   c)Check scope of dimensional view.

4)Package view
  a)create query and analysis packages.
  b)publish the packages to cognos connection.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What r the names of the reports that you prepared?

729


Explain the difference between native sql and cognos sql?

700


can anyone let me know some tips or interview questions on framework manager metadata modeling, creating joins, and all other aspects related to Cognos 8 framework mgr

1780


how you migrate reports to cognos 8 from previous versions?

811


2. What functional area you worked on.

2086


Source table has 5 rows. Rank in rank transformation is set to 10. How many rows the rank transformation will output?

824


What is difference between primary key and unique key constraints?

748


Hi I need real time senarios and how to explain project in the interview pls let me know my email id m.n.prathyusha@gmail.com.Please help me out with this pls pls pls muthireddi@gmail.com

1862


What is a dimension?

807


how to create measures and dimensions?

796


Define catalog in cognos and write its various types?

838


plsreply to me...im interested to do the cgnos certifications relating to report developer.can you suggest me what kind of certifications andwhere cani get (dumps) previous quetions and answers for the certification........

2113


1. Explain your project.

1781


What are the components of report net?

962


describe the starschema grouping ?how can i add a new column for existing report ,when it is not present even in model & dataabase?

2077