Datasphere - Dynamic date for restricted key figure

[otheroux]

Hello Community,

We are facing a challenge with Datasphere related to restricted key figures. We have a need to create a report with restricted key figure based on dynamic dates like Last Year to Date, Current Period, Current Period Last Year , Current Period YDT etc.

In BW, it was easy to do it with Customer Exit and variable, we are wondering if there is something like that in datasphere or we need to create SQL script for each key figure? We did find restricted measure variable in the model but we can only choose fix dates from there.

Also, another restriction we have is it needs to be done in datasphere and not in SAC because the report will be used with Analysis for Office.

Thanks

SAP Datasphere