Query Problem

[Former Member]

Hi Guys,

I have a query problem

In my Cube i have the following char / k.f

Plant, Material, Std Price, Qty.

P1, M1, 10, 50

P2, M1, 11, 10

P3, M1 12, 25

P1, M2, 27,5

P2 M2, 22,10

.

.

ETC..

I have standard price as both attribute of 0mat_plant as well as k.f in the Cube.

Std Price is only valid if the query output contains Material.

I need to calculate the value_CKF = Std Price * Qty at the query level and display the result at Plant level.

The problem is if i drag material from the query output, the calculated k.f value_CKF is calculated wrong. i:e the std Price field is aggregated to the plant level and then it is doing the calculation

I would like the output as

Plant, Qty, Value_CKF in the query output.

P1, 37, xxxx

Thanks

Niveda

[Former Member]

Dear Niveda,

if you tyr to multiply rate with quantity at plant level it will agregate the rate at plant level and calculate the value whihc is wrong.

what you can do is insert a new key figure into you cube and update the same using a formula, rate * qty , in this way the value will get calculated at each record level and you can use this key figure in you query and it will give you the correct result.

hope this clarifies your query.

Regards

Venkata Devaraj

[Former Member]

Hi Niveda,

This problem you must solve in the update rules of your Cube.

You need to add CKF to your key-figures an calculate it in the update rules.

hope this helps,

Udo

[Former Member]

you do not need to calculate in your update rules you just need to be careful about how the calculation is handled and/or normalized. I can send you a DECK if you give your email address.