ResultLookup vs. Lookup
In SAP Analytics Cloud, the dimensions that are defined in the ResultLookup formula need to be in the current drill state. Also, you can filter on only one value.
-
ResultLookup is not supported for non-standard time periods such as week-level granularity and user-managed time dimensions.
-
ResultLookup functions only work when the member has a single parent. If the member is present under multiple parents, the formula is invalid.
Because value driver trees only include information about the Account and Time dimensions, ResultLookup formulas often don't show any data in value driver tree nodes.
With Lookup, the dimensions defined in the Lookup formula don't need to be in the current drill state, and you can maintain more than one member in the filter expression.