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
What r the names of the reports that you prepared?
Explain the difference between native sql and cognos sql?
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
how you migrate reports to cognos 8 from previous versions?
2. What functional area you worked on.
Source table has 5 rows. Rank in rank transformation is set to 10. How many rows the rank transformation will output?
What is difference between primary key and unique key constraints?
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
What is a dimension?
how to create measures and dimensions?
Define catalog in cognos and write its various types?
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........
1. Explain your project.
What are the components of report net?
describe the starschema grouping ?how can i add a new column for existing report ,when it is not present even in model & dataabase?