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 can I schedule reports in cognos?
how u will determine the performence tune will occur either in report or system
What is meant by alternate drill down with ex?
How can we Maintain the Cube Security by Category level and Dimension level ?
hi friends pls forward impropmtu interview question
1. Explain your project.
Why is auto-regression used in forecasting used on cognos platform?
What is set to be Cognos configuration?
What are the different uses of a repository manager?
Can you define metrics designer?
What is a Folder?
What is the report studio?
Is it possible to join multiple Databases in a Catalog?
what are the difficult problem are you involved in cognos report net and 8 and impromptu if any pls share with us
Can you define cognos decision stream?
