hardcoding values in turbo integrator

[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

[rkaif]

You need to replace the double pipe || signs with the single pipe | sign.

So the formula in your Variables tab should be:

Code: Select all

v1='H1'|'H2'|'H3';

by doing this you will get the value H1H2H3 in the variable v1

Hope it helps!

[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

[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.

[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