How can we improve performance in framework manager level?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / arkchowdary
BY Checking the Governer Settings we can improve the
Performance.
We have many Governer Options.
Based on Situation we will use.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / suresh
by checking the governor settings i.e by setting table
retrieving limits,by setting number of rows retrievsal
limits etc....As my knowledge i give this answer.if any
further more reply.
| Is This Answer Correct ? | 2 Yes | 2 No |
i have one file i saved in csv how can i take these file into framework manager
Explain the difference between powerplay transformer and power play reports?
Which service handles requests for cognos connection,query studio and event studio.
hai frndz....... in a product name QUERY ITEM column we have some products like..soap, mobile, laptop, nd so on..... when i report run for the US client with the product name,, langauge is requird only ENGLISH.... IF client as a chaina .or, japan .or, spanish.. they want to run report using by product name QUERY ITEM as thier region language like chaina/japan/spanish... how to i convert product name column as default as english, to chaina/japan/spanish..........in the framework manager/ cognos connction Could u pls give me problm solution.....thnx in advnce........
----------0Diff b/w Report Functions and Database functions?
What is difference between informatica power mart and power center?
What is defined as data mining?
how can you create a report like if country=india then true if contry=spain then false?
What is difference between page break and section report? What is main advantage datawarehousing over oracle?
Hi Cognos Experts,I am Having DatePrompt In My Report.I want to display The Report Between Twodates Like jan-SEP How can We Achieve This one?PLS Expain Me With Ex:
set scope level in transformer
Why need staging area database for dwh?