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
New coloums are added in database, then how you know in report level
what are the dimensions that you have in your current project?list them?
Can you define slice?
please can you give me some banking domine calculations developed in framework manager plzzzzz thank you.
i was asked what are the caluclations done by you in your report? plz give reply
What do you understand by the term 'aggregate advisor?'
What is the difference between static and dynamic conditions?
What is the enterprise class platform architecture of cognos 8?
hi frnds any body have cognos projects plz send me two(or)three projects to my mail adress ramureddy.reddy4@gmail.com.
What you mean by drill across?
how to perform back drill through in cognos 8 what is the use of it
How to a create header dynamically in a crosstab report in cognos 8.1?
How to generate the Catalog in Cognos? Basically all post describing generating the Catalog from cognos impromptu . Is there any way to generate the Catalog using Cognos Administration or Framework Manager?
Can you define metrics designer?
What is the difference between regular dimension and derminant?
