I have to load data for 15 markets to a single cube and there is a field MARKET.
I have created different Infosorces for loading data for different markets to the cube.
There is a field MARKET hardcoded in the transfer rule with the corresponding Market Code.
The Market Code is coming from the data file which is being loaded via Infopackage.
Is there any way we can pick the Market code from the file name loaded from the Infopackage and use it in the Transfer Rule for MARKET.
Any Routine and where to write it?
If the above case is possible then I will be using one Infosource instead of 15.
Thanks in advance..