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
Explain the difference between powerplay transformer and power play reports?
----------------Describe DWH Architecture?
What do you mean by drill through report?
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.
Can we create 2 conditions in report expression of a single data item..Eg: I added 2 new dataitems each one should show revenue for Q1 and Q2..Pls advice
How to a create header dynamically in a crosstab report in cognos 8.1?
Which studio is used to create reports?
What is a Pivot?
What do you understand by ‘ibm predictive maintenance and quality’?
how many numbers of cubes can we create on a single model? How can we navigate between those cubes?
in u r data u having duplicates how to fetch the latest data in our report?
Can you define framework manager?
Define dimensions?
Can you define fan trap?
Can you define snapshot?