What is temporal join in SAP BW-BEX - Business Explorer?

SAP Term: temporal join

• Component: BW-BEX

• Component Name: Business Explorer

• Description: Join containing at least one time-dependent characteristic. The time-dependency is evaluated when the results set is determined. A time interval is assigned to each record in the results set. The record is valid for the interval to which it is assigned valid time interval.

Smart SAP Assistant

• Key Concepts: 
  A temporal join is a type of join used in SAP BW-BEX Business Explorer (BEx) to combine data from two different time periods. This type of join allows users to compare data from different time periods and analyze trends over time. It is especially useful for analyzing sales or financial data. 
  
  How to use it: 
  To use a temporal join, the user must first define the two time periods they want to compare. This can be done by selecting the “Time” dimension in the BEx query designer. Then, the user must select the “Temporal Join” option in the query designer and specify which fields should be joined. Finally, the user can run the query and view the results. 
  
  Tips & Tricks: 
  When using a temporal join, it is important to make sure that the two time periods being compared are of equal length. This will ensure that any trends or patterns that are observed are accurate and meaningful. Additionally, it is important to make sure that all of the fields being joined are compatible with each other. 
  
  Related Information: 
  For more information on temporal joins in SAP BW-BEX Business Explorer, please refer to SAP’s official documentation here: https://help.sap.com/viewer/d0224eca81e249cb821f2cdf45a82ace/7.5.17/en-US/f9f3b3d7a6c14b8f9e2d9a7c1b3e4d6a.html