Question Re: SAC - Difference between formulas using RESTRICT, LOO... in Technology Q&A

SAC - Difference between formulas using RESTRICT, LOOKUP, RESULTLOOKUP?

andreasja_schneider — Wed, 21 May 2025 13:22:16 GMT

Hello folks:

Please, can someone explain the differences, best with a vivid example, beetnw the formulas

RESTRICTED, LOOKUP, RESULTLOOKUP

when defining a calculated measure in an SAC model?

Thanks in advance,
Andreas J.A.

Re: SAC - Difference between formulas using RESTRICT, LOO...

N1kh1l — Wed, 21 May 2025 15:19:20 GMT

@andreasja_schneider

RESTRICT respects the filtered member and ignores the calculation against the non restricted member where as LOOKUP will show a results against each member including the ones which are not being looked up.

Refer here for explanation.

https://help.sap.com/docs/SAP_ANALYTICS_CLOUD/00f68c2e08b941f081002fd3691d86a7/2784376d431e4a7da9564880dadb084d.html?q=LOOKUP#how-to-use-restrict-and-lookup

RESULTLOOKUP is even more restrictive as it requires looked member to be in drilled state in the table, else it will not show any results. Also allows only single members as lookup criteria.

https://help.sap.com/docs/SAP_ANALYTICS_CLOUD/00f68c2e08b941f081002fd3691d86a7/49f72825191b4c0780ebe5642b095de5.html?locale=en-US

Hope this helps !!

Nikhil

Re: SAC - Difference between formulas using RESTRICT, LOO...

andreasja_schneider — Thu, 22 May 2025 08:32:44 GMT

Thanks, Nikhil .