How to create a dynamic offset variable in SAP Datasphere?

[BW1]

Dear all,

We have the following requirement which could be easily implemented in BW. 
In Datasphere we were not able to find a solution yet.

Request:
- Analytical Model with one input ready date variable (single date)
- Restrict certain measures with "posting date = 'value from variable' - 365 days"

The calculation is not possible in analytical model. We get the following errors:

Formula in restricted measure: CAPostingDate = (:NET_DUE_KEYDATE - 365)
Error: Operand "365" with type "number" is not compatible to operand "CAPostingDate" with type "cds.Date"

As it needs to be dynamic based on user input there is also no possibility to push it down to fact view. 
Did anyone had the same problem?

Thank you
Timo

[klorn_pallier]

Try see if you can use the ADD_DAYS Function

[BW1]

Thank you but unfortunately it is not possible to use functions in restricted measures.