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

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can we Maintain the Cube Security by Category level and Dimension level ?

1951

What is the difference between static and dynamic conditions?

595

What is the report studio?

593

-----------------What is Determination Model?

1689

Can you define bitmap index?

590




what are the dimensions that you have in your current project?list them?

1599

What are the components of the report studio?

632

Can you define drill down and drill up?

635

What is called materialized view?

588

Is it possible to join multiple Databases in a Catalog?

638

What are types of batch available in cognos?

556

what is online view?

1515

I have a reports on cognos ep7series version3 with database SQl2000.Now i am migrating database SQL2000 to SQL2005.Then What happens to cognos reports and also there is reports cubes then how can i handle this problem please give me step by step solution b'coz i am new to cognos ep7series

1705

What is cognos reporting tool?

609

I have two queries in first query i have to show all values,in second query i have to show 3 values and want to hide 3 values what prompt ur going to use, why that prompt

1822