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 the difference between drill down and drill through?
10 Answers DELL, Deloitte, Systime,
how to connect datamarts
How to create a cube in Transformer? What is the process? Please mention process thank u
Tell me about Dnamic and Static Dashboards?
What is a Transformer?
Can you define pivot?
how to convert crosstab into list?
----------------What is meant by DSS?
3. What was the size of your cube?
what is the difference between list sequel and cross tab sequel?
In framework Manager, what is a stitch query and is it good or bad?
Explain the difference between native sql and cognos sql?