if report performance is low how can check 3 areas in
framework manager?.what are the 3 areas concentrate?
Answer Posted / raji
1.Check for loops in FM..loops cause delays and wrong data
fetched from the DB.
2.Check if there is a function or filter or a view on which
the query subject is based.Remove them and add the necessary
filters or functions in the report.
3.Create indexes to frequently fetched query subjects for a
quicker access in case volume of data is large.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
which type of project we r going to snowflake schema
What is the information present in the cognos configuration file?
How do we drill through from a powerplay cube to reportnet?\
What do you mean by drill through report?
how you provide security to reports? How you provide security to packages ?
What are the components of the report studio?
What are all the different types of prompt in cognos?
What you mean by drill across?
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.
faq's on cognos
how u will design the report if the objects are available
What are the advantages of using cognos sql?
What project,model,parameter maps,namespace and database definitions....... what these are all contains? what are differences b/w them?
Can you define cognos powerplay?
I have created a database "TestingDB" in MS SQL Server 2005. I have set the port properties and the Cognos Service is up. But I don't see anything in the Cognos. In the administration i have set the ODBC connection and it tested successfully.If i copy the samples to the appropriate directory then i can see the samples.But I don't know how to do the same thing with my own database "TestingDB". As i have configure the cognos in my company which is having a database (very near to production database).I am a novice in cognos. Please help me out.