Environment variable %COMPUTERNAME% into a txt cube

Nathan

Hello,

I'm trying to get the returning value of %COMPUTERNAME% variable in a data flow. I tried to the following solution :

• %COMPUTERNAME% and "%COMPUTERNAME%" in the target section and in an algorithm
• @COMPUTERNAME and "@COMPUTERNAME" in the target section and in an algorithm
• Using the ETL in a datareader with :
  • %COMPUTERNAME%
  • "%COMPUTERNAME%"
  • @COMPUTERNAME
  • "@COMPUTERNAME"

None of the above tries worked. Do you have any solution ?

USE CASE : I export a dataset with a dynamic path using %COMPUTERNAME%. I would like to feed a blob cube with this patch. So, I have multiple instance, dev_1, dev_2 and prod and would like the blob cube to be feed automatically without changing the instance name when migrating from an instance to another.

Thank you very much,

Helmut Heimann

Hi @Nathan ,

you're right, this substitution will work in extract/import scenarios only.

Please refer to the manual page

https://help.board.com/docs/extract-action-group
This describes the use of the environment variable for exporting data and it works similarly for the import, but only in procedures.

Best,
Helmut