Interested to Buy Any Domain ? << Click Here >> for more details...
In framework Manager, what is a stitch query and is it good
or bad?
- 2 Answers
- 9570 Views
- Polaris, I also Faced
- E-Mail Answers
Answer Posted / sureshkumar
In cognos Stitch query is very useful. When we pull data from 2 different fact table using conformed dimension, cognos will create full outer join with 2 fact table and use coleace function to get first non null values.
For example:
I have actual sales(Actual Sales Fact) and target sales(Target Fact table) and Time dimension. Here time dimension is a conformed dimension.We may have target for particular period and we may not have actual sales for that period. so in this scenario if we use inner join only matching records will come but we need target sales even though there is no actual sales. thats why cognos will make full outer join and use coleace to get first non null values.
Month Actual Target
201401 300 400
201402 null 300
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
what is the role of cognos comsultant?what actually it means?pls reply
7. What is performance tuning?
How to create model and how to test model?
Can you explain the advantage of using shortcuts?
How to deploy from one server to another server?
What is a dimension?
which type of project we r going to snowflake schema
Give me any example of semi and non additive measures?
What is a Query Subject?
Why cognos decision stream is used?
What are the types of hierarchies?
Explain is there any comparison available for cognos reportnet vs crystal reports?
How to apply securities for reports in cognos connection?
Can you define cognos powerplay?
Define olap designer?
