You can visually detect potential chasm and fan traps in your table schema by arranging the tables in the Structure pane so that the "many" ends of the joins are to one side of the pane, and the "one" ends to the other. The example below shows the Beach universe schema arranged with a one to many flow from left to right.
Potential chasm trap
The potential chasm traps are shown below:
Both of these join paths have been separated using the contexts Sales and Reservations.
Potential fan trap
A universe schema for a car sales database is shown below:
The potential fan traps involve the following tables
Tip:Once you have populated your schema with the necessary tables, don't start defining objects immediately. Allow some time to move tables around so that you have the all the one-to-many joins in the same direction. Designer is a graphic tool, so use the visual capabilities of the product to help you design universes. An hour or so moving tables around could save you a lot of time later in the design process.
SAP BO Related Interview Questions
|SAP BO Interview Questions||SAP ABAP Interview Questions|
|SAP BW Interview Questions||SAP BPC Interview Questions|
|SAP BODS Interview Questions||SAP BDC Interview Questions|
|SAP BW on HANA Interview Questions||Sap Bapi Interview Questions|
|Sap Business One Interview Questions|
Sap Bo Tutorial
Doing Basic Operations
Creating A Schema With Tables And Joins
Resolving Join Problems In A Schema 4
Working With Olap Universes 6
Creating Stored Procedure Universes
Creating Universes From Metadata Sources
Using The Sample Materials
All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd
Wisdomjobs.com is one of the best job search sites in India.