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
- 9805 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
Can you define set to be cardinality?
Can you define metrics designer?
Is it possible to join multiple Databases in a Catalog?
What is set to be cardinality?
What is difference between informatica power mart and power center?
What are all types of Batches?
How Metrics Studio is better than Report Studio?
What are all the types of gateway used in Cognos?
Can you define query studio?
It is possible to test 2 query subjects at a time in CRN1.1 & C8 FWM?
What are the advantages of cognos?
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 cognos impromptu?
What are the types of studio present in Cognos?
How to join multiple db in catalog?
