Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 5 Answers
- 8860 Views
- Mphasis, I also Faced
- E-Mail Answers
Answer Posted / s ali
Q3) In SQL server
select top 1 sal from
(select top 2 sal from emp order by sal desc ) emp2
order by sal desc
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
--------------Diff b/w ODS and OLAP?
I have two queries in first query i have to show all values,in second query i have to show 3 values and want to hide 3 values what prompt ur going to use, why that prompt
What is a Framework manager?
What are the ways to import data into catalog?
how many notations are posible(cordinolity)are there in between two tables(one is fact and another is dimension)pls give me a example pls.
------------ Diff b/w MemberCaption and MemberDescription?
We can use a calculated field to dynamically create the burst recipients in Cognos 8. Can we do the same in Cognos ReportNet 1.1?
where you can save the report net documentation in our local system?
What is cognos reporting tool?
explain how to create powerplay reports?
how the values be passed to prompts in report studio? when a data item is dragged n dropped in to report, after the default query generated first which sql will the query query hit for processing means (native or cognos)? plz answers to these questions?
It is possible to test 2 query subjects at a time in CRN1.1 & C8 FWM?
What errors and types of errors you faced in Cognos ReportNet?
Cognos Online Training will be provided. prior training with all real time aspects. Comprehensive training will be given in Datawarehousing concepts , cognos 8.4 and cognos 10 versions. Contact kris.cognos25@gmail.com
what is the difference between list report and crosstab report?
