cancel
Showing results for 
Search instead for 
Did you mean: 

Graphical view with non equal join

Former Member
0 Kudos

Hello,

We are trying to develop a graphical calculation view or analytical view with non equal join.

for example: we need to calculate daily balance and for this we want to drag a posting record to future dates.

posting date: 03/01, amount: 100$

this record will affect 04/01, 05/01 etc.

The non equal join is >= and not between condition.

Appreciate you're help,

Oshrit.

Accepted Solutions (0)

Answers (2)

Answers (2)

raghavendra_n
Explorer
0 Kudos

Hi Amir,

You can use either of the following approach.

1) temporal join: Define a referential join between date field of fact table & attribute view. And select from & to date from attribute view as temporal interview. Add filter on from date (>=03/01) .

2) Restricted measure: Create the measure daily balance. Create a restricted column with daily balance as a base measure and add a restriction on date attribute with >=03/01.

Regards,

Raghu

former_member182302
Active Contributor
0 Kudos

Hi Amir,

If you are using SP05 , you can use Temporal join to achieve it. It has some limitations too.

You may want to have a look on a similar thread:

Regards,

Krishna Tangudu