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 Posted / maulesh

YES

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are initial page components of Cognos connection?

611


Can you define confirmed dimension?

636


What is catalog and types of catalogs in cagonos and which is better?

521


What is Fullouterjoin?

1555


What are the themes in a data warehouse?

590






how to create cubes in transformer ?

620


tell me two or three issues from client side and how to solve those issues?

1705


What is an olap designer?

532


I have ten columns that needs to be totalled... but some columns are empty...how do i get sum all the columns even if sum are empty? Can i get a total of the rows instead of columns? if yes, what is the function to be used?

1534


What are all the different types of prompt in cognos?

550


What is set to be Cognos configuration?

607


how can you get the errors in job? when loops are araised we get error?

1657


Can you explain new content durability?

575


Can you define snapshot?

557


What is the use of powerplay web viewer in cognos?

559