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
what is document design in boxi,have u participate in that
How to restrict password to a user while sending a document in .pdf format
how to prepare the documentation in business objects and where to get the requirement?
What is a bo repository?
What is package in BO
1)I have createcd a dashboard on Bex query. How to refresh the Dashboard without hitting the bex query? 2)What is Event based scheduling in BO? 3) How to display the BO webi report title using a function? 4) For eg in my webi report iam having a person name like Jhon Peter Adam. But i need to get only the middle name of the person like Peter. What function is used in Webi to get this?
what is the difference between add link and include link in BO? Explain me with a scenario when to go for add link and when to go for include link?
how many reports have u created ? explain a few.
what are the day to day activities of BO administrator ?
Explain about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?
Explain what is the difference between slice and dice and cross tab report?
Explain how we drill up week to month?
What would you consider as your biggest achievement and why?
BO Security (creating the restriction sets in Universe and applying on selected groups or users) or Database security (Creating the tables in database insrting the user details in that tables and giving conditions in self restricting joins in Universe )Which Security will improve the performance of the reports and for best practices ? I am thinking BO Security will give the better performance, could you please share your thoughts on this please... Thanks...
what will be the contents for a functional requirements specifications