Skip to Content
0
Former Member
Nov 03, 2005 at 03:05 AM

Hierarchy presentation problem

28 Views

Hi Bex Gurus,

I have created a product BOM hierarchy on 0material info Object. Here is what I need to present the hierarchy for the material usage on this BOM hierarchy structure :

  • On Bex:

Product Hierarchy Request Qty

================= ===========

PC001 100

CPU-300hz 100

RAM-512M 200

MotherBoard-ABC 100

USB-001 100

Serial Port1 100

  • lines in the cube:

Lines in the Cube:

PC001 100

CPU-300hz 100

RAM-512M 200

MotherBoard-ABC 100

USB-001 100

SerialPort1 100

But in fact BEX will show:

- at level PC001, KF(Request Qty) has the aggregated value: 700= 100100100200100+100

- at level MotherBoard-ABC, KF(Request Qty) has value: 300

How can I suppress the aggregation at high level nodes with sub nodes here? As it doesn't make sense to say you only have 100 CPU but after adding other parts to make more than 100 PCs.

Any suggestions or work around?