Encrypted varaiables in Essbase calc script
Summary
Encrypted varaiables in Essbase calc scriptContent
Hi,
We have created calc script to extract balances to oracle database.
execute calculation "$1"."$2"."$3" with runtimesubvars "targetDbLogin = $key $4;targetDbPass = $key $5;";
We have passed variables for all parameters and we have SQL user/pwd encrypted.
Maxl works if I pass direct values for SQL user/pwd.
"targetDbLogin = $4;targetDbPass = $5;";
But when I give $key to pass encrypted values, I get error
"targetDbLogin = $key $4;targetDbPass = $key $5;"
ERROR - 1051041 - Insufficient privilege for this operation.
Am I missing anything here
Thanks in advance
0