Can i Use Temporal Join

[SrinivasReddy]

Hi HANA Artifacts

Can i use Temporal joins in Calculation View (Graphical and Script)

Thanks in advance

Regards

Srinivas

[rindia · Accepted solution]

Hi Srinivas,

A temporal join is time interval mapping between the master data and the transaction data.

The temporal join must start from the fact table such that the single column must be in the fact table and, the to and from columns must be in the table that is directly joined to the fact table. The join type must be Referential. The supported data types are: timestamp, date, and integer.

So technically speaking we can use Temporal Join in Calculation view.

Here is how:
In calculation view add two projection nodes. One projection is on fact table and the other on dimension table. Join these two projections using Join node. Inside this node make two joins coming out from a fact table to dimension table and make each join as referential.

The better way of doing this is doing the same in logical join of Analytic view instead of Calculation view.

Regards

Raj

[SrinivasReddy · Accepted solution]

Thank You Raj

[rindia · Accepted solution]

When I tried to build, found that there is no referential join available in CA view?????

[former_member185165 · Accepted solution]

Hi Raj,

Yes temporal join is available only with Analytical view as I said earlier.

Regards,
Vijay

[rindia · Accepted solution]

You are right Vijay.