Answer Posted / arkchowdary
To set Governer Settings we can improve the performance.
Ex: Quesry Execution limit.
Avoid using complex calculations
Check the table qualifying and weighting.
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Please Answer this Questions: 1.In FWM We have to create Hierarchies, Condition is we don't know the correct levels in the Hierarchies, in this case how can we find out the levels (year->Quarters->month->day)in data? 2. In FWM Standalone Filter is for Reusable purpose & Embedded Filter we cant resuse.but is this possible to convert the Embedded filter to standalone filter? 3.What are the differences between Relational Database Model & Multi Dimensional Database? 4.In Drill Down/ Drill Up, How to specify the limits for example in a report there is 6 Drill down is possible, but i want only 3 Drill downs, the report should not allow 4 Th Drill Down.How to make this ? 4. What are the limitations in Select and Search Prompt ?
--------------Explain Table of contents?
Can you define materialized view?
Can you define query studio?
--------------Diff b/w ODS and OLAP?
what are the migration tools available in the market with respect to cognos such as impromptu reports are migrated to cognos reportnet?
Why cognos decision stream is used?
Can you explain a cognos controller?
What is the difference between drill through, drill across?
7. What is performance tuning?
Can you define cognos impromptu?
how to test reports in cognos?
Explain the difference between powerplay transformer and power play reports?
------------------What is Inline Query?
write a query to display the departments with no employee?