Joining two SAC Planning Models on common key

[TApen]

Hi Experts,

I have a case that doesn't seem very sophisticated to me, but I can't really find a solution in SAC.

I have one model (PC_SALARY_GRPS), which has the Gross Salaries for every pay grade and month, where the users are also able to plan pay increases in 4 different versions. Then there is a second model (PC_DIV_POSITIONS), which has all roles that exist in a division. The role ID has the Role_Pay and the Incumbent_Pay as attributes. Those match the key of the pay grade from model PC_SALARY_GRPS.

What I basically want to achieve is joining the two models to get the gross salary to model PC_DIV_POSITIONS. I.e. if it were SQL I'd want to do something like:

SELECT p.*, s.Gross_Salary FROM PC_DIV_POSITIONS p
JOIN PC_SALARY_GRPS s ON p.[Role_ID].[Incumbent_Salary] = s.Salary_Group AND p.CALMONTH = s.CALMONTH AND p.VERSION = s.VERSION

I think I should be able to achieve this using data actions. I tried different approaches with the LINK formula, but that didn't lead anywhere. That may be because I'm an absolute beginner to data actions, though.

Do you have some advice for me?

Thanks!

[TApen]

I was mistaken to discard the LINK formula too quickly. It was the way to go, but I wasn't aware that I also have to link the dimensions that I don't want to perform the join on, which is very different to SQL.