Question { Mphasis, 7620 }

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?

Answer

q4) Scope is used to join the regular dimensions and measure dimensions to perform multi dimensional analysis such
as drill down and drill up.
relationship is join the two tables (specifies cardinality 1-1,1-n

Question { IBM, 8435 }

What is Cardinality b/w Fact to Fact?

Answer

through best of my knowledge there is no cardinlity fact to fact

Question { IBM, 7014 }

difference between boxtype and visiable

Answer

Boxtype does not occupy any space in the report
visible is ocuupy the space