1. I load .txt files to QV, but would like to have as well a dimension containing constant (the data type used in QV formulas). I was trying to use :
Set Data_Type = 'TGT-2012'
but this formula does not work. My current solution is to load 'TGT-2012 in Data_Type dimension via Load inline but I am sure it is more elegant solution
If you create a text object and set its value to =Data_Type, does it show TGT-2012? I tried this and it worked; I could see TGT-2012 in a text object.