Lookup Function in SAC Model : Lookup function can be leveraged to fetch metric value restricted on dimension values. The function also provides option to ignore specific dimensions.
Syntax: LOOKUP([Account], Filters , Ignored Dimensions)
Use case: Requirement is to calculate the actual value based on allocation %. Allocation % is keyed in by business users at different granularity. In below example, "Value" metric is available at Project, Domain, Location, Date granularity.
Allocation% - input provided by user for each project across different departments. This input is irrespective of dates.
In such scenarios, where we input metric without date, value automatically gets distributed across dates ( based on the planning date range or based on date range filter if applied)
In such scenario, where we do not want values to be distributed, one option is to set the aggregation type to "None".
In summary , calculated metrics can be define in model level even if account measures used in calculations are at different granularity. This option helps to define calculations dynamically in real time. Based on the data volume and report performance, we can also think about persisting the intermediate calculation values in model leveraging the advanced scripting. But in such case, changes in input will not reflect the calculations rather we need to execute the data actions to get the modified calculated values.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
12 | |
12 | |
5 | |
5 | |
5 | |
4 | |
4 | |
3 | |
3 | |
3 |