Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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?

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


Please Help Members By Posting Answers For Below Questions

what is the diff. between a link n a union? what is a custom view? what is the use of unlocking a report ? plz answer to these

2004


Can you explain the advantage of using shortcuts?

1017


Hi Buddies...i am lalitha. i am willing to appear for cognos bi-author certification. can anyone of you send me cognos dump. please please help me.

1818


please please give me some banking calculations in framework manager.

2070


Can you define query studio?

947


What is cognos reporting tool?

1075


what are the errors faced while bursting the reports and how to solve those errors?

1998


What is Online View?

1939


Actually we have 500 users when they run the report display the flage image related country user? How its possible?

2022


What are all the components of Report Studio?

1080


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?

2052


What is a Query Subject?

1072


What are the components of the report studio?

1165


Explain about scorecarding?

2062


What is Metrics designer?

1016