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
- 7662 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 Online View?
what are all the versions of cognos and cognos8 as well as mention all the advantages nd disadvantages in cognos8 versions. any one plz answer this question.
----------------------What are the User Securities?
Give the advantages of cognos?
What are initial page components of Cognos connection?
-----------With out using DrillThrough how to do Reports?
Can you define report item?
how you migrate reports to cognos 8 from previous versions?
what is the difference between list report and crosstab report?
What is a Framework manager?
----------------Diff b/w Dimensional modeling and Relational modeling?
Define query items?
How do you improve the performance of the Cognos Analytics report
what are the dimensions that you have in your current project?list them?
What do you mean by drill across?
