Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / itesh biswal
Simple man
The query from two fact table or two query from 2star
schema with a confirmed dimension always right full outer
join query with a Coalesce of confirmed dim column.....
when u are building a query from 2 fact table but
without a confirmed dimension or having confirmed dimension
not using in query set ,it will right a stitched query
using rsum() function to create his own key and without
coalesce function ....that’s it
And don’t forget you should always try to avoid this
Enjoy
| Is This Answer Correct ? | 2 Yes | 5 No |
Post New Answer View All Answers
What is the difference between drill through, drill across?
Can you define confirmed dimension?
How we check the errors before running the report?
Actually we have 500 users when they run the report display the flage image related country user? How its possible?
is cognos 7 is better than cognos 8
What is metric store database?
--------------Explain Table of contents?
What is the difference between a cascading report and drill through report?
how to test reports in cognos?
What is the advantage of using shortcuts?
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?
What do you understand by the term 'aggregate cache'?
--------------Diff b/w ODS and OLAP?
Can you define set to be cardinality?
Define olap designer?
