How can we improve performance in framework manager level?
Answer Posted / mahesh.g.s
Make sure that Data is imported from only 1 data source
with out any duplicate data sources created .Duplicate DS
will get created when you import New query subject from the
Database or Refresh the existing Query subject with the
name as 1 appended to the existing DS.
Make sure there are only few CASE statements,DECODE
statements where ever required.These hampers performance.
Make sure there are no loops between query subjects.
| Is This Answer Correct ? | 7 Yes | 1 No |
Post New Answer View All Answers
What are the other methods working as deployment functionality?
what are the dimensions that you have in your current project?list them?
How do you Parametermap variables in Quiries?
How can we create a dynamic column name in cognos?
How to create a cube in Transformer? What is the process? Please mention process thank u
4. How many dimensions did you use in your reports?
What are the different types of important services used in cognos?
Which studio is used to create reports?
------------- How to identify the Revenue Column in Report?
what is model and say about process how to create model and how to test model?
how you create security to reports?
1. We have been asked to add summary information to sales reprasentatives performance report. The report needs to be grouped by country and city to compare performance between areas Also we need to include revenue totals for each city and each country.
Source table has 5 rows. Rank in rank transformation is set to 10. How many rows the rank transformation will output?
what are the features in cognos8ui
what is degenerate key in oracle ?whare do we use it?