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 do you improve the performance of the Cognos Analytics report
A product manager is analysing the sales made for each product, he has requested a report containing data for specific products. To do this we will create a report that includes a prompt page that filters on specific products within specific product subcategory and category.
What is zero-foot print?
where you can save the report net documentation in our local system?
2. What functional area you worked on.
Can you define cognos decision stream?
how can you get the errors in job? when loops are araised we get error?
What is the difference between set functions and filter function in dimensional data?
In my report i want display sales rep name, country ,city how to achieve this by using repeater table
what is the procedure for scheduling conditional rendering?
-----------Diff b/w OLAP and RDBMS?
what is online view?
How we check the errors before running the report?
how u will determine the performence tune will occur either in report or system
Tell me about Dnamic and Static Dashboards?