Skip to Content
0
Former Member
May 08, 2005 at 04:45 AM

Code for Virtual keyfigure

60 Views

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.