Interested to Buy Any Domain ? << Click Here >> for more details...
How do you find what type of trap is there by seeing the
report?
- 4 Answers
- 7674 Views
- TCS, I also Faced
- E-Mail Answers
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
What sort of existing documents should business analysts refer to when starting on a new project?
What is the difference between datawarehousing and businessintelligence?
Explain what if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?
What is the difference between the public object&schema object?
What are all the points to keep in consideration, while we are migrating the Universes,Reports from BO5.1.6 to BO 6.5? Is is compatible to migrate like this? Does it effect the filters in Reports and Join in the Universe?
What is difference between custom hierarchy and report based hierarchy?
What is a bo repository?
In banking domain how many Fact tables,Dimension table are present?
in sap bi we have wad, then why we go for sap bo
What would you consider as your biggest achievement and why?
Its regarding Javascript coding for customization in BI4 reports. We need to have all the options disabled in the report except the option to Export(save the report in computer in Excel/pdf formats). I am able to hide TopBar,TabBar,Left Navigation etc but I need "Export" option to be displayed to the users in Read mode. Can this selective "hiding" be achieved?
If I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?
What task is 98% of the required work of a business analyst?
What is the profile and package?
