Interested to Buy Any Domain ? << Click Here >> for more details...
how to create relationship between emp and salgrade tables
in frameworkmanager?
- 1 Answers
- 4908 Views
- TCS, I also Faced
- E-Mail Answers
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
What is cognos reporting tool?
It is possible to test 2 query subjects at a time in CRN1.1 & C8 FWM?
how to explain tne project at the time of interview? where to start and how to end? plz explain in detail thax in advance
Can you define fan trap?
Why cognos decision stream is used?
is cognos 7 is better than cognos 8
Actually we have 500 users when they run the report display the flage image related country user? How its possible?
How to do Performence Tunning in Cognos Reports?
how can I test reports in cagnos?
what is the use of backward drilling in cognos 8?is it possible?whats the uws of it?
What condition do we use in Cognos when multiple path exits to reach the fact table.(i.e in BOXI we use CONTEXT when multiple path exit)
Hi All, I have 1.6 years of experience in cognos in India. I always wanted to do a MS program to earn some money in US. But I think I am little late in taking the decision. As If I have to write my GRE it will be August or September of 2012 and will have to apply for fall 2013 as fall 2012 admissions are almost done now. So my concern is how will be my career do if my MS is at this stage,. i,.e. 3 years experience in Cognos and 2 years MS program in and again looking for job in U.S. Have I been too late in taking the call? I heard that MIS (Managing Information Systems) is having very good placements now. So guys, please advice me in taking the decision to have a good career and also in terms of earning money as I have few financial problems to solve (which I am hoping to solve when I get job in US after completion of my MS program). Thanks a lot friends. I really appreciate and thank one and all for their valuable comments in this site.
how the values be passed to prompts in report studio? when a data item is dragged n dropped in to report, after the default query generated first which sql will the query query hit for processing means (native or cognos)? plz answers to these questions?
Define report item?
--------------Diff b/w ODS and OLAP?
