Skip to Content
0
Former Member
Jan 03, 2008 at 03:57 PM

BEx query - change results via program before rendering?

9 Views

I have a BEx query based on a Left Outer Join InfoSet. I need to evaluate the results prior to handing them over to BEx to render. I am working in 7.0

My InfoSet is based on a cube and a DSO.

Cube is sales, the DSO is Bill of Material. The DSO lists parent materials and the component materials the make up the parent material. The Component material can also be sold separately and be listed in the Sales cube as a parent material.

My results look like this:

Material Sales Qty Component Material Component Qty Total Qty

1000 10 50A 5 50

1000 10 70C 4 40

50A 500 N/A N/A 500

If you notice, 50A is a parent and component material. When it is a parent material, it does not have a component material in the DSO. That means it returns nothing.

I would like to evaluate the parent material, if it doesn't have a component material in the DSO, then dynamically place the parent material into the component material field. Then add a component Qty = 1.

This is what I'd like to see:

Material Sales Qty Component Material Component Qty Total Qty

1000 10 50A 5 50

1000 10 70C 4 40

50A 500 50A 1 500

Does anyone know how I can do this with code?