Interested to Buy Any Domain ? << Click Here >> for more details...
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
------------- How to identify the Revenue Column in Report?
where you can save the report net documentation in our local system?
What condition do we use in Cognos when multiple path exits to reach the fact table.(i.e in BOXI we use CONTEXT when multiple path exit)
What is a Datastore in Cognos?
Which studio is used to create reports?
Define the cognos reporting tool?
What is the use of cognos decision stream?
Can you define folder?
What are the methods by which it non-durable model could be changed into the durable model?
how can I test reports in cagnos?
How can create users and permissions in cognos?
2. What functional area you worked on.
What do you understand by ‘ibm predictive maintenance and quality’?
1.WHAT IS XML SPECIFICATION WHAT IS PURPOSE,WHERE YOU ARE GOING TO USE.2 DIFFERENCE BETWEEN RENDER VARIABLE AND CONDITIONAL BLOCK.3.WHAT IS LINK AND SEGMENT.4.WHAT IS CONDITIONAL LAYOUT.5. DIFFERENCE BETWEEN DETAIL FILTER AND SUMMERY FILTER AND HOW YOU ARE GOING DEFINE IN SQL (DETAIL AND SUMMARY FILTER ).. WELL THESE QUESTION I BEEN FACED IN IBM COULD SOMEBODY GET SOLUTIONS PLZ..THANKS IN ADVANCE
I have ten columns that needs to be totalled... but some columns are empty...how do i get sum all the columns even if sum are empty? Can i get a total of the rows instead of columns? if yes, what is the function to be used?
