Page 1 of 1
hardcoding values in turbo integrator
Posted: Thu Jul 29, 2010 5:06 am
by angel1234
hi,
in turbo process in variables tab i inserted a variable which tooks only three values which is supposed to be hard coded.How can i give that in formula?
My variable takes only three values h1,h2,h3
i wrote like v1='H1'||'H2'||'H3';
but not working
Can anyone tell me how to do that??
regards
Angel
Re: hardcoding values in turbo integrator
Posted: Thu Jul 29, 2010 5:46 am
by rkaif
You need to replace the double pipe || signs with the single pipe | sign.
So the formula in your Variables tab should be:
by doing this you will get the value
H1H2H3 in the variable v1
Hope it helps!
Re: hardcoding values in turbo integrator
Posted: Thu Jul 29, 2010 6:32 am
by angel1234
hi,
i dont need like concatenating h1h2h3
i need any one of the elemnts at a time
i my data is like this
h1,number,20
h2,number,21
for that i created two dimensions dim_house and dim_number
dim_house should take either h1 or h2 or h3 at a time....
i need to hardcode this in the ti process variable tab
how can i do it??
hope you understand my problem
regards
angel
Re: hardcoding values in turbo integrator
Posted: Thu Jul 29, 2010 4:49 pm
by rkaif
If I am not wrong then the dim_house and dim_number are related to each other. First one has got the house and the other dim has got the house numbers. If this is the case then you have to re-think how you are modeling your cube.????
Secondly if the h1, h2...values are already in your data source then why you want to hardcode the value????
The process you are writing, is that to create dimension or to load data in the cube???
You need to tell us more about the requirements...attach a sample data and process which you are working on.
Re: hardcoding values in turbo integrator
Posted: Thu Jul 29, 2010 10:18 pm
by Martin Ryan
I think you're trying to say that the user must choose one of three values, and if they don't, then you want to reject it? If that's what you mean, here's a way
Prolog:
Code: Select all
errMsg='';
if(v1@<>'h1' & v1@<>'h2' & v1@<>'h3');
errMsg='You have not chosen a valid option';
ProcessBreak;
endif;
Epilog:
Code: Select all
if(errMsg@<>'');
ItemReject(errMsg);
endif;
HTH,
Martin