Skip to Content
0
Former Member
May 31, 2006 at 10:13 AM

Problem in Result part

185 Views

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.....