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 / 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 View All Answers
What are the roles defined by cognos platform?
Explain difference between powerplay transformer and power play reports?
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
Can you define cognos impromptu?
What is set to be Cognos configuration?
------------ Diff b/w MemberCaption and MemberDescription?
What are shortcuts? Where it can be used? What are the advantages?
Name the types of report?
Write types of folders present in cognos?
Can you define drill across?
What is the use of Cognos scenario?
Can you define a catalog and types of catalogs in cognos?
What are all types of Batches?
What are initial page components of Cognos connection?
Can you define cognos powerplay?