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
- 8852 Views
- Mphasis, I also Faced
- E-Mail Answers
Answer Posted / venkat b
Q3.Answer: select max(sal) from emp where sal<(select max
(sal) from emp
| Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
What is the advantage of using shortcuts?
What is the difference between regular dimension and derminant?
-----------------What is Determination Model?
Explain the difference between powerplay transformer and power play reports?
hi..i'm searching on cognos.i want to know some real time explanation..persons who have real time exp and who r searching in this field..can u send ur mail-id..my mail-id is dhaanuus@gmail.com..hope u will respond as soon as possible..
What do you mean by Drill down and Drill Up?
What is the difference between ‘macro’ and ‘prompt?
is cognos 7 is better than cognos 8
What is the diff between the following Report output-- HTML O/P, PDF O/P, EXCEL 2000 and EXCEL 2003 of report outputs? Listout main differences?
what is the difference between querystudio in reportnet and cognos8
What is defined as data mining?
--------------Explain Table of contents?
We can use a calculated field to dynamically create the burst recipients in Cognos 8. Can we do the same in Cognos ReportNet 1.1?
What is a dimension?
How do we convert from Numeric to be Words?
