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 |
Can you please tell me the limitation of Excel file when exporting from report to Excel? I can export to HTML and PDF but I can't export to Excel. The report is more than 13000 rows. When exporting to Excel, system can view it. After that, I save the report to an Excel file. The size of Excel file is more than 11 MB. But I can't view this file by Excel. Please help me to solve this problem. Thanks!
Once reports are delivered to client, how will they inform back? If they are experiencing any problem in the reports.
What are the considerations regarding performance kept in mind while setting up cognos?
wht is the reason for using sql queries in the report 1. inorder drag the items to conatiner we can use use packages but wht is the neccessity of using sql queries to drag the items into the container
How to generate cubes in cognos?
if at all asked.wat is u r cube name?wat would be a appropriate answer? plz help me
How do you improve the performance of the Cognos Analytics report
How to add 2 different colors for alternative rows? i.e in a report all rows colors in alternative colors(2 colors)
What are the themes in a data warehouse?
New coloums are added in database, then how you know in report level
What is looping and how to avoid it in framework manager?
Hi, In My Table i am having a Column Emp ASa Fullname In My Report I WAnt First name&Lastname?how I'll Get This One?Pls Ans Me