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 are initial page components of Cognos connection?
What is the enterprise class platform architecture of cognos 8?
What is cognos connection?
how u burst the reports? if u r bursted reports is not reached to destination how u identify???
I have 7500 rows. I need all rows in single reports. Which type of prompt we have used retrieving all rows and show in a report? We have dynamical queries q1, q2, q3, q4, q5. If customer selects the particular, query that only show in execution report. In case it may more then one, how do you execute the particular query item in report page? What are the difference bt OLDP and OLAP?
WHAT IS METRIC STUDIO?WHAT IS SCORE CARDS HOW TO IMPLEMENT IT AND WHAT IS THE USE OF SCORE CARD?
7. What is performance tuning?
What are the components used in web tier?
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.
What are shortcuts? Where it can be used? What are the advantages?
What is the difference b/w macros and prompt?
What is model filter?
How to limit the cut,copy and paste operations for an user in reportlevel? Can anyone please send me the steps as i am new to cognos?
how you migrate reports to cognos 8 from previous versions?
New coloums are added in database, then how you know in report level
