Answer Posted / saj
A query that uses multiple facts from different underlying
tables is split into separate queries for
each underlying fact table. Each single fact query refers to
its respective fact table as well as to the
dimensional tables related to that fact table. Another query
is used to merge these individual queries
into one result set. This latter operation is generally
referred to as a stitched query. You know that
you have a stitched query when you see coalesce and a full
outer join.
A stitched query also allows IBM Cognos software to properly
relate data at different levels of
granularity
| Is This Answer Correct ? | 7 Yes | 1 No |
Post New Answer View All Answers
Hi All, Is there any way to check whether a value is selected in a Multi-select tree prompt? I have a tree prompt and want to get to know whetehr which values user has selected,i want to so that values on the top of the report. I Have used that paramDisplayValue('paramername'),But it will display only last selected value. For Example i have tree prompt with one level Region- >country->states If user select region Asia it will dislay the all the Countries in that region and then if user select India it will display the states related to india only Suppose Hierachy look like this: Asia->India->Andhra Pradesh. I want to show this hierachy on the top of the report How it is possible? Can you please help me?
9. What was the most complex type of report you dealt with?
what is the procedure for scheduling conditional rendering?
What is a Transformer?
Can you define metrics designer?
Can you explain a cognos controller?
Define datastores in cognos?
Diff b/w Crossproduct and Outerjoin?
Explain informatica architecture?
What is the use of Cognos scenario?
What are the ways to import data into catalog?
Give me any example of semi and non additive measures?
how you provide security to reports? How you provide security to packages ?
What you mean by drill across?
Can you define confirmed dimension?
