Skip to Content
0
Dec 29, 2021 at 10:40 AM

Modify the filter on restricted measures

144 Views

Hi,

I have two restricted measures in SAP Analytics Cloud - Current Quarter Data, and Previous Quarter Data.

I want to be able to dynamically change these quarters based on setting a value - for instance - if i set a variable 'Current Quarter' as 2021-Q4, it should automatically set the filter of current quarter data to 2021-Q4, and previous quarter data to 2021-Q3.

I am aware that we can use lookbacks in time ranges for this, but I do NOT want the current quarter to change automatically, and instead have control on what the 'current quarter' variable is.

Is there any way to implement this - wherein changing a variable such as current quarter would modify the filters on these restricted measures.

Thanks and regards,

Kavya Kathuria