on 01-26-2014 9:18 AM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.