manangement of variables with multiple QVWs

[#1]

Looking for recommendations to manage variables than are common across muliple QVWs.  Customer wants to manage their KPI's centrally and use them across multiple QVWs.  Any input welcome here.

Thanks,

Kevin

[#2]

Hi,
Create the script and copy it to a text file that are stored centrally. Use $(Include=PathToTextFile) in every .qvw...

/@Ungvall

;

[#3]

I keep all of my standard variables/expressions in a spreadsheet that I load with each qvw.

UserVariables:
LOAD Variable_Name,
Expression as Variable_value,
Description
FROM Expression_Variables.xls (biff, embedded labels, table is varCalc$);

for i=0 to noofrows('UserVariables')-1
LET var_name= peek('Variable_Name',i,'UserVariables');
LET $(var_name) = peek('Variable_value',i,'UserVariables');
next i;

This allows me to have all of my frequent expressions available with the call of a $(variable) and also allows me to update all of the expressions in multiple documents in as long as it takes to reload.