return table in update rules
I know I can split records with return table in update rule, however this seems to be done by key figure. Do I need create the same logic for all key figure or only one key figure is ok?
For simple example you are getting price and quantity from data source and you want calculate Value and you are having separate key figure for Value in your target.
You achive this in 2 ways.
1. Field wise routine.
2. Start Routine.
if you want to write at field level you no need to maintain new keyfigure(value) in infosurce, you can calculate this either by formula or by routine.
But if you want to calculate at start routine, this nes KF(value should available in infosouce), then only it will be available DATA_PACKAGE in start routine. Then only you can assign formula. and also you have to map one-to-one in update rules.
Actually if you are creating a new infosource you can modify accordingly by adding requed fields, but when you are loading from one ODS/CUBE to another ODS/CUBE, data mart scenario, system will generate datasource and infosources. Then it will be a bit difficult.
Hope it Helps