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
- 9684 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
Explain what is the main advantage of impromptu over cognos reportnet?
What is the importance of having monitor service in cognos?
We can use a calculated field to dynamically create the burst recipients in Cognos 8. Can we do the same in Cognos ReportNet 1.1?
What is the use of cognos decision stream?
Can we create 2 conditions in report expression of a single data item..Eg: I added 2 new dataitems each one should show revenue for Q1 and Q2..Pls advice
WHAT ARE THE DISTNICT VARIABLES?
Can you define transformer?
How Metrics Studio is better than Report Studio?
Explain is there any comparison available for cognos reportnet vs crystal reports?
What's the limitation of 'Page Footer' in Report Studio? e.g. If I have an activity prompt (list of activities in a Search & Select Prompt) and selected around 2500 activites from the 'Activity' Search & Select Prompt and when I ran the report I got a message "#! Overflow" in page footer. Can somebody please tell me what's max. limit. I tried with around 300 activities and page footer displayed the activities. Your help will be appriciated.
What are all the advantages of Cognos?
Write various indexes used in cognos?
------------------What is Inline Query?
How security is concerned with Reportnet? Explain its implementing steps.
which type of project we r going to snowflake schema
