Skip to Content
0
Dec 16, 2015 at 03:09 PM

Key Figure issue in Infocube

20 Views

Hi Gurus,

I have created and loaded data into infocube as below:

Flat File Load :

Customer_ID Material_ID Quantity Price Total_Price

C001 M001 10 10 100

C001 M001 20 20 400

Then Loaded Data in Cube:

Customer_ID Material_ID Quantity Price Total_Price

C001 M001 30 30 500

But as per Quantity*Price = TotalPrice, File load data is correct.

But when we load it into cube, it has to be 30*30= 900 right?

How to achieve this in an info cube without Transformation Rule like QTY*PRICE for the TOTAL PRICE?

Regards,

Sreeni.