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
- 9671 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
tell me two or three issues from client side and how to solve those issues?
How to deploy from one server to another server?
What are all the components of Report Studio?
how many notations are posible(cordinolity)are there in between two tables(one is fact and another is dimension)pls give me a example pls.
How security is concerned with Reportnet? Explain its implementing steps.
What is the difference between regular dimension and derminant?
what is the difference between native sql and cognos sql?
What are the different uses of a repository manager?
Can you define a catalog and types of catalogs in cognos?
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.
Define catalog in cognos and write its various types?
what are the dimensions that you have in your current project?list them?
What DB View and Bus View?
After applying date prompt and when we run the report we
fet from date and todate prompts..so when we enter
todate What is difference between page break and section report?
