Datasphere: Derive Value Restricted Measure Variable

[mitko1994]

Hello,

I have a requirement to define restricted measures that show values for Last week w.r.t to the week entered in the prompt. I can derive the last week from another view using a Derive Value variable, but I cannot use it in the filter for a Restricted Measure. Dynamic Default is not an option as it's derived before the prompt. Is there a way to work around this and somehow achieve the behavior of a Derive Value variable used inside a restricted measure?

[rushikesh_rajput]

Step 1 :


Step 2 :

[rushikesh_rajput]

Create an Input Parameter (IP)
Keep the Default Value Help as "Predefined Value from an Object"
Use the same IP in Expression editor with calculated measure

Create Variable in Analytic Model (AM) and Map it to the IP from backend fact view

Whenever user will access data via AM it will prompt automatically and as per input last week will be derived accordingly.

[mitko1994]

Thank you for your proposal, although It's not completely clear to me. By the looks of it, "Predefined Value from an Object" doesn't support views with IPs. So how can I derive the previous week without passing the reference week from the prompt?