how to create relationship between emp and salgrade tables
in frameworkmanager?
- 1 Answers
- 4493 Views
- TCS, I also Faced
- E-Mail Answers
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 are all the components of Report Studio?
what are the components in the cognos connection page consists (eg: my folder, public folder,directions, schedule management tool etc.....)
-----------Diff b/w OLAP and RDBMS?
what is the difference between native sql and cognos sql?
How to deploy from one server to another server?
How to publish a package by running Java Script?
What are the advantages of using cognos sql?
What is the difference b/w macros and prompt?
What are slice and dice?
What is drill down and slicing and dicing whats the difference between them?
Explain the difference between powerplay transformer and power play reports?
What is difference between primary key and unique key constraints?
What is the difference between Section and Section using Master/Detail in Cognos 8 Report Studio? I tried these both options many times on lists and crosstabs, but dint find any difference. So please give the answer in detail with example.
7. What is performance tuning?
how you create security to reports?
