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 / s ali
Q3) In SQL server
select top 1 sal from
(select top 2 sal from emp order by sal desc ) emp2
order by sal desc
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What do you understand by the cognos?
Can you define query studio?
what is catalog and types of catalogs in cagnos and which is better?
what are the difficult problem are you involved in cognos report net and 8 and impromptu if any pls share with us
What are the steps to import the two data sources in framework manager?
hi, this is harish. i had finsihed cognos course recently.can some one help in the area of project explination, interview questions,real time scenarious....this is my maild id nanagupta907@gmail.com
3. The vice president of sales has requested a graphical display of the same information provided in our last crosstab report (whatever I mentioned in above question) for an up coming presentation. We need to provide a chart report that shows which regions generate the most revenue and sales volume.
What are the considerations regarding performance kept in mind while setting up cognos?
What is a Query Subject?
What are the different types of reports present in cognos?
how u burst the reports? if u r bursted reports is not reached to destination how u identify???
What do you understand by the term 'aggregate cache'?
What is cognos reporting tool?
---------------Describe OLAP Reporting and RDBMS Reporting?
HI, If anybody is having C2020-625 - IBM Cognos 10 BI Data Warehouse Developer, kindly send the same to shiju.rajs@gmail.com. Thanks