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 conditional Formatting?
write a query to display to 10 max record from the employee table?
What is the deployment requirements used in cognos?
what are versions of cognos from starting release to latest in the market?
How to create a dynamic column name in Cognos?
6 Answers Aditya Birla, Polaris,
we are in a trail to create a crosstab with rolling months as columns,i mean we have a crosstab with LOB as rows and loan amount as measure,coming to the main problem we have to create dynamically changing column in the columns of the crosstab.The requirement is ...we must have two dynamic columns like feb 08 and feb07.For example if current date is feb 28,we have to get the loan amount from 1st of feb to 27 of feb 2008 as feb08 and loan amount from 1st of feb to 27th of feb 2007 as feb07 columns.Please suggest us the possible way....thanks in advance....
Cleared COG-112 with 100% score today. What next certification should i go for?
What are products of cognos?
using of matric studio we can developed to scorecard ... what is the meaning by scorecords
first of all i want say thanks to Zilanibasha, As u said that now these days Cirtification in cognos8 is only possible. Will u like to tell me in detail How i apply for cirtification As i m very much Interested.
Can you define query studio?
What is the difference between low affinity and high affinity connections?