I've found a way to do it the way I was expecting to do it.
Thank youWodnik for unlocking the thought process, my objective was a bit more dynamic than hard coding the number of rows but the input was critical to make me understand it was possible to do it as I had imagined it.
The problem was I was trying to access the DB directly instead of accessing the Temporary tables and when I tried to access the temporary tables I had the delivery as "Enable but do not Execute" so the targetData variable was empty...
Another problem was the change Dimension that does not keep the previous data without the steps bellow.
So future reference to any one this is was the solution: