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


Please Help Members By Posting Answers For Below Questions

can anyone let me know some tips or interview questions on framework manager metadata modeling, creating joins, and all other aspects related to Cognos 8 framework mgr

1796


What are the themes in a data warehouse?

773


How the Bursting happens in same report and how to Print the bursting Report?

1641


What is a Folder?

894


whats the difference between previous version of cognos and cognos 8 BI?

5042


actually 2 members working in same module.at a time is possible to work on same module? i add some tables,another person also add some tables how the synchronization betn the two in same module? pls ans me and expain to me.....

1468


Can you define framework manager?

791


Helow, i have a problem with runing-total function when i use it for a calculate row (for example : i need to diplay a running-total of total units ?)

2196


Explain what is the difference between native sql and cognos sql?

749


How can create users and permissions in cognos?

741


What is the use of report studio?

792


Hi, I'm planning to write COG-132 exam so looking out for dumps. If anybody is having then please e-mail me at afrinshaikh86@gmail.com. your help would be appreciated. -Regards Afrin

1889


i have one file i saved in csv how can i take these file into framework manager

1786


What is a Cube?

887


what are the dimensions that you have in your current project?list them?

1833