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 is Bitmap Index?
Can you define snapshot?
hi all i am searching for cognos jobs pls inform about the jobs to:santosh.koora@gmail.com
What is called cognos reporting tool?
is there any difference between operational database and data base?if yes what r they?
What is meant by alternate drill down with ex?
Tell me about Dnamic and Static Dashboards?
What are the types of catalogs in cognos?
how can you get the errors in job? when loops are araised we get error?
How to a create header dynamically in a crosstab report in cognos 8.1?
Why cognos decision stream is used?
-------------How you design DWH?
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)?
How do you improve the performance of the Cognos Analytics report
What are all types of Batches?