cancel
Showing results for 
Search instead for 
Did you mean: 

SAC - data action - adv formulas : driving LINK function with Attribute or ResultLookup

former_member767054
Participant

Hello everybody.

I'm trying to read salary scales into a model from another one.

I'd like to populate a technical account with the relevant annual salary, dynamically according to seniority (stored in another technical account) and the salary scale which is a property of my Employee dimension.

The below formula is correct :

DATA([d/Compte] = "BAREME_ACTU") = 
LINK( [BAREME_PLAN], 
[d/Date]="202112", 
[d/Version]="Actual", 
[d/BAREME]=ATTRIBUTE([d/EMPL].[p/Bareme]), 
[d/ANNEE]="30") 

... but of course the same salary scale is spread on all employees.

When I try to use "Resultlookup" or "Attribute" to achieve what I need to do, issues are starting ...

Do you see what is not correct in my syntax ?

Thanks in advance.

Guillaume P.

Accepted Solutions (0)

Answers (0)