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
Why is auto-regression used in forecasting used on cognos platform?
What do you understand by the term 'model durability'?
How do you improve the performance of the Cognos Analytics report
i have one file i saved in csv how can i take these file into framework manager
How we check the errors before running the report?
What are query items?
what is a prompt value in report studio and variables ?
Can you define report item?
What are all the types of report?
how do you deploy a report in cognos 8 to run in maximo6? what r the steps in maximo??
Please explain the different stages in creating a report in cognos report net?
how you create security to reports?
where you can save the report net documentation in our local system?
write a query to display the departments with no employee?
If we are migrating lower version of Cognos reports (e.g. from Ver 7.0 to Cognos 8) then how we migrate Impromptu Catalog (ver 7.0) in Cognos 8? Do we create FM model for that? Please explain.