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.

[Jairo_Nieto]

A temporal join only can be used in cube with star join node, and the join must be inner.

To achieve this, you need two projections. The first one acts like fact table, so this must to have at least one measure, and one time dimension that will be join between the range of dates. Te second view acst like dimension table, and this one must to have two dates, the from and to dates. When you create the join you should match the date that is on the fact table with the two dates that are on the dimension table

temporal-join.png

[former_member264321]

This message was moderated.

[Former Member]

This message was moderated.

[former_member185165]

Hi Srinivas,

Temporal join is available only with analytical vie and not for calculation view. The temporal condition is only with OLAP engine.

Regards,

Vijay

[SrinivasReddy]

thanks for the reply Vijay

Best Regards

Srinivas