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 cognos 8.2 and cognos 8.3?
wt is the OLAP Scrubbing in Framework manger & use? How can we developed a query items by using alredy existing query items?
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?
What is difference between informatica power mart and power center?
explain project, package ,model , modelers.........and differences b/w them?
What are the roles defined by cognos platform?
write the sql query to display 5th and 10th row in a table?
How do we implement Check Box Prompt in COgnos Report Studio?
what happens when date function has taken as attribute
WHAT ARE THE DISTNICT VARIABLES?
Explain the different types of views used in cognos.
Which service handles requests for cognos connection,query studio and event studio.