How do you find what type of trap is there by seeing the
report?
Answer Posted / tarukhemu
Consider you have one dimension linked to two fact tables. One fact contains branch wise revenue and another fact contains branch wise sales. For example:
Fact 1: Branch Revenue
101 1000
201 2000
201 1500
Fact 2: Branch Sales
101 5
201 10
Now if you want to display Branch,Revenue as well as sales,then the data in report will appear as follows:
Branch Revenue Sales
101 1000 5
201 2000 10
201 1500 10
As per Fact 2,Branch 201 has Sales=10,but in report it displays Sales as 10+10=20,which is wrong.
Hence by looking at the report data,you can identify a trap.
Note: This is a case of Chasm Trap
Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
1. 101 vinay hyderabad 123 naresh usa 152 singh delhi 101 vinay usa 123 naresh mumbai 156 raju chennai From the above data we need to retrive current data in a report ? how and explain in detail ?
Explain are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?
Explain what if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
What sort of existing documents should business analysts refer to when starting on a new project?
Explain the difference between detect alias and detect context?
Explain how many universes can be created in a project?
How would you format some text using css to be verdana and bold?
Explain what is the difference between slice and dice and cross tab report?
What are the steps to be taken to schedule the report?
WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S
any difficulitis have you phase while creating bo reports and how did u solve it
What are the general problems that are faced while importing the .biar files and what is the solution to overcome it in business objects?
Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye
How many universes can be created in a project?