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
- 9030 Views
- Mphasis, I also Faced
- E-Mail Answers
Answer Posted / abd hfz
Q1) You can drag & drop a blank column where u set status as
High/ low using boolean var.
Q3) select sal from emp order by sal desc limit 1,1
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is an olap designer?
Write some methods to apply securities in framework manager model?
how to explain health care project and which reports we can create in health care doain?
What is the difference between drill through, drill across?
What is the information present in the cognos configuration file?
What is difference between content store and content manager?
9. What was the most complex type of report you dealt with?
-----------------What is Direct and Conventional loading?
What are the types of folder present in cognos?
Define query items?
Give the advantages of cognos?
What is the advantage of using shortcuts?
Give me any example of semi and non additive measures?
how to connect datamarts
What is difference between page break and section report?
