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 Direct and Conventional loading?
Actually we have 500 users when they run the report display the flage image related country user? How its possible?
What is Bitmap Index?
What is catalog and types of catalogs in cagonos and which is better?
How do you improve the performance of the Cognos Analytics report
What is a Cube?
What is the use of powerhouse?
What are cognos connection initial page components?
Write various indexes used in cognos?
What are initial page components of Cognos connection?
hi frnds any body have cognos projects plz send me two(or)three projects to my mail adress ramureddy.reddy4@gmail.com.
2. What functional area you worked on.
Explain difference between powerplay transformer and power play reports?
Please Answer this Questions: 1.In FWM We have to create Hierarchies, Condition is we don't know the correct levels in the Hierarchies, in this case how can we find out the levels (year->Quarters->month->day)in data? 2. In FWM Standalone Filter is for Reusable purpose & Embedded Filter we cant resuse.but is this possible to convert the Embedded filter to standalone filter? 3.What are the differences between Relational Database Model & Multi Dimensional Database? 4.In Drill Down/ Drill Up, How to specify the limits for example in a report there is 6 Drill down is possible, but i want only 3 Drill downs, the report should not allow 4 Th Drill Down.How to make this ? 4. What are the limitations in Select and Search Prompt ?
How create measures and dimensions?
