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
- 9031 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 do you understand by the cognos?
What are the other methods working as deployment functionality?
What are the batches and it’s details?
What are the two types of framework manager?
What are the advantages of using cognos sql?
What is the importance of having monitor service in cognos?
what is catalog and types of catalogs in cagnos and which is better?
Can you explain cognos planning?
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)
what are the difficult problem are you involved in cognos report net and 8 and impromptu if any pls share with us
What is zero-foot print?
What is the use of Cognos scenario?
How do you call a store procedure within a transformation?
In my report i want display sales rep name, country ,city how to achieve this by using repeater table
Can you define materialized view?
