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
- 9708 Views
- Polaris, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / prasanthi.u
in frame work manager, stitch query is nothing but it will
stitch the two querys.
for example i have 2 querys like Q1 and Q2 and i stitch these
2 querys and found Q3 with the full outer join
| Is This Answer Correct ? | 1 Yes | 4 No |
Suppose you have a report with no data , when you run the report in report studio how can you tell the end user , that it has no data , while he runs it?Is it possible ? if so how?
What is slicer & dicer ? what is sub session parameter ?
1.tyes of security in cognos?.how to use rank function? 2.what is content store? 3.what is content manager? 4.how 2 use rank function?
how to perform single sign in cognos by using url?
what is sdibling function tell me the some functions
I have 3 dataitems in a list username,transaction type,transaction amount. In transaction type i have 3 types 'add','update','delete', i have almost 750 rows. After displaying the list report i want to know no. of add's,update's,delete's in 3 different rows
i have taken quantity on ANx-axis & months on y-axis(months r not in oreder )when i run the reoprt i need months in proper order .how can i do this ?
tell me two or three issues from client side and how to solve those issues?
Define dimensions?
Once reports are delivered to client, how will they inform back? If they are experiencing any problem in the reports.
in single column there is india and malaysia and uk canada and dubai,saudi.ok i need using valuable prompt i select asian country will be display india malaysia and i will select eurobe country only display uk canada.pls tell me any how do set this concept using valuable prompt
how u will determine the performence tune will occur either in report or system
Teradata 
