Detecting join problems graphically - SAP BO

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.

Detecting join problems graphically

Potential chasm trap

The potential chasm traps are shown below:

Potential chasm trap

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:

Potential fan trap

The potential fan traps involve the following tables

  • CUSTOMER, LOAN, and LOANLINE
  • CUSTOMER, SALES, and SALELINE
  • VARIETY, PRODUCT, and SALELINE

Potential fan trap

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.


All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status

SAP BO Topics