how to create relationship between emp and salgrade tables
in frameworkmanager?
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.
Is This Answer Correct ? | 1 Yes | 1 No |
WHAT IS METRIC STUDIO?WHAT IS SCORE CARDS HOW TO IMPLEMENT IT AND WHAT IS THE USE OF SCORE CARD?
What are the steps to create DMR model in FM? Give me brienf discription as interview point of you?
What is cognos reporting tool?
Did you find any differences in bursting feature between reportnet 1.1 & cognos 8? what are the differences?
What's use of a Master Detail report in Cognos? I mean what's the advantage? Please Explain.
i have a table with 3 columns country,empname,salary and i want the query for get the name of the employees who is getting top 2 nd highest salary for individual country? Thanks in advance
What is the information present in the cognos configuration file?
what is the difference between Cognos EP7 series and Congos8?
Write various indexes used in cognos?
What do you understand by the cognos?
What are the types of studio present in Cognos?
what is the difference between group and association?