Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 5 Answers
- 9275 Views
- Mphasis, I also Faced
- E-Mail Answers
Answer Posted / s ali
Q3) In SQL server
select top 1 sal from
(select top 2 sal from emp order by sal desc ) emp2
order by sal desc
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the difference between a data mart and a data warehouse?
what are the dimensions that you have in your current project?list them?
What are the components used in web tier?
2. What functional area you worked on.
Suppose you run a report with empty data, how will you inform the end user that it has no data while running the report in report studio? Is it possible, if so how?
can we insert all types of charts in a list report? what r the realtime prompts?
How we check the errors before running the report?
Can you explain cognos planning?
how to perform back drill through in cognos 8 what is the use of it
What do you understand by the term 'aggregate advisor?'
How do you Parametermap variables in Quiries?
how you burst the reports? If you are bursted reports is not reached to destination how you identify?when you import data into catalog you have complex columns names.how do you change the name of those columns?
What DB View and Bus View?
Give me any example of semi and non additive measures?
what are the difficult problem are you involved in cognos report net and 8 and impromptu if any pls share with us
