Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

Why is auto-regression used in forecasting used on cognos platform?

1021


What do you understand by the term 'model durability'?

1015


How do you improve the performance of the Cognos Analytics report

1036


i have one file i saved in csv how can i take these file into framework manager

2083


How we check the errors before running the report?

1000


What are query items?

1023


what is a prompt value in report studio and variables ?

2716


Can you define report item?

1036


What are all the types of report?

1096


how do you deploy a report in cognos 8 to run in maximo6? what r the steps in maximo??

2421


Please explain the different stages in creating a report in cognos report net?

1008


how you create security to reports?

1054


where you can save the report net documentation in our local system?

1047


write a query to display the departments with no employee?

1971


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.

2110