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
- 6929 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 |
What are the types of catalogs in cognos?
Can we use 2 packages in report studio at a time is there any alternative for this Thanks Nithin
How to convert the tabular report into graphical report?Is this possible in cognos 8 report studio?
what is the diff b/w excel 2000 and excel 2002 sheets if any body know this answer plz tell me
Write various indexes used in cognos?
There is any option to delete temp files automatically from temp directory in COGNOS? (without manual)
------------- How to identify the Revenue Column in Report?
What is the abrevation of .PPR? (Power play report) or anything new?
What is Correlated sub-query? Please explain
I have Date,product,Quantity_Sold columns and I want Product, MTD(month Till date),YTD(Year Till Date) as output. Can anyone help me with the logic in getting MTD i.e quantity sold from 1st of this month to till date (i.e. 01- 11-2013 to 26-11-2013) and YTD i.e QTD sold from 1st date of the year to till date(i.e. 01-01-2013 to 26-11-2013). Sample output model: Product MTD YTD
What is a dashboard in Cognos Report Studio and how do we creae it
What are the message flows?
Teradata 
