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.
- 3 Answers
- 5545 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 ? | 3 Yes | 0 No |
Answer / 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 |
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 |
---------- Purpose of Factless Facttable?
How can i approach to write Congnos Certification? What exactly should i do? Can anyone guide me plz?
Hi, I Want To Display The Report. From MOnday To Friday By Using Date Prompt.PLs Expain To Me...
What are the problems you have faced recently while developing reports in report studio? And how did you solve those problems? This question is asking in many interviews,,,,so pls help me,,,,,
where exactly determinants are used in cognos framework manager?
what are the limitations of cognos reportnet? What are the enhancements in reportnet ?
Can any one expalain the procedure for How to create a Mastr Detail Report in Cognos 8.3 ver?
What is the use of powerhouse?
what is the difference between count and running-count functions?
can we join 2 different queries? One has 10 columns and other has 5+ columns?
I have a reports on cognos ep7series version3 with database SQl2000.Now i am migrating database SQL2000 to SQL2005.Then What happens to cognos reports and also there is reports cubes then how can i handle this problem please give me step by step solution b'coz i am new to cognos ep7series
How to create users and permissions in cognos?
Teradata 
