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
- 5548 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?
I would appreciate if any one answer for this, I have faced the question like this, the question was Tell me some complex reports, which u faced?
2. We have asked to create a repots showing sales by region in order to determine which regions are generating the most revenue and highest sales volume. The report needs to include the revenue and quantitiy sold of each subcategory with in category.
how many facts&dimensions tables in a sales project?can any body name those dimensions and fact tables please
i have taken quantity on ANx-axis & months on y-axis(months r not in oreder )when i run the reoprt i need months in proper order .how can i do this ?
What is a Cube?
-------------How to do Bursting a Report?
What is Stich Query in Reportnet?
what is meaning by Master detailed relationship ? please explain one example
How you create IQD In ReportNet FrameWork?
where you can save the report net documentation in our local system?
Hi Friends, Just want to know, day to day is increasing or decreasing Cognos Usage in the Market? New Reporting tools to driving Reporting Market Spotfire, Tableau,Qlick View, some other New Tools. Which Reporting tool can generate Lot of Opportinities in the Market? Please Reply to this, My Advanced Thank to you. Thank You Kumar
Teradata 
