Interested to Buy Any Domain ? << Click Here >> for more details...
how will optimiz the performance of sql in FM ?
- 2 Answers
- 7848 Views
- Infosys, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / chaitanya
using the governor setting, enabling the allow usage of
local cache we can increase the performance.
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / arkchowdary
Enabling the Governer settings we will increase the
Performance.
| Is This Answer Correct ? | 0 Yes | 1 No |
What is the use of cognos decision stream?
What is Performance Tunning Test?
what is conditional query subject and example
Can you define confirmed dimension?
How to publish a package by running Java Script?
how to hide a particular pages at time if you get blank pages
What is cognos reporting tool?
Q1. We have a crosstab report which is having product, region and Revenue information. Now the requirement is that we need to add a new column with the information 'High' and 'Low' just beside the Revenue column. If Revenue is high is should display as 'High' and if Revenue is low then it should display as 'Low'. Q2. If my Cube size is 2GB, now I have got the requirement to reduce it. What are the parameters I have to follow to reduce the cube size? Q3. How to get the 2nd highest salary of an employee without using any function (I mean without rownum etc.)? Q4. What is the difference between joins and scope relationship?
In my Report C-id c-name Revenue are the query items I need to display the report has Alternative colors for rows and Revenue >=1000 has display in another color? i.e Both c-id,c-name are applying the alternative color(red,yellow) condition and revenue (blue) u think..How its possible? Iam doing for alternative colors i defined Two dataitems as running-count and Mod... and next in Boolean varaible define as [Query1].[Data Item2] = 1 or 0 and [Query1].[Revenue]>=1000 as like this (it's correct or not) and define in condition explorer yes and no purpose two colors(here how to define 4 revenue color) By selecting the list columns body style its applying only the Body and run report it working only for alternative colors Next i defined by using same Boolean condition for revenue like this. For selecting only the Revenue Body and define as yes 4 one color and no for another color? But here it the revenue column also applying only the alternative color condition and it's taking the >=1000 condition... So,i need to display 2 columns have alternative colors and 3rd column >=1000 cell have another color any body pls give me the replay/answer in step wise..... Thank u Basha
10. In Report studio ,how to get the top 20 employees in using list report Row number – if only list Rank Running-count
how can you set the image in the report
Name the types of report?
Teradata 
