When I am selecting the SBU in the List box and I select the SalesType on the other list box than I am not able to see the value for the target which is coming from the above script than it does not show the value.
But when i remove the Concatenation I get the value.
But I have to use the concatenation as I have to get the value in my fact table.
I think I have to apply force concatenation by Sales Type field.
While it is quite difficult to get to your real scenario just by looking at the script.
But, at first look it seems that..
Your SBU and target are coming from last table which you are concatenating to the above table but your salestype field is not there in the table which you are concatenating and this is not a perfect concatenation.
So, for every value of target Salestype is null (you are force concatenating), and viceversa.
So, when when you just select SBU, you will see values in target but as soon as you select Salestype, you will not see values in target.
But, when you don't concatenate, you see values because of associative links or same will happen when you join the tables.
So, to solve your case what you can do is that first make a concatenation without salestype in 1st table then join the salestype to the final table after concatenation using the appropriate keys or rather then join you can just keep them associated.
