I am having challenge in understanding the RESULTLOOKUP[d/dim1] vs [d/dim1] statement. Below is the one of the example i have considered.
what is the difference between the statement RESULTLOOKUP[d/dim1] = 'ABC and [d/dim1], basically To get the value(to read the value) we will use the RESULTLOOKUP but in this case, when using the resultlookup i am getting the error. Can someone please help what is the difference between the statement resultlookup[d/dim1] vs [d/dim1]
Only the first syntax is valid, the second one is not a valid syntax in SAC. RESULTLOOKUP is used to read the fact data ( transaction data ) from model by specifying the intersection in terms of dimensions with the RESULTLOOKUP() statement. You cannot use RESULTLOOKUP to read attributes.