How do you find what type of trap is there by seeing the
report?
Answers were Sorted based on User's Feedback
Answer / sj
We can find out Chasm trap and Fan trap by just viewing the
table schema.
If we have many to one to many relationship between three
tables that is a chasm trap.
If we have one to many,one to many relationship between
three tables that wil be a fan trap.
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / 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 |
by viewing we can define weather it is fan trap or chasm trap
Fan trap: When three tables were joined in one to many relationship then it is fan trap.
Chasm trap: when two fact tables depend upon the same lookup table then it is known as chasm trap.
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / pradiip
As per my understanding we can find the traps only by the cardinalities of the present tables and the other best way is 'Detect Context' because if there is more then one way/Context to achieve the results definitely there is a trap. it may be Chasm or Fan.
Is This Answer Correct ? | 0 Yes | 0 No |
can anybody tell me about issues faced while creating reports
1 Answers Accenture, Tech Mahindra,
Is it possible to join more than one universe in Business Objects? If its so how is that possible ? thanks in advance for the answers
how to coneect to a server in a business objects
What is casual dimension?
What is the need of live office connector
Example Country Name is like India/UK or ALL In parameter I selected India or UK it should show only perticular country details in BO.If i select ALL in parameter.It should show both country data in different tables.
1. what are the differences between prompt at universe level and prompt at report level ? 2. what are the connection types in BOXI ? 3. how do we give the security in universe level ? and report level ? and objects level ? 4. what will happen if we check the 'MULTIPLE SQL STATEMENTS FOR EACH MEASURE' option in Universe SQL parameters ?
Can any body Explain me what are the critical problems you have faced in the designer and repoting level in the real time environment?
Explain how to schedule the report in b.o?
CAN ANY BODY TELL WHAT FUTURE CAREER IN BUSINESS OBJECTS?
Explain the SQL Queries activated to data base from Data provider in BO ?
What is the difference between Report Bursting and Report scheduling?Explain both of them in detail?