1. Categories >> Software >> Data Warehouse >> Cognos
  2. Suggest New Category

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?

Question Posted / shaan

Answers were Sorted based on User's Feedback



Q1. We have a crosstab report which is having product, region and Revenue information. Now the requ..

Answer / venkat b

Q3.Answer: select max(sal) from emp where sal<(select max
(sal) from emp

Is This Answer Correct ?    4 Yes 2 No

Q1. We have a crosstab report which is having product, region and Revenue information. Now the requ..

Answer / maulesh

YES

Is This Answer Correct ?    1 Yes 0 No

Q1. We have a crosstab report which is having product, region and Revenue information. Now the requ..

Answer / thrinadhn

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

Is This Answer Correct ?    0 Yes 0 No

Q1. We have a crosstab report which is having product, region and Revenue information. Now the requ..

Answer / 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

Q1. We have a crosstab report which is having product, region and Revenue information. Now the requ..

Answer / 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

More Cognos Interview Questions

HOW TO DEVELOPE THE DRILLTHROUGH REPORTS?

4 Answers   IBM, TCS,

hi cognos Experts what are the enhancements in cognos 10 than cognos 8.4?Pls Ans Me........

1 Answers  

What is limited local? and the uses?

2 Answers   Ness Technologies,

what are typees of dimensions

11 Answers   HCL,

what is alias what is shortcut what ia alias shortcut and diff among them if u know explain clearly

2 Answers   TCS,




in single column there is india and malaysia and uk canada and dubai,saudi.ok i need using valuable prompt i select asian country will be display india malaysia and i will select eurobe country only display uk canada.pls tell me any how do set this concept using valuable prompt

0 Answers  

What is looping and how to avoid it in framework manager?

0 Answers  

suppose a value prompt contains 100 values and i want to select all values in that prompt....i want ALL option in the value prompt? how can u keep this option in value prompt?

5 Answers   TCS,

How to create a Left Outer Join in FM? Please explain.

2 Answers   Cisco,

What do you understand by user class in cognos?

0 Answers  

In which types of reports does the page breaks applicable in Cognos...?

1 Answers   IBM,

How do you Parametermap variables in Quiries?

0 Answers   TCS,

For more Cognos Interview Questions Click Here
Categories