Answer / suresh

Hi,
create one datasource query subject in FM. and write a sql
like
select emp.name,emp.salary from emp,salary_grade
where emp.salary between salary_grade.low_salary and
salary_grade.high_salary.

this is called non equal joins. like this you can create
relationship between this two table.

im having a value prompt, in that value prompt im having the values as ABC and CDF, i want to hide the select box in that value prompt? is it possible in cognos?

1 Answers   IBM,

---

what is model and how to create model and how to test model?

8 Answers   IBM,

---

What is the metric store database?

0 Answers  

---

how can we improve performance of the reports?

6 Answers  

---

1. Differences between Merge and Union In Cognos?

0 Answers   Wipro,

---

if we have a value prompt in a prompt page and if we need to pass that prompt value to a sql used in report, what is the sql code? give me example?

3 Answers   ComNet,

---

what is the role of cognos comsultant?what actually it means?pls reply

0 Answers  

---

what is the meaning of aggregation and rollup aggregation? Difference between layout calculation and query calculation? How do you hide the rows that have null values? why we use query studio? what is the use of query studio compared to report studio?

7 Answers   Cap Gemini, iFlex,

---

How to do Performence Tunning in Cognos Reports?

0 Answers  

---

suppose a value prompt contains 100 values and i want to select all values in that prompt....i want ALL option in the value prompt? how can u keep this option in value prompt?

5 Answers   TCS,

---

These are the questions asking in many interviews, so pls help me,,, How did you get requirements from the client? How did you send reports to the client? How did you interact with your client? I mean through e- mail or phone or in any other way?

2 Answers   IBM,

---

What is meant by report studio short cut?

2 Answers  

---