on 01-08-2014 4:55 AM
Hi HANA Artifacts
Can i use Temporal joins in Calculation View (Graphical and Script)
Thanks in advance
Regards
Srinivas
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
This message was moderated.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
This message was moderated.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
90 | |
10 | |
10 | |
10 | |
7 | |
7 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.