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
CAN ANY BODY PROVIDE DESCRIPTION OF ONE COMPLEX UNIVERSE AND ONE COMPLEX REPORT IN BOS 6.5 TO SRINIVASBO@YAHOO.CO.IN
What is difference between custom hierarchy and report based hierarchy?
Explain is there any other repository domains rather than universe, security, document?
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?
What is top business?
Regarding Hyperlinking in Business Objects. We have a few reports in QA environment where a number of hyperlinks are employed using OpenDoc function.In some of the reports,hyperlink is used to move to another tab within the same report.The formula used include "DocID" and ReportName="tab name".This works fine but now,for the PROD move,this will not work as the Doc Ids are subject to change. Is there a way to overcome this?Without DocID,how will move to a particular tab? Thanks in advance
If I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?
what is the difference b/w the refresh and buffered data?
Explain about alerts in bos, under what situation we need to use alerts?
explain in detail about type 3?
what are the tables used in health care domain project and columns used in report?
If there are no indices defined on any of the columns in the above two tables, which columns would you index to speed up the left join query?
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
What is aggregate table and aggregate fact table ... Any examples of both?
Explain when to use local filter and when to use global filter?