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
- 7441 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 we need to discuss with designer before starting the universe designing.
Explain what is the difference between business requirement document and use case document.
How many universes can be created in a project?
(1) Is it possible to create measures using objects from different context. (2) If cross context measures are not possible then what about @aggregate_aware() function ,here we use objects from different contexts. (3)Two measures from two different context ,can they be summed at report level.
What is the dense rank?
What Is The Difference Between Oltp And Olap?
Difference between b.o 5.1 and 6.1b?
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 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?
CAN ANY BODY PROVIDE DESCRIPTION OF ONE COMPLEX UNIVERSE AND ONE COMPLEX REPORT IN BOS 6.5 TO SRINIVASBO@YAHOO.CO.IN
How would you format some text using css to be verdana and bold?
How to restrict password to a user while sending a document in .pdf format
Explain what are the steps to be taken to schedule the report?
what is document design in boxi,have u participate in that
What is the difference between absolute and relative div positioning?
