Key Figure issue in Infocube

[former_member201264]

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.

[Former Member]

hi,

Using Rule Group at transformation with out code,, you can achive this result

[sander_vanwilligen]

Hi Sreeni,

Aggregation behavior is dependent on the settings in the Key Figure (i.e. aggregation and exception aggregation). For Quantity and Total Price it is OK. However, for Price aggregation does not make sense.

I suggest to leave Key Figure Price out of the InfoCube if you do not need anything like "average price". You can derive the (average) price by a BEx formula: Total price divided by Quantity.

Best regards,

Sander

[ccc_ccc]

Hi Sreeni,

By default data will aggregate in cube hence your able to see 500, if you want 900, you have to write formula in transformation or in BEx report.

Regards

Nanda

[former_member201264]

Hi Nanda,

I am OK with your reply.

But see the below case.

I have one sales order with

Customer_ID        Material_ID      Quantity     Price     

C001                    M001               10               10         

after delivering this SO to customer , we have created one more SO as below with new Price and QTY.

Customer_ID        Material_ID      Quantity     Price     

C001                    M001                 90              10         

If i compress in cube i am going to get as below:

Customer_ID        Material_ID      Quantity     Price     

C001                    M001               100               20 

here price become 20, but it should not be 20 right.

how to handle these kind of things in info cube?

Regards,

Sreeni.    

[ccc_ccc]

Sales order won't be duplicate, all are unique.

[former_member201264]

Hi Nanda,

I agree with you.

One more case with standard Infocube.

do we need to write the rule for every info cube particularly for standard info cube to get total revenue based on the quantity sold and price values?

Regards,

Sree.

[ccc_ccc]

Hi Sreeni,

Generally standard infocube might have predefined formula for revenue, pls check if not yes we have to write or create formula in BEx level.

Recommended create formula at BEx level.

Regards

Nanda