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 the difference between regular dimension and derminant?
What is defined as catalog and types of catalogs in Cognos?
i have one file i saved in csv how can i take these file into framework manager
What is the enterprise class platform architecture of cognos 8?
What are all the types of hierarchies?
Can you explain dynamic query mode?
What is meant by Reportstudio shortcut?
2. We have asked to create a repots showing sales by region in order to determine which regions are generating the most revenue and highest sales volume. The report needs to include the revenue and quantitiy sold of each subcategory with in category.
What do you understand by the term 'dynamic cube'?
is there any difference between operational database and data base?if yes what r they?
how to explain health care project and which reports we can create in health care doain?
please can you give me some banking domine calculations developed in framework manager plzzzzz thank you.
What is set to be Cognos configuration?
------------- How to identify the Revenue Column in Report?
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......