0
Former Member
May 12, 2008 at 09:54 PM

# Tricky BEx Question..

33 Views

Plant Order Oper Op Hit/Miss FE

1008 1000977 0010 0

1008 1000977 0030 0

1008 1000977 0110 1

1008 1000977 0130 1

1008 1000977 0150 0

1008 1000977 0210 0

1008 1001062 0010 1

1008 1001065 0010 0

1008 1001068 0010 1

1008 1001075 0010 1

1008 1001075 0100 1

1008 1001075 0260 1

1008 1001082 0010 1

1008 1001082 0100 1

1008 1001082 0190 1

1008 1001082 0260 1

1008 1001083 0010 1

1008 1001083 0100 1

1008 1001083 0190 0

1008 1001083 0260 1

Result 0

1200 1001086 0010 0

1200 1001086 0040 0

1200 1001086 0080 0

Result 0

If all operations get a hit (1) for the order then the order gets a hit (1) and I need to count then number of order hits for the plan. In this example (4).. The operation hit is calculated based on comparioson of the actual and scheduled dates (key figures) in the cube. Cube has data at the operation level and order and plant are characteristics.. I have a counter (exception aggregation by order) in the cube which I use to get the total number of orders by plant.

Plant Order peratio Op Hit

/Miss Order

Hit/Miss Order

Count Tot

Hit Tot

Miss

Hit%

1008 1000977 0010 0 0 1 4 3 57%

1008 1000977 0030 0

1008 1000977 0110 1

1008 1000977 0130 1

1008 1000977 0150 0

1008 1000977 0210 0

1008 1001062 0010 1 1 1

1008 1001065 0010 0 0 1

1008 1001068 0010 1 1 1

1008 1001075 0010 1 1 1

1008 1001075 0100 1

1008 1001075 0260 1

1008 1001082 0010 1 1 1

1008 1001082 0100 1

1008 1001082 0190 1

1008 1001082 0260 1

1008 1001083 0010 1 0 1

1008 1001083 0100 1

1008 1001083 0190 0

1008 1001083 0260 1

Result 0 4 7

1200 1001086 0010 0 0 1 0 1 0%

1200 1001086 0040 0

1200 1001086 0080 0

Result 0 0 1