Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / joydeep
when we pull in facts from different tables into the report
that might be joined using a conformed dimension, cognos
does a combination of coalesce and full outer join to
create a stitch query to avoid the loss of data. when you
go through the SQL generated for the report if you see a
combination of coalesce and a full outer join that means
you are dealing with stitch queries.
| Is This Answer Correct ? | 8 Yes | 3 No |
Post New Answer View All Answers
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
Can you define query studio?
What is main advantage datawarehousing over oracle?
what are the limitations of cognos reportnet? What are the enhancements in reportnet ?
Name the types of report?
What are the types of catalogs in cognos?
3. The vice president of sales has requested a graphical display of the same information provided in our last crosstab report (whatever I mentioned in above question) for an up coming presentation. We need to provide a chart report that shows which regions generate the most revenue and sales volume.
Suppose you run a report with empty data, how will you inform the end user that it has no data while running the report in report studio? Is it possible, if so how?
How to publish a package by running Java Script?
Why is auto-regression used in forecasting used on cognos platform?
what are the components in the cognos connection page consists (eg: my folder, public folder,directions, schedule management tool etc.....)
WHAT IS METRIC STUDIO?WHAT IS SCORE CARDS HOW TO IMPLEMENT IT AND WHAT IS THE USE OF SCORE CARD?
Cleared COG-112 with 100% score today. What next certification should i go for?
What is difference between primary key and unique key constraints?
What do you understand by the term 'aggregate cache'?
