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

how to connect datamarts

2370


What is called a slice?

575


What you mean by drill across?

610


actually 2 members working in same module.at a time is possible to work on same module? i add some tables,another person also add some tables how the synchronization betn the two in same module? pls ans me and expain to me.....

1280


What do you mean by drill through report?

577






How to test a cube?

1672


What is the difference between regular dimension and derminant?

1685


------------- How to identify the Revenue Column in Report?

1816


Why cognos scenario is used?

580


Can you define metrics designer?

600


What are the considerations regarding performance kept in mind while setting up cognos?

562


Tell me about Dnamic and Static Dashboards?

1863


What are all the types of indexes in Cognos?

710


How to select multiple values from type-in prompt?

641


What is a Datastore in Cognos?

795