how will optimiz the performance of sql in FM ?
Answer Posted / arkchowdary
Enabling the Governer settings we will increase the
Performance.
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
1. Explain your project.
What do you mean by drill across?
What is Fullouterjoin?
Explain what is the difference between microstrategy and cognos reporting tool?
What condition do we use in Cognos when multiple path exits to reach the fact table.(i.e in BOXI we use CONTEXT when multiple path exit)
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 ?
What is meant by alternate drill down with ex?
Source table has 5 rows. Rank in rank transformation is set to 10. How many rows the rank transformation will output?
--------------Explain Table of contents?
What is the advantage of using shortcuts?
How to apply securities for reports in cognos connection?
What is a Cube?
What are the themes in a data warehouse?
what is power prompt in cognos ep7series?what is the use of this?
plsreply to me...im interested to do the cgnos certifications relating to report developer.can you suggest me what kind of certifications andwhere cani get (dumps) previous quetions and answers for the certification........