Interested to Buy Any Domain ? << Click Here >> for more details...
how to create relationship between emp and salgrade tables
in frameworkmanager?
- 1 Answers
- 4888 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 are the advantages of shortcuts?
Write various indexes used in cognos?
After applying date prompt and when we run the report we
fet from date and todate prompts..so when we enter
todate What do you understand by the term 'aggregate cache'? What is the use of report studio? What is cognos reporting tool? is there any difference between operational database and
data base?if yes what r they? What are the methods by which it non-durable model could be changed into the durable model? Define olap designer? how to perform back drill through in cognos 8 what is the
use of it hi this is bhaskar iam working in Tcs u want any real time
faqs send me your qs i will ans that qs ok this is my id
bhaskarparitala.rao@gmail.com A product manager is analysing the sales made for each
product, he has requested a report containing data for
specific products. To do this we will create a report that
includes a prompt page that filters on specific products
within specific product subcategory and category. Why is auto-regression used in forecasting used on cognos platform? Please Answer this Questions:
1.In FWM We have to create Hierarchies, Condition is we
don't know the correct levels in the Hierarchies, in this
case how can we find out the levels
(year->Quarters->month->day)in data?
2. In FWM Standalone Filter is for Reusable purpose &
Embedded Filter we cant resuse.but is this possible to
convert the Embedded filter to standalone filter?
3.What are the differences between Relational Database Model
& Multi Dimensional Database?
4.In Drill Down/ Drill Up, How to specify the limits for
example in a report there is 6 Drill down is possible, but i
want only 3 Drill downs, the report should not allow 4 Th
Drill Down.How to make this ?
4. What are the limitations in Select and Search Prompt ?
Can you define confirmed dimension?
