Hi!
I have this in my script
//Qualify Currency;
Qualify *;
Unqualify CurrencyDate,Rate;
CurrRate:
Generic load
CurrencyDate,
currency as Currency,
p_rate as Rate
FROM [$(QVD_PathFinal)exchange_rate_final.qvd] (qvd);
Unqualify *;
//Unqualify Currency;
CurrencyDate is connected to my fact table in the script. So that connection works with all the CurrRate.EUR etc. The orphans are "CurrRate.Currency" and "Rate".
In the interface i've created an input field with the variable "Currecy" where i can choose which currency i want to present my volumes in.
What am i doing wrong?
Thanks,
A.