Skip to Content

Can i Use Temporal Join

Hi HANA Artifacts

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

Thanks in advance

Regards

Srinivas

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • Best Answer
    Posted on Jan 08, 2014 at 06:12 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 08, 2014 at 05:56 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 21, 2016 at 10:03 AM

    This message was moderated.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 23, 2016 at 03:56 AM

    This message was moderated.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.