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 / 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
What are the types of security?
Give the advantages of cognos?
if ur report having report filter save the report.open u r report in cc the report filter doesnt work means it does n't any values what we do for this situation?where we rectify this?please please ans me......
What are the components of the report studio?
Can you define drill across?
Explain is there any comparison available for cognos reportnet vs crystal reports?
What do you understand by user class in cognos?
what is model and say about process how to create model and how to test model?
New coloums are added in database, then how you know in report level
How to publish a package by running Java Script?
what are the errors faced while bursting the reports and how to solve those errors?
What is the diff between cognos 8.1 & cognos 8.2 & cognos 8.3? Measn whet are the enhancements are added in new versions(8.2& 8.3)?
What is a Framework manager?
What is a Folder?
what are the names of the reports that you prepared?