Question:
OK, We have an InfoObject which has a KF as a attribute of the Characteristic.
0MATERIAL (Material) has 0WHOLESALE (Wholesale Price, Currency) defined as an attribute.
The question I have is:
Is there anyway I can use that Wholesale price in creating a calculated KF in a Cube?
Example: Say I have a cube of Orders, 0MATERIAL being one of the objects in a dimension. And I have a KF in the Cube of "Total Units". I wanted to create a total wholesale cost for that material by multiplying the Wholesale Price (attribute of 0MATERIAL) with the "Total Units".
I would like to be able to do this w/o modifying the data load into the cube if possible, but I just had a thought, and I don't know if this solution will work but:
Could I load the wholesale price as a KF and pull it from the 0MATERIAL matching on 0MATERIAL to add it in for each order? I guess that would recquired loading 0MATERIAL and the 0WHOLESALE in a temp table to pull from to do this???
Thanks,
Stephen
Answer:
sbobcat
treat 'total wholesale cost' as a virtual key figure, ie map the key figure in the update rules as initial value.
then in the vkf user exit program a lookup to 0MATERIAL master data table (keyed by material number & an object version of 'A')
to find 'wholesale price' & multiply by 'total units'.
there is good paper on vkfs on the SAPNET BW pages
Answer:
Thank you for the suggestion and pointing out the article. It worked like a champ!
Answer:
You should be able to do this with formula variable.