how to create relationship between emp and salgrade tables
in frameworkmanager?
Answer Posted / 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 |
Post New Answer View All Answers
What is main advantage datawarehousing over oracle?
Can you define set to be cardinality?
Define metrics studio?
Can you define a datastore in cognos?
how u will determine the performence tune will occur either in report or system
What is a Query Subject?
What is a Datastore in Cognos?
What are all the types of report?
What are the message flows?
Explain is there any comparison available for cognos reportnet vs crystal reports?
What is Metrics designer?
what do u mean by bridge group? where we r using this one?
How to a create header dynamically in a crosstab report in cognos 8.1?
What is called materialized view?
what is the main advantage of impromptu over cognos reportnet?