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 advantages of using cognos sql?
What is the use of cognos decision stream?
how can I test reports in cagnos?
A product manager is analysing the sales made for each product, he has requested a report containing data for specific products. To do this we will create a report that includes a prompt page that filters on specific products within specific product subcategory and category.
What are the message flows?
What are the different types of important services used in cognos?
-----------Diff b/w OLAP and RDBMS?
Can the expiration parameter of 365 in the cognos 8 configuration how to increase common symmetric key lifetime in days
What is main advantage datawarehousing over oracle?
how you provide security to reports? How you provide security to packages ?
What is a Query Subject?
What is meant by junk dimension?
Explain what is the main advantage of impromptu over cognos reportnet?
What is the report studio?
how to explain health care project and which reports we can create in health care doain?