Hi All,
I want to try an example for creating a virtual keyfigure. For this, I want to create a virtual keyfigure Sales Revenue and want to model price as an attribute of product(product id). Can anyone please tell me what code should i write in userexit to populate the data in reports.
Infocube name - <b>VCube</b>
<u>Characteristics:</u>
ProductID - <b>Pid</b>(has master data)
CustomerID - <b>Cid</b> (some other characteristic)
<u>ProductID has following infoobjects as master data.</u>
Price - <b>price</b>
Product name - <b>pname</b> (someother attribute)
<u>Keyfigures:</u>
SalesQuantity - <b>Sid</b>
SalesRevenue(defined as virtual keyfigure and it doesn't have any data in the fact table) - <b>Srev</b>
Using the infoobject names stated in bold letters and also the infocube name can anyone please tell me what code should i write in the user exit. Please follow the infoobject names stated in bold letters so that I can understand easily. I want to multiply the
sales quantity *price.
Please let me know....
Thanks,
Sabrina.