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
- 5593 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 |
Define query items?
What is the difference between filter & Condition?
3. What was the size of your cube?
What do you understand by the term 'aggregate advisor?'
How to hide/unhide the prompts which are not used by unauthorized users?
how to add a new query item by using 2 query subject? For Ex: i want to create a revenue query item in products query subject(revenue=Quantity*Unitprice). Quantity is in products query subject & unit price in orders query subject it will be possible in report studio(perment/temporerally) otherwise u have create in Freamework Manager... pls any body knows explain /answer me ?
Hi, I Want To Display The Report. From MOnday To Friday By Using Date Prompt.PLs Expain To Me...
what are versions of cognos from starting release to latest in the market?
what is filter?give me one example that you created a report in your project?
hi frnds any body have cognos projects plz send me two(or)three projects to my mail adress ramureddy.reddy4@gmail.com.
what happens when date function has taken as attribute
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,,,,,
Teradata 
