User define variables in data tab

[Jodha]

Hi All,

I am using a text file to load data into TM1 cube . some of the coloumns in source file has different naming convention to dimension elements in TM1 so in order to map
it properly i am using user define variable to map the elements and load data as these are user defined varibales they get updated only after system generated code in data/metadata tab.
I want to skip elements that are not present in dimension using ITEMSKIP so that i can avoid errors in log file .

i got vDept as department variable defined from text file (data source ) i cannot use as is in TM1 so i made modification in user define variable

vTM1DepartmentName = X|vDept|Y in variable tab



In data tab before system generated code when i try to perform ASCIIouput on vTM1DepartmentName,vDept i can see only Xy, departmentname in the output

can any one tell me why vDept is skiped from vTM1DepartmentName variable even though vDept is data source generated variable and vTM1DepartmentName is already updated in Meta data tab so it should be avaiable in data tab.

I might be missing some basic point but i am intrested in knowing the reason for it .

Thanks for your time in advance

[qml]

It looks to me like your variable vDept is probably empty, because in the data source there is nothing in that column. Is that possible? Have you checked it? Can you show the code generated by the wizard here?

[tomok]

can any one tell me why vDept is skiped from vTM1DepartmentName variable even though vDept is data source generated variable and vTM1DepartmentName is already updated in Meta data tab so it should be avaiable in data tab.

The Metadata and Data tabs are independent of each other, they don't carry over from one to the other. That's why you have to define user-defined variables in both tabs. Also, all your custom code must go below the system generated code.

[Jodha]

Thanks for the replys qml/tomok
i have checked vdata and it not empty
if i define my user define variable vTM1DepartmentName = X|vDept|Y before ASCII code i am geting proper result(this is above system generated code )

Capture.PNG (3.79 KiB) Viewed 3389 times

i was refering to vCleanDept as vTM1DepartmentName and vDept as dDept
and this is in Data tab

[Wim Gielis]

Jodha,

This is all very unclear. At least to me.
Please show the full process code, and indicate what problem(s) you would still have.