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

Hi Buddies... i want to appear for cognos BI-Author certification. can anyone of you send me cognos latest dump. please help me.. cognoslalitha@gmail.com

4 Answers  

WHAT IS METRIC STUDIO?WHAT IS SCORE CARDS HOW TO IMPLEMENT IT AND WHAT IS THE USE OF SCORE CARD?

1 Answers   IBM,

i'm searching on cognos..i want to know real time scenarios..persons having real time exp or undertaking trainings or who searching on cognos...can send me the details...for proper guidence..for project and interview preparation..pls help me out..my mail-id is ammu2india@gmail.com..hope u will respond as soon as possible..thanks..

0 Answers  

can reportnet supports cubes???

4 Answers   IBM, Wipro,

write a query to display the departments with no employee?

0 Answers   HCL,




How Metrics Studio is better than Report Studio?

0 Answers  

hi, while opening the cognos8 in ie,the home page is coming,while clicking the report studio the blank page will come after it will showing the home page.But by clicking the cognos connection,Query studio in the same page it's open successfully. only for the report,analysis,event studio is not working properly.i didnot understanding the problem.Iam using the cognos8.1 and sql server 2005.and also checking the cognos connection by clicking the run and its success. Any one Knows pls tel me in detail,becoz its very important iam working in report studio...

2 Answers  

how u publish the packages in framework manager

3 Answers   TCS,

Hi I have Most updated Cognos dumps like COG-112(ReportAuthor),COG-122(Admin),COG-132(Meta Data Modeller). 100%score Gurantee. If anyone intrested mail me on kris.bi121@gmail.com

7 Answers  

Hi all, I have a list report with Country, City & Revenue. In the run time i want to hide the particular column. I have tried using Java script but i didn't get any out comes. Please any one share steps for me....

2 Answers  

suppose i want to do drill through a column only for the values which is having more than > 50000. how can i do that?

2 Answers   Mind Tree,

Can anyone tell me which automation tool is used in cognos,is it a testing tool or performance enhancing tool Thanks in advance

2 Answers   SAP Labs,

For more Cognos Interview Questions Click Here
Categories