Question:
Hi,
I am loading some data to an Infocube from an Infosource. I have some characteristics with attributes, and I would like to add a key-figure in the Infocube, that should be the result of one of the key-figure * an attribute of one characteristic.
For example I have the Average moving Price of a Part Number in the 0MAT_PLANT char, and I am loading from an Infosource the amount of stock for a specific Part Number and Plant.
I’d like to add a key-figure on the cube that is the result of Price * Stock, where the Price must come from the Master Data of 0MAT_PLANT, from that Material and Plant I am loading.
I tried to do that with a formula on the update rules, hoping that all the attributes of the characteristics used would be available, but I was not able to do that.
Do I have to create a more complex routine or what?
thanks
Answer:
read the master data table into an internal table in your start routine
then access the internal table in your individual update rule