Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 6756 Views
- I also Faced
- E-Mail Answers
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 ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is Additive function?
How can I test reports in cagonos?
Can you define pivot?
Synchroness 1.What are hash prompts? Ans: Tree prompts in which hierarchies can be seen,they can be said as hash prompts. 2.User wants to see 5 more coloums in the report.We have package and data base,how will u implement using it in report.? Ans: 3.What is automatic optimization?what is optimization?what are the properties you set for optimization in report studio? 4.what is command to display first 10 records from a table? IGATE 1.In FM if we change a fact symbol to attribute,will it effect the report? 2.If a report is slow in generating output. How do u perform tuning? How do u reduce joins in sql? Using left outer join is it going to improve the report performance? IBM 1.How do you configure ? 2.How do you drill through report from RS to Analysis studio?
describe the starschema grouping ?how can i add a new column for existing report ,when it is not present even in model & dataabase?
Name the types of report?
How to select multiple values from type-in prompt?
What's the limitation of 'Page Footer' in Report Studio? e.g. If I have an activity prompt (list of activities in a Search & Select Prompt) and selected around 2500 activites from the 'Activity' Search & Select Prompt and when I ran the report I got a message "#! Overflow" in page footer. Can somebody please tell me what's max. limit. I tried with around 300 activities and page footer displayed the activities. Your help will be appriciated.
What is the difference b/w macros and prompt?
What are the different uses of a repository manager?
How do you improve the performance of the Cognos Analytics report
How to do Performence Tunning in Cognos Reports?
How do we drill through from a powerplay cube to reportnet?\
What is the model filter?
-------------What is Coditional Prompting?
