how to create relationship between emp and salgrade tables
in frameworkmanager?



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

Post New Answer

More Cognos Interview Questions

What is the difference between cognos 8.2 and cognos 8.3?

5 Answers  


wt is the OLAP Scrubbing in Framework manger & use? How can we developed a query items by using alredy existing query items?

0 Answers  


i want to create a crosstab report where product will be on rows year on column and revenue on measure. based on the users selection in value prompt, if user select the August 15, crosstab year column should display values for aug 15, aug 14, aug 13 and aug 12 i.e for last for years but same month. how could we achieve this?

1 Answers   JPMorgan Chase,


What is difference between informatica power mart and power center?

0 Answers  


explain project, package ,model , modelers.........and differences b/w them?

4 Answers   HCL,


What are the roles defined by cognos platform?

0 Answers  


write the sql query to display 5th and 10th row in a table?

5 Answers   CTS, IBM,


How do we implement Check Box Prompt in COgnos Report Studio?

2 Answers  


what happens when date function has taken as attribute

1 Answers   TCS,


WHAT ARE THE DISTNICT VARIABLES?

0 Answers  


Explain the different types of views used in cognos.

0 Answers  


Which service handles requests for cognos connection,query studio and event studio.

3 Answers   HCL,


Categories