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.
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 |
What is the report studio?
can anybody explain me about sales project in cognos..wt is the requirement,how u get the requirement..explain me any one based on ur experience as a report developer..how much time u will take to complete one project,single person in a team have to do how many reports..in a real time how much time will take to complete reports ie..one single report.. (simple and complex report)and in real time ur project contains how many fact tables and dimension tables..how many query subjects and query items..wt functional area u worked on.. hope u vl respond as soon as possible ..my mail- id is ammu2india@gmail.com
what are typees of dimensions
1.How will u link a list to crosstab.?i.e link a pramater in list so that it shows further information in cross tab.? 2.I have different regions,I want region specific logo to be displayed when I run the report.How it is done ? 3.Among Drill through and Master detail relationship which is more effective? 4.How do u hide a column in list report? Ans: In properties,Burn list option-check whichever column u wanna hide. 5.What is Roll play dimension? 6.What is Data Item Value n Parameter value?,What exactly it ll take when select either of them? 7.How many types of filters are there? 8.What will happen if u use detailed filter ?,n what is da result when used on summary filter?
I want to display popup menu or alter message in my report? How to you solve this problem? Give me the answer with example?
What are slice and dice?
-------------What is a Conformed Dimension?
What is Bitmap Index?
which type of project we r going to snowflake schema
how to create relationship between emp and salgrade tables in frameworkmanager?
Why we should go for cognos? when there are so many other BI(Reporting) tolls in front of us?
Cognos Online Training will be provided. prior training with all real time aspects. Comprehensive training will be given in Datawarehousing concepts , cognos 8.4 and cognos 10 versions. Contact kris.cognos25@gmail.com