URL expression with Dimension Variable in Script Variable

[JWTA]

In URL/Expression window I have this (simplified url) and this works

='http://mycompany.net/jump.ashx?employeeId=' & [Employee Id]

I’m going to use this in 10+ places so like to put this in a Script variable

Cannot figure out the syntax for referencing the dimension in a script variable, so I created a script variable for the dimension, Employee Id

In Script

vEmpId ='[Employee Id]';

in the URL/Expression Window, the variable works

='http://mycompany.net/jump.ashx?employeeId=' & $(vEmpId)

But when I tried to put that statement into the script format and I cannot figure out how to do it

varURL = ='http://mycompany.net/jump.ashx?employeeId=' & '$'&' (vEmpId);

varURL = ='http://mycompany.net/jump.ashx?employeeId=' &  chr(36) & (vEmpId);

Surprisingly I am getting a lot of

Thanks in advance

[MatheusC]

Will bring this to different places in the front-end view? Perhaps bringing it as a field might already be what you're looking for.

Table:

LOAD

     A

     B...,

     'http://mycompany.net/jump.ashx?employeeId=' & [Employee Id] as URL    

FROM [lib://] (qvd) ;


Regarts, Matheus

[JWTA]

thank you for the suggestion!   Though, probably don't want to go with that route as I don't want to clutter 10+ tables with the URL address.   I'll just continue with the expression.