Answer Posted / santhosh kumar s
When dimension is joined with two fact tables this stitched
Query takes place.
EX: Say table Dim_Product ,fact_retail sales and fact_sales
If we write query for this like dim_product inner join with
fact_retail sales and inner join with fact_sales
Result:We will get wrong data(will get multiplied with one
record with all the records in other table)
To over come this:
Should write two seperate queries and should join them .
Result:Will get required data
Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is the difference b/w macros and prompt?
how to merge 2 crosstabs thans
What is main difference mapplets and mapping?
What is the use of powerplay web viewer in cognos?
------------- How to identify the Revenue Column in Report?
What are various types of gateways in cognos?
What is metric store database?
After applying date prompt and when we run the report we
fet from date and todate prompts..so when we enter
todate What do you understand by the term 'aggregate advisor?' What is the difference between the content store and content manager? how to explain health care project and which reports we can
create in health care doain? How to do Performence Tunning in Cognos Reports? Hi.. friends, dis Bhaskar p.if any of u having realtime
scenerios.. plz send to me.. my mailid s
bhaskarparitala.rao@gmail.com
send ASAP.. waiting for reply.. Why cognos scenario is used? Name the types of gateway?