Skip to Content
1
Sep 10 at 12:17 PM

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

78 Views Last edit Sep 13 at 12:44 PM 2 rev

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.

Attachments

link1.png (35.2 kB)
link2.png (24.8 kB)