cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

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

andreasja_schneider
Product and Topic Expert
Product and Topic Expert
0 Likes
953

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.

Accepted Solutions (0)

Answers (1)

Answers (1)

N1kh1l
Active Contributor
0 Likes

@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/2784376d431e4a7da9564...

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/49f72825191b4c0780ebe...

 

Hope this helps !!

Nikhil

 

andreasja_schneider
Product and Topic Expert
Product and Topic Expert
0 Likes
Thanks, Nikhil .