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 / venkat b
Q3.Answer: select max(sal) from emp where sal<(select max
(sal) from emp
| Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
please can you give me some banking domine calculations developed in framework manager plzzzzz thank you.
What is the difference between regular dimension and derminant?
Why need staging area database for dwh?
What is the difference between a cascading report and drill through the report?
what is the difference between filter and condition?
how to develop dynamic dashboards, and what is the difference between static and dyanmic dashboards in report studion and need with example. plz mail me on this email id vasucognos4@gmail.com
In my report i want display sales rep name, country ,city how to achieve this by using repeater table
It is possible to test 2 query subjects at a time in CRN1.1 & C8 FWM?
What are the types of hierarchies?
can anyone provide link to download cognos 7.2 version for download along wiht installation and configuration steps tx in advance
What are the different kinds of panes included in cognos?
Mention the difference between ‘macros’ and ‘prompt’?
whats the difference between previous version of cognos and cognos 8 BI?
how many reports do u create in ur project?i don't have real time exp..tell me based on ur exp..for interview pt of view,don't say it depends on ur project and u? thanks in advance..
Hi All, I have 1.6 years of experience in cognos in India. I always wanted to do a MS program to earn some money in US. But I think I am little late in taking the decision. As If I have to write my GRE it will be August or September of 2012 and will have to apply for fall 2013 as fall 2012 admissions are almost done now. So my concern is how will be my career do if my MS is at this stage,. i,.e. 3 years experience in Cognos and 2 years MS program in and again looking for job in U.S. Have I been too late in taking the call? I heard that MIS (Managing Information Systems) is having very good placements now. So guys, please advice me in taking the decision to have a good career and also in terms of earning money as I have few financial problems to solve (which I am hoping to solve when I get job in US after completion of my MS program). Thanks a lot friends. I really appreciate and thank one and all for their valuable comments in this site.