Problem in Result part

[Former Member]

Dear Guys,

I have one issue in Bex.

I am using the standard cube and custome ODS.

Cube : 0IC_C03

ODS : ZMM_O04

For reporting, i am using the above objects into one multi-provider.

In cube, my keyfigure is 0TOTALSTCK (Total Stock).

This object having default aggregation property Summation.

My issue is when i am using this object for reporting, result part is giving complete total. I dont want some keyfigures for calculating.

For example, my cube having following values.

0TOTALSTCK (Total Stock)

-

-

---

Value1 - 10

Value2 - 20

Value3 - 30

Value4 - 40

Value5 - -10 (Negative)

======

Total 90

======

Here i don't want to use negative values. I have to take only positive values.

For this, i gave condition saying that 0TOTALSTCK > 0.

After this condition rows has restricted. But result is coming as it is. It is not reflecting based on condition.

0TOTALSTCK (Total Stock)

-

-

---

Value1 - 10

Value2 - 20

Value3 - 30

Value4 - 40

======

Total 90

======

I should not touch cube, because it has already gone live.

I hope this issue is understandable.

Can any one give inputs.....

[former_member192142]

Hi,

Try this:

- Edit query

- Right click your key figure 0TOTALSTCK, select Properties

- In Calculate result as..., select Summation. Now it probably says (Nothing defined).

That should do the trick...

Hope this helps,

-Jacob